Fill data in textBox

Question

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

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

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.

Fill data in textBox

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)