Solved

Create HTML table in ASP.NET using MS SQL Stored Proc

Posted on 2006-10-31
3
220 Views
Last Modified: 2006-11-18
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
Comment
Question by:joan2006
  • 2
3 Comments
 
LVL 13

Expert Comment

by:jeebukarthikeyan
ID: 17842054
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
 

Author Comment

by:joan2006
ID: 17842136
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
 
LVL 13

Accepted Solution

by:
jeebukarthikeyan earned 500 total points
ID: 17842300
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now