?
Solved

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

Posted on 2006-10-31
3
Medium Priority
?
256 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

800 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