How to display dynamic data from db without using data ctrls

Question

Hi sir Tell me the steps to display the dynamic data from database and show in asp.net page without using data controls. I have a table below. eid ename esalary 1 Abhi 5000 2 Bala 8000 3 Chithra 6000 [Note: I need to show the datas fetch from db without using any data controls in asp.net] Kindly give me the solution for this problem.

sudipta sanyal · Answer

CREATE TABLE #temp_table (eid INT IDENTITY(11)ename NVARCHAR(200)esalary float) INSERT INTO #temp_table VALUES ('Abhi'5000) INSERT INTO #temp_table VALUES ('Bala'8000) INSERT INTO #temp_table VALUES ('Chithra'6000) 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

Khan Abrar Ahmed · Answer

Hi is there any reason to show the data without any data control. if you dont want to use data control then create a daynamic table from your code after fetching the data and place the dynamic control.