Um...
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add("@empcode", SqlDbType.VarChar).Value = Convert.ToString(TextBox1.Text);
cmd.Parameters.Add("@empname", SqlDbType.VarChar).Value = TextBox2.Text;
cmd = new SqlCommand("submitrecord",conn);
cmd.CommandType = CommandType.StoredProcedure;
So...You create a Command, add the parameters to it, and then throw it away to create a new one? Why?
Try this:
SqlCommand cmd = new SqlCommand("submitrecord",conn);
cmd.Parameters.Add("@empcode", SqlDbType.VarChar).Value = Convert.ToString(TextBox1.Text);
cmd.Parameters.Add("@empname", SqlDbType.VarChar).Value = TextBox2.Text;
cmd.CommandType = CommandType.StoredProcedure;
Or better this:
SqlCommand cmd = new SqlCommand("submitrecord",conn);
cmd.Parameters.AddWithValue("@empcode", TextBox1.Text);
cmd.Parameters.AddWithValue("@empname", TextBox2.Text);
cmd.CommandType = CommandType.StoredProcedure;