62,046
社区成员
发帖
与我相关
我的任务
分享
public static int ExcuteNonQuery(string sqlcmd, SqlParameter[] Parameter)
{
SqlConnection conn = new SqlConnection(SqlConn);
if(conn.State!=ConnectionState.Open)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "st_register";
cmd.CommandType = CommandType.StoredProcedure;
if (Parameter != null)
{
foreach (SqlParameter item in Parameter)
{
cmd.Parameters.Add(item);
}
}
return cmd.ExecuteNonQuery();
}
public int CreateStudent(M_Student m_student)
{
return SQLHelper.ExcuteNonQuery("st_register", new SqlParameter[] {
new SqlParameter("@uname",m_student.Uname),
new SqlParameter("@password",m_student.Password),
new SqlParameter("@tel",m_student.Tel),
new SqlParameter("@sex",m_student.Sex),
new SqlParameter("@address",m_student.Address)
});
}
create procedure st_register
@uname varchar(50),
@password varchar(50),
@tel varchar(50),
@sex bit,
@address varchar(50)
as
insert into Stu(uname,password,tel,sex,address)values(@uname,@password,@tel,@sex,@address)