Update statement not updating record in Database Table using C# in ASP.Net

Hi Ngetichk,

As per your code it looks good. Let me know the datatype of the columns that you are updating record. Also try to put debug and check in which line the code breaks. Also check the value of where condition and is there any record present as per the where condition or not.

Ngetichk says:

SqlCommand cmd = new SqlCommand("UPDATE classresult SET English = " + Eng.Text + ", Kiswahili=" + Kisw.Text + ", Maths=" + Maths.Text + ", Bilogy=" + Bio.Text + ", Physics=" + Phy.Text + ", Chemistry=" + Chem.Text + ", Geo=" + Geo.Text + ", History=" + Hist.Text + ", Agricture=" + Agric.Text + ", bussines =" + Buss.Text + ", RE=" + RE.Text + " WHERE admno = " + tbadmno.Text + "", con);

 Change with the below line and check.

SqlCommand cmd = new SqlCommand("UPDATE classresult SET English = '" + Eng.Text + "', Kiswahili='" + Kisw.Text + "', Maths='" + Maths.Text + "', Bilogy='" + Bio.Text + "', Physics='" + Phy.Text + "', Chemistry='" + Chem.Text + "', Geo='" + Geo.Text + "', History='" + Hist.Text + "', Agricture='" + Agric.Text + "', bussines ='" + Buss.Text + "', RE='" + RE.Text + "' WHERE admno = '" + tbadmno.Text + "'", con);