网上校友录web课程设计（ASP NET源程序加数据库） - 图文

五.系统公共类部署

连接数据库的公共类：

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