Update Query

Question

I have this form where it retrives information from the database to its appropiate textBox checkBox etc. Now i want the update action to function. If i amend any fields i.e. Text check etc and press the update button i want the change to take place in the form as well as the database. I'm stuck on this section now i done a brif script but keeps on throughing error: String sUpdate = Update * FROM License SET Name = ' + textBox1.Text.ToString() + ' AllowPlayOnPC =' + checkBox1.Checked + ' + WHERE Name = '+ textBox5.Text +' AND LicenseID = '+ textBox6.Text +'; SqlCommand cmd = new SqlCommand(sUpdate con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); con.Close(); Can anyone direct me what i should do now. Thanks Mac

mahmud_uk · Answer

Hi Webox The way you did the above script functions perfectly but i have several checkBoxes and through this method it will involve a lot of coding. Is'nt there a shorter way to reference all the checkBoxex in one so i do not have to do coding for each checkBox. Also how will i do the scripting for the updating the radioButtons. Again i have several radioButtons and they are specified as static and dynamic instead of 1 and 0's. Thanks

castillo_car_los · Answer

short checkvalue = 0; if (checkBox1.Checked) {checkvalue = 1; } else {checkvalue =0; }; String sUpdate = Update License SET Name = ' + textBox1.Text.ToString() + ' AllowPlayOnPC =' + checkvalue.ToString() + ' +  WHERE Name = '+ textBox5.Text +' AND LicenseID = '+ textBox6.Text +'; SqlCommand cmd = new SqlCommand(sUpdate con); con.Open(); cmd.ExecuteNonQuery(); con.Close();

mahmud_uk · Answer

The above code functions for the textBox but the checkBox1.Checked it throws an error. Because its based on true and false 1 and 0 are used to determine the value therefore its not reconginsed by the copiler. Does any has any idea how i would configure this problem. Thanks

miker · Answer

String sUpdate = Update License SET Name = ' + textBox1.Text.ToString() + ' AllowPlayOnPC =' + checkBox1.Checked + ' +  WHERE Name = '+ textBox5.Text +' AND LicenseID = '+ textBox6.Text +'; SqlCommand cmd = new SqlCommand(sUpdate con); con.Open(); cmd.ExecuteNonQuery(); con.Close();