Solved

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

Posted on 2006-10-31
3
229 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

813 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

13 Experts available now in Live!

Get 1:1 Help Now