Fill data in textBox

Question

Hi Guys I'm tring to retrive data from the database and fill them up in thier correct textbox. ie textBox1 should insert the product name etc .. Any idea how will i configure my code to do this: SqlConnection con = new SqlConnection (@Data Source= xxxx;+ Initial Catalog = drmTest; + Network Library=DBMSSOCN;+ user id =xx;+ Password=xxl); // assign conString String sQuery = SELECT Name Description Price FROM License WHERE Name = '+ textBox5.Text +' AND LicenseID = '+ textBox6.Text +'; Console.WriteLine(sQuery); SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sQuerycon); com.Clos() Do i insert this code anywhere sqlDataAdapter1.Fill( textBpx1 License); THANKS

mahmud_uk · Answer

Found the answer: String sQuery = SELECT Name Description Price FROM License WHERE Name = '+ textBox5.Text +' AND LicenseID = '+ textBox6.Text +'; //Console.WriteLine(sQuery); SqlCommand cmd = new SqlCommand(sQuery con); //SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sQuerycon); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if( dr.Read() ) { textBox1.Text = dr[ Name ].ToString(); textBox2.Text = dr[ Description ].ToString(); textBox3.Text = dr[ Price ].ToString(); // ...... } dr.Close(); Thanks

p.jones · Answer

We think that the TextBox is a control on a form and if that is so then you should know that DataAdapter.Fill is intended to put results of query a DataTable object within a DataSet object. You would then need to look at databinding to connect the TextBox to the DataTable. I haven't done this for a TextBox so you will have to look that up for yourself within Visual Studio Help.