Fill data in textBox

mahmud_uk

Hi Guys, I'm tring to retrive data from the database and fill them up in thier correct textbox. i,e, 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(sQuery,con); com.Clos() Do i insert this code anywhere sqlDataAdapter1.Fill( textBpx1, "License"); THANKS

2 Replies

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

mahmud_uk22y ago
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(sQuery,con); 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
0
p.jones22y ago
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.
0