Comments by ochaya gerald (Top 1 by date)

i have used this code to update table but there's no error. the information I get is that, Object reference not set to an instance of an object. How can I rectify it

this is the code



try
{
string query ="update Admission Set FName='" + txtAdmFaName.Text + "',SName='" + txtAdmSname.Text + "',OName='" + txtadmOName.Text + "',Address='" + txtAdmAddress.Text + "',Contact='" + txtAdmContact.Text + "',FatherN='" + txtAdmFaName.Text + "',MotherN='" + txtAdmMoName.Text + "',Date='" + txtAdmDate.Text + "',Guardian='" + txtAdmGuardian.Text + "',ParentOcc='" + txtPOcc.Text + "',Class='" + txtStream.Text + "',Gender='" + txtGender.Text + "',Term='" + txtTerm.Text + "',Combination='" + txtCombinations.Text + "',Nationality='" + txtNationality.Text + "' where RollNo='" + txtAdmRoll.Text + "'";
cmd = new SqlCommand(query, con);
cmd.Parameters.Add("txtAdmFaName.Text",txtAdmFaName.Text);
cmd.Parameters.Add("txtAdmSname.Text",txtAdmSname.Text);
cmd.Parameters.Add("txtadmOName.Text",txtadmOName.Text);
cmd.Parameters.Add("txtAdmAddress.Text",txtAdmAddress.Text);
cmd.Parameters.Add("txtAdmContact.Text",txtAdmContact.Text);
cmd.Parameters.Add("txtAdmFaName.Text", txtAdmFaName.Text);
cmd.Parameters.Add("txtAdmMoName.Text",txtAdmMoName.Text);
cmd.Parameters.Add("txtAdmDate.Text", txtAdmDate.Text);
cmd.Parameters.Add("txtAdmGuardian.Text",txtAdmGuardian.Text);
cmd.Parameters.Add("txtPOcc.Text", txtPOcc.Text);
cmd.Parameters.Add("txtStream.Text",txtStream.Text);
cmd.Parameters.Add("txtGender.Text",txtGender.Text);
cmd.Parameters.Add("txtTerm.Text",txtTerm.Text);
cmd.Parameters.Add("txtCombinations.Text",txtCombinations.Text);
cmd.Parameters.Add("txtNationality.Text", txtNationality.Text);

con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;

}