joan2006
asked on
Create HTML table in ASP.NET using MS SQL Stored Proc
Hi,
I need to create a html table based on a sql query in asp.net. I want to call a stored procedure in MS SQL Server that will do this for me. I would use a datagrid BUT i have to use a button in multiple cells [the last two columns]. I will then need to be able to click on the button and do an update query and disable the button.
Can someone please help me with this.
Thanks!
J2006
I need to create a html table based on a sql query in asp.net. I want to call a stored procedure in MS SQL Server that will do this for me. I would use a datagrid BUT i have to use a button in multiple cells [the last two columns]. I will then need to be able to click on the button and do an update query and disable the button.
Can someone please help me with this.
Thanks!
J2006
ASKER
buddha ... i am fairly new to asp.net... is there a site where i can go to view some code on how to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1.take the output form the stored procudure
2.store it in a dataset.
3.loop the dataset
4.create stringbuilder obj
5.create an html table with the stringbuilder
6.assing the string builder text to a label control
lblhtml.Text=strobj.ToStri
b u d d h a