Grouping Data for an ASP.NET Control

[Dimitrie1]

I have an item table which contains serial numbers, type, categories etc. I need to be able to create a control with the data grouped.

I tried createing a stored procedure that wrote to a temp table but I can't access the temp table from the control.

any ideas? I don't have code to show because I'm having trouble starting. This question is 1/2 sql, 1/2 asp so I wasn't sure where to post.

I don't want to create a real table because I'm not sure how many users will be trying to access it

 

[mrdenny]

Take your stored procedure, and instead of just loading a temp table return the data as a result set so the control can access it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Dimitrie1]

thanks

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com