How to get data from database (sql sever 2005) in asp.net C# in particulars textboxes only...

Question

Hi Guys, Here Now I have completed with connection strings and all stuff, now facing a problem that how to get those data in particulars textboxes. Please Help....

Sam Hobbs · Answer

I see you say " in asp.net " in the subject. You should put ASP questions in the ASP category. Look at the right side of this window. Do you see " Our recommended articles "? I see there an article about data-binding in ASP.Net. That will likely help. You should look at the other articles in this web site; there are many articles and I am sure many will help you.

mohdazeemuddin ahmed · Answer

hi Friend::- you can use like this string connectionstring = ConfigurationSettings.AppSettings["Connect"].ToString(); SqlConnection con = new SqlConnection(connectionstring); con.Open(); SqlDataAdapter da = new SqlDataAdapter("Select Column1,Column2 from DataTable", con); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); textbox1.text=ds.Tables[0].Rows[0][0].ToString(); textbox2.Text=ds.Tables[0].Rows[0][1].ToString(); Thats it

aravind · Answer

hi Friend:: step1:give the Connection string in aspx.cs file. Step2: in the button click event.using select query get the Column names what we want . Step3 :using DataReader read the Following columns and assign to the Textbox. With Regards S.ARAVIND

How to get data from database (sql sever 2005) in asp.net C# in particulars textboxes only...

Answers (3)