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

Question

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.

samanta · Answer

http://forums.asp.net/t/1780118.aspx?How+to+bind+records+into+HTML+table+instead+of+Grid

Jignesh Trivedi · Answer

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

sudipta sanyal · Answer

CREATE TABLE #temp_table (eid INT IDENTITY(11)ename NVARCHAR(200)esalary floatdep_id INT) INSERT INTO #temp_table VALUES ('Abhi'50001) INSERT INTO #temp_table VALUES ('Bala'80001) INSERT INTO #temp_table VALUES ('Chithra'60001) INSERT INTO #temp_table VALUES ('Chithra1'600011) INSERT INTO #temp_table VALUES ('Chithra2'600021) INSERT INTO #temp_table VALUES ('Chithra3'600031) INSERT INTO #temp_table VALUES ('Chithra4'600041) DECLARE @strHtml NVARCHAR(MAX) SET @strHtml = '' SELECT @strHtml = ' ' SELECT @strHtml = @strHtml + ' ' + CONVERT(VARCHAR(20)eid) + ' ' + ename + ' ' + CONVERT(VARCHAR(20)esalary) +' ' FROM #temp_table SELECT @strHtml = @strHtml + ' ' SELECT @strHtml DROP TABLE #temp_table