Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

How to display dynamic data from db without using data ctrls

Home
Forums
Learn iOS Programming

How to display dynamic data from db without using data ctrls

Prabu Spark

12yAsked May 6, 2014, 4:52 AM1.4kLearn iOS Programming

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

sudipta sanyal12y ago

CREATE TABLE #temp_table (eid INT IDENTITY(1,1),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 + '

FROM #temp_table

SELECT @strHtml = @strHtml + '

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

' + ename + '

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

SELECT @strHtml

DROP TABLE #temp_table

Khan Abrar Ahmed12y ago

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.