下面給出使用存儲(chǔ)過程添加數(shù)據(jù)的方法

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("@員工編號(hào)", SqlDbType.VarChar, 50),
new SqlParameter("@員工姓名", SqlDbType.VarChar, 50),
new SqlParameter("@身份證號(hào)", SqlDbType.VarChar, 50),
new SqlParameter("@聯(lián)系電話", SqlDbType.VarChar, 50)
};
prams[0].Value = TextBox1.Text;
prams[1].Value = TextBox2.Text;
prams[2].Value = TextBox3.Text;
prams[3].Value = TextBox4.Text;
// 添加參數(shù)
foreach (SqlParameter parameter in prams)
{
cmd.Parameters.Add(parameter);
}
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('注冊成功！')</script>");