发布时间 : 星期二 文章网上校友录web课程设计(ASP NET源程序加数据库) - 图文更新完毕开始阅读51e9bf27854769eae009581b6bd97f192279bf37
五.系统公共类部署
连接数据库的公共类:
public class Class1 {
{
public static SqlConnection createCon()
return new SqlConnection(\);
}}
15
六.主要功能模块实现
6.1管理员登陆模块
protected void Button1_Click(object sender, EventArgs e) {
string v = \; string b = \; v = TextBox1.Text; b = TextBox2.Text;
SqlConnection conn = new SqlConnection(\); conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = \ + v + \ + b + \; cmd.Connection = conn;
SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.Read()) {
Response.Redirect(\); } else {
Response.Redirect(\); }
sdr.Close(); conn.Close(); }
6.2管理员班级信息删除模块
public partial class xxxx : System.Web.UI.Page {
SqlConnection cn = Class1.createCon();
protected void Page_Load(object sender, EventArgs e) {
16
if (!Page.IsPostBack) {
BindGrid(); } }
protected void BindGrid() {
SqlDataAdapter dataAdapter2 = new
SqlDataAdapter(\, cn); DataSet setS = new DataSet(); dataAdapter2.Fill(setS, \);
this.GridView1.DataSource = setS.Tables[\]; this.GridView1.DataBind(); }
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) {
this.GridView1.PageIndex = e.NewPageIndex; }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {
string sqlstr = \ + GridView1.DataKeys[e.RowIndex].Value.ToString() + \; SqlCommand cmd = new SqlCommand(sqlstr, cn); cn.Open();
cmd.ExecuteNonQuery(); cn.Close(); BindGrid(); }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {
this.GridView1.EditIndex = e.NewEditIndex; BindGrid(); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {
string sch_ids = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
string sch_names =((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text; string pro_ids = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
17
string city_ids =((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text; string del_flags =((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text; string sch_ereas =((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text; string type_ids =((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text; string sch_nums =((TextBox)GridView1.Rows[e.RowIndex].Cells[7].Controls[0]).Text; string ybs=((TextBox)GridView1.Rows[e.RowIndex].Cells[8].Controls[0]).Text; string sch_https = ((TextBox)GridView1.Rows[e.RowIndex].Cells[9].Controls[0]).Text; string sch_whos = ((TextBox)GridView1.Rows[e.RowIndex].Cells[10].Controls[0]).Text;
SqlCommand cmd = new SqlCommand(\ + sch_names + \ + pro_ids + \ + city_ids + \ + del_flags + \ + sch_ereas + \ + type_ids + \ + sch_nums + \ + ybs + \ + sch_https + \ + sch_whos + \ + sch_ids + \, cn); cn.Open();
cmd.ExecuteNonQuery(); cn.Close();
this.GridView1.EditIndex = 0; BindGrid(); }
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {
GridView1.EditIndex = -1; BindGrid(); }
protected void Button1_Click(object sender, EventArgs e) {
Response.Redirect(\); } }
6.3管理员班级信息修改模块
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {
string class_ids = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
string class_names = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text; string class_nums = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text; string pro_ids = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
18