• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

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
0
joan2006
Asked:
joan2006
  • 2
1 Solution
 
jeebukarthikeyanCommented:
hi,

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.ToString()


b u d d h a
0
 
joan2006Author Commented:
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?
0
 
jeebukarthikeyanCommented:
hi,

follow this link

http://aspnet.4guysfromrolla.com/articles/091102-1.aspx

it may help u
b u d d h a
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now