下面给出使用存储过程添加数据的方法

SqlConnection con = new SqlConnection("Server=(local);database=db_10;Uid=sa;Pwd=");con.Open();SqlCommand cmd = new SqlCommand("procInsertEmployee", con);cmd.CommandType = CommandType.StoredProcedure;SqlParameter[] prams = {new SqlParameter("@员工编号", SqlDbType.VarChar, 50),new SqlParameter("@员工姓名", SqlDbType.VarChar, 50),new SqlParameter("@身份证号", SqlDbType.VarChar, 50),new SqlParameter("@联系电话", SqlDbType.VarChar, 50)};prams[0].Value = TextBox1.Text;prams[1].Value = TextBox2.Text;prams[2].Value = TextBox3.Text;prams[3].Value = TextBox4.Text;// 添加参数foreach (SqlParameter parameter in prams){cmd.Parameters.Add(parameter);}cmd.ExecuteNonQuery();con.Close();Response.Write("<script>alert('注册成功！')</script>");