SqlConnection con = new SqlConnection ("<Connection string>");
        SqlCommand cmd = new SqlCommand();

        SqlParameter namparam;
        SqlParameter deptparam;

 private void button1_Click(object sender, EventArgs e)
        {
            cmd.Connection = con;
            cmd.CommandText = "sam_insert";
            cmd.CommandType = CommandType.StoredProcedure;

            namparam = new SqlParameter("@name_1", SqlDbType.Text,9 );
            namparam.Value = textBox1.Text;
            cmd.Parameters.Add(namparam);

            deptparam = new SqlParameter("@department_2", SqlDbType.VarChar, 30);
            deptparam.Value = textBox2.Text;
            cmd.Parameters.Add(deptparam);

   
            cmd.ExecuteNonQuery();
            MessageBox.Show("inserted");
       }