string sql = "insert into Students (StudentName,Age,Gender,Birthday,";
sql += "CardNo,ClassId,StudentIdNo,PhoneNumber,StudentAddress,StuImage) ";
sql += " Values(@StudentName,@Age,@Gender,@Birthday,@CardNo,@ClassId,";
sql += "@StudentIdNo,@PhoneNumber,@StudentAddress,@StuImage)";
//创建参数数组
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@StudentName",objStudent.StudentName),
new SqlParameter("@Age",objStudent.Age),
new SqlParameter("@Gender",objStudent.Gender),
new SqlParameter("@Birthday",objStudent.Birthday),
new SqlParameter("@CardNo",objStudent.CardNo),
new SqlParameter("@ClassId",objStudent.ClassId),
new SqlParameter("@StudentIdNo",objStudent.StudentIdNo),
new SqlParameter("@PhoneNumber",objStudent.PhoneNumber),
new SqlParameter("@StudentAddress",objStudent.StudentAddress),
new SqlParameter("@StuImage",objStudent.StuImage)
};
try
{ //调用带参数方法
return SQLHelper.Update(sql,parameter);
}
catch (Exception ex)
{
throw new Exception("保存数据出现问题" + ex.Message);
}