Why am I getting the exception "Object reference not set to an instance" ?
My cs code is given below
private void button1_Click(object sender, EventArgs e)
{
string connetionString = null;
SqlConnection cnn;
connetionString = "Data Source=JDPANDEY-PC;Initial Catalog=amsco;User ID = sa;Password= 123";
cnn = new SqlConnection(connetionString);
SqlTransaction tr = null;
cnn.Open();
tr = cnn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("insert into registration (eid,ename,fname,dob,age,sex,marital,address,contact,qualification,djoining,jsalary,csalary,designation,department) values (@v1,@v2,@v3,@v4,@v5,@v6,@v7,@v8,@v9,@v10,@v11,@v12,@v13,@v14,@v15)");
cmd.Transaction = tr;
cmd.Parameters.AddWithValue("@v1", textBox1.Text);
cmd.Parameters.AddWithValue("@v2", textBox2.Text);
cmd.Parameters.AddWithValue("@v3", textBox3.Text);
cmd.Parameters.AddWithValue("@v4", textBox4.Text);
cmd.Parameters.AddWithValue("@v5", textBox5.Text);
cmd.Parameters.AddWithValue("@v6", comboBox1.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@v7", comboBox2.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@v8", textBox6.Text);
cmd.Parameters.AddWithValue("@v9", textBox7.Text);
cmd.Parameters.AddWithValue("@v10", comboBox3.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@v11", textBox8.Text);
cmd.Parameters.AddWithValue("@v12", textBox9.Text);
cmd.Parameters.AddWithValue("@v13", textBox10.Text);
cmd.Parameters.AddWithValue("@v14", textBox11.Text);
cmd.Parameters.AddWithValue("@v15", textBox12.Text);
cmd.Connection = cnn;
cmd.ExecuteNonQuery();
tr.Commit();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cnn.Close();
}
}