I am running the query SQL=’Select name from profile where proID=1′; and I am getting the result in Dataset dsdata. Now how do I read the text from the dataset and assign it to textbox1.text ?

Platform: ASP.NET| Category: ADO.NET

VB.NET


dsData.Tables(0).Rows(0)('FieldName').ToString()

C#


dsData.Tables[0].Rows[0]['FieldName'].ToString()

Related FAQs

How to use Parameterized queries in ASP.NET

When I try to enter null value to DateTime field in database it is saved as 1/1/1900 12:00:00 AM

How to use Stored Procedures in ASP.NET

How to filter distinct records from a normal Select query and display in a web control

How to insert data in database using Textboxes

Couldn't find the FAQs you're looking for?

Please submit your question and answer.

Back to ASP.NET Categories