Add database data to html table cell console app c#

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 + '

FROM #temp_table

SELECT @strHtml = @strHtml + '

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

' + ename + '

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

SELECT @strHtml as 'strHtml'

DROP TABLE #temp_table

samanta12y ago

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

sudipta sanyal12y ago

can u send your template

samanta12y ago

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

sudipta sanyal12y ago

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

samanta12y ago

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 sanyal12y ago

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