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(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 + '  ' + 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(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 + ' ' + CONVERT(VARCHAR(20),eid) + ' ' + ename + ' ' + CONVERT(VARCHAR(20),esalary) +' ' FROM #temp_table SELECT @strHtml = @strHtml + ' ' SELECT @strHtml DROP TABLE #temp_table