Add database data to html table cell console app c#

Question

how to Add database data to html table cell. my table consist 3 columns and nth rows(dynamically creates based on database data)

sudipta sanyal · Answer

Try this . i thing it will solve your probs 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 as 'strHtml' DROP TABLE #temp_table

samanta · Answer

i have attached the template. i want to fill the table cell with database value one by one.

sudipta sanyal · Answer

can u send your template

samanta · Answer

my html template consists 3 column 6 rows. i want to add data to that cell. how to achieve this?

sudipta sanyal · Answer

ok. then 1. write a query which gives you all data 2. pick those data in a datatable or a dataset 3. write a loop on that datatable or dataset loop 4. now generate the tr td based on your loop and append the value with your control

samanta · Answer

thanks for your reply.... actually i have created html template and i want to bind database data to that html. how to do that

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