基于C#语言的管理系统 是必备的资源 此文档是PDF文档 源文档 using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Collections; using System.Web; using System.Text; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class AdminStudent : System.Web.UI.Page { protected static string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { dataBind(); } } public void dataBind() { using (SqlConnection conn = new SqlConnection(connStr)) { using (SqlDataAdapter comm = new SqlDataAdapter("select id,stuNum,stuName,stuSex,convert(varchar(10) ,birthday,120)as birthday,branch,IdentityID,native,address,politics,department,className,convert(varchar(10) , registerTime,120)as registerTime,Tel,photoImage from stuInfo", conn)) { conn.Open(); DataSet ds = new DataSet(); comm.Fill(ds, "ds"); GridView1.DataSource = ds; GridView1.DataKeyNames = new string[] { "id"}; GridView1.DataBind(); } } } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; dataBind(); } protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridView1.EditIndex = -1; dataBind(); } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; dataBind(); } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int id = (int)GridView1.DataKeys[e.RowIndex].Value; string sqlstr = "delete from StuInfo where id=" + id + ""; using (SqlConnection conn = new SqlConnection(connStr)) { using (SqlCommand comm = new SqlCommand(sqlstr, conn)) { conn.Open(); int row = comm.ExecuteNonQuery(); } } dataBind(); } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { StringBuilder sqlstr = new StringBuilder(); sqlstr.Append("update StuInfo set stuNum='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim()+"',"); sqlstr.Append("stuName='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.Trim() + "',"); sqlstr.Append("stuSex='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.Trim() + "',"); sqlstr.Append("birthday=" +
- 粉丝: 0
- 资源: 1
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助