int lateNum;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrin["connstr"].ConnectionString;
SqlCommand cmd = new SqlCommand("select lateNum from StudentInfo where stuName='学生名'", conn);
try
{
conn.Open();
lateNum= Convert.ToInt32(cmd.ExecuteScalar());
}
catch
{
return null;
}
finally
{
conn.Close();
cmd.Dispose();
}
if(lateNum>3)
{
ClientScript.RegisterStartupScript(this.GetType(), "msg", "<script>alert('你已迟到三次不能预约!!!')</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "msg", "<script>alert('预约成功!!!')</script>");
}
追问还是解决不了 我们现在还没接触网页制作 才开始学窗体的 还有 就是 预约成功后可以使预约次数加一吗?
追答那就conn.ConnectionString ="server=服务器名;database=数据库;uid=数据库登录名;pwd=密码"
可以,你再将数据库更新就行了!
ClientScript.RegisterStartupScript(this.GetType(), "msg", "alert('你已迟到三次不能预约!!!')");改为MessageBox.Show("你已迟到三次不能预约!!!");就行了