Hi '
I update the data using procedure ,but i got this error
"Object reference not set to an instance of an object."
this is my code
command.CommandType = CommandType.StoredProcedure command.CommandText = "PACKLNT.GET_Candidate_stsupdate" command.Parameters.Clear() command.Parameters.Add("MKREF_F_NUMBER", OracleType.VarChar).Value = t1.Text.Trim() command.Parameters.Add("MKREASON_F_NT", OracleType.VarChar).Value = TextBox6.Text.Trim() command.Parameters.Add("MKAPPLICATION_F_STATUS", OracleType.VarChar).Value = ap.Trim() command.Parameters.Add("MKOFFER_ACCEPTANCE", OracleType.VarChar).Value = a1.Trim() command.Parameters.Add("MKRECEIVED_DT_OFFER_LETTER", OracleType.VarChar).Value = textBox3.Text.Trim() command.Parameters.Add("MKOFFER_LETTER_DATE", OracleType.VarChar).Value = textBox1.Text.Trim() command.Parameters.Add("MKEXPECTED_JOINING_DATE", OracleType.VarChar).Value = textBox2.Text.Trim() command.Parameters.Add("MKMEDICAL_FITNESS", OracleType.VarChar).Value = Dstatus.Text.Trim() command.Parameters.Add("MKCTC", OracleType.VarChar).Value = a4.Trim() command.Parameters.Add("MKHR_MEDICAL_REGION", OracleType.VarChar).Value = Dlocation.Text.Trim() command.Parameters.Add("MKJOINED_ON", OracleType.VarChar).Value = textBox4.Text.Trim()
command.Parameters.Add("MKHR_TESTIMONIAL_VERIFIED", OracleType.VarChar).Value = a3.Trim()
command.Parameters.Add("MKHR_REMARKS", OracleType.VarChar).Value = remark.Text.Trim() command.Parameters.Add("MKLAST_FOLLOWUP_ON", OracleType.VarChar).Value = textBox5.Text.Trim() command.Connection = connection connection.Open() command.ExecuteNonQuery()
What is that error
pls help me