某高校学生宿舍管理信息系统设计与开发(5)

湖南商学院学年论文设计

{

OleDbConnection conn = new OleDbConnection(); string strconn;

strconn = \Source=E:\\\\考试\\\\App_Data\\\\学生宿舍管理.mdb\ conn.ConnectionString = strconn; conn.Open();

string no1,no2,no3,sq1; no1 = TextBox2.Text.Trim(); no2 = TextBox3.Text.Trim(); no3 = TextBox4.Text.Trim();

sq1 = \卫生评比(楼号,宿舍号,班级,得分)values('\+ \

OleDbCommand cod = new OleDbCommand(); cod.CommandText = sq1; cod.Connection = conn; int ok;

ok = cod.ExecuteNonQuery(); if (ok == 1) {

Label2.Text = \恭喜您，评分成功！！\

第 21 页 共 38 页

湖南商学院学年论文设计

return; } else {

Label2.Text = \对不起，操作失败！！\ return; } }

protected void Button3_Click(object sender, EventArgs e) {

OleDbConnection conn = new OleDbConnection(); string strconn;

strconn = \Source=E:\\\\考试\\\\App_Data\\\\学生宿舍管理.mdb\ conn.ConnectionString = strconn; conn.Open();

string sql, kh_name1, kh_ name2;

kh_name1 = DropDownList1.Text.Trim() + \ kh_name2 = DropDownList3.Text.Trim() + \ sql = \卫生评比 \ \楼号 like'\ \宿舍号 like '\

第 22 页 共 38 页

湖南商学院学年论文设计

OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandText = sql;

GridView1.DataSource = cmd.ExecuteReader(); GridView1.DataBind(); } }

4.3.5 宿舍管理

public partial class 宿舍管理 : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) { }

protected void Button1_Click(object sender, EventArgs e) {

OleDbConnection conn = new OleDbConnection(); string strconn;

strconn = \Source=E:\\\\考试\\\\App_Data\\\\学生宿舍管理.mdb\ conn.ConnectionString = strconn; conn.Open();

string kh_name, kh_number, kh_sexy, kh_name1, kh_name2,

第 23 页 共 38 页

湖南商学院学年论文设计

kh_class1, kh_date, kh_time;

kh_name = TextBox2.Text.Trim(); kh_number = TextBox3.Text.Trim(); kh_sexy = TextBox4.Text.Trim(); kh_name1 = TextBox5.Text.Trim(); kh_name2 = TextBox6.Text.Trim(); kh_class1 = TextBox7.Text.Trim(); kh_date = TextBox8.Text.Trim(); kh_time = TextBox9.Text.Trim(); if (kh_name.Length == 0) {

Label7.Text = \请认真的填写您的姓名！！ }

if (kh_number.Length == 0) {

Label15.Text = \请填写您的学号！！\ }

if (kh_sexy.Length == 0) {

Label16.Text = \请填写您的性别！！\ }

if (kh_name1.Length == 0)

第 24 页 共 38 页

\湖南商学院学年论文设计

{

Label17.Text = \请认真的填写您的所住楼号！！\ }

if (kh_name2.Length == 0) {

Label18.Text = \请认真的填写您的所住宿舍号！！ }

if (kh_class1.Length == 0) {

Label19.Text = \请认真的填写您的班级！！\ }

if (kh_date.Length == 0) {

Label20.Text = \请认真的填写晚归日期！！\ }

if (kh_qtime.Length == 0) {

Label23.Text = \请认真的填写晚归时间！！\ return; }

OleDbCommand cod = new OleDbCommand();

cod.CommandText = kh_Sql;

第 25 页 共 38 页

\