how to write a database value to a table in table formate

Raghavendra Joshi

Hi,

I want to write a html table dynamically from a console application which has to fetch data from a sql database table and format as a table.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

samanta12y ago
http://forums.asp.net/t/1780118.aspx?How+to+bind+records+into+HTML+table+instead+of+Grid
0
Jignesh Trivedi12y ago
hi,

Please refer below link it might help you.
http://www.derektrauger.com/Blog/tabid/59/articleType/ArticleView/articleId/58/Converting_a_DataTable_into_HTML_Using_C.aspx
0

CREATE TABLE #temp_table (eid INT IDENTITY(1,1),ename NVARCHAR(200),esalary float,dep_id INT)

INSERT INTO #temp_table VALUES ('Abhi',5000,1)

INSERT INTO #temp_table VALUES ('Bala',8000,1)

INSERT INTO #temp_table VALUES ('Chithra',6000,1)

INSERT INTO #temp_table VALUES ('Chithra1',60001,1)

INSERT INTO #temp_table VALUES ('Chithra2',60002,1)

INSERT INTO #temp_table VALUES ('Chithra3',60003,1)

INSERT INTO #temp_table VALUES ('Chithra4',60004,1)

DECLARE @strHtml NVARCHAR(MAX)

SET @strHtml = ''

SELECT @strHtml = ''

SELECT @strHtml = @strHtml + '

FROM #temp_table

SELECT @strHtml = @strHtml + '

' + CONVERT(VARCHAR(20),eid) + '

' + ename + '

' + CONVERT(VARCHAR(20),esalary) +'

SELECT @strHtml

DROP TABLE #temp_table