存储过程的应用+数据库
SqlParameter[] pr ={new SqlParameter("@name",SqlDbType.VarChar,50)
,new SqlParameter("@pwd",SqlDbType.VarChar,50)};
pr[0].Value = name;
pr[1].Value = pwd;
using (SqlConnection con = new SqlConnection("server=.uid=sa;pwd=sa;database=pubs"))
{
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "proc_insert";
con.Open();
foreach (SqlParameter prs in pr)
{
com.Parameters.Add(prs);
}
object obj = com.ExecuteScalar();
if (obj != null)
return Convert.ToInt32(obj.ToString());
else
return 0;
}
}
