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 Column1Column2 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