WEB系统与技术资料.ppt

try { oc.Open(); da.Fill(ds,user_info); GV1.DataSource = ds.Tables[user_info].DefaultView; DV1.DataKeyNames = new string[] { user_name }; GV1.DataBind(); } catch (Exception ex) { Response.Write(ex); } finally { oc.Close(); } } protected void DV1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string selectName = DV1.DataKeys[e.RowIndex].Value.ToString(); string ConStr = Provider=Microsoft.Jet.OLEDB.4.0;Data source= + Server.MapPath(user.mdb); OleDbConnection oc = new OleDbConnection(ConStr); string strsql = delete from user_info where user_Name= + selectName + ; OleDbCommand com = new OleDbCommand(strsql, oc); 删除列 try { oc.Open(); com.ExecuteNonQuery(); } catch (Exception ex) { Response.Write(ex); } finally { oc.Close(); dd_bind(); } } 选择列 protected void DV1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { string selectName = DV1.DataKeys[e.NewSelectedIndex].Value.ToString(); Response.Redirect(showInfo.aspx?userName= + selectName); } protected void Page_Load(object sender, EventArgs e) { //获取查询字符串 string username = Request.QueryString[userName].ToString(); //获取对应信息在前面展现 string ConStr = Provider=Microsoft.Jet.OLEDB.4.0;Data source= + Server.MapPath(user.mdb); OleDbConnection oc = new OleDbConnection(ConStr); String strsql = select * from user_info where user_Name=+username+; OleDbCommand com = new OleDbCommand(strsql, oc); try { oc.Open(); OleDbDataReader dr = com.ExecuteReader(); if (dr.Read()) { txt_name.Text = dr[user_Name].ToString();