skip to main |
skip to sidebar
<asp:Label runat="server"><%# formatString(Container.DataItem("RowType")) %>asp:Label> 橘色可省略...
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string strSQL = "Delete From "+this.tb_name+" Where ID="+e.Item.Cells[0].Text+""; this.dbp.dbconn.Open(); OleDbCommand objCmd = new OleDbCommand(strSQL, this.dbp.dbconn); objCmd.ExecuteNonQuery(); objCmd.Connection.Close();this.dbp.dbconn.Open(); OleDbDataAdapter objCmd2 = new OleDbDataAdapter(this.sql,this.dbp.dbconn); DataSet ds = new DataSet(); objCmd2.Fill(ds,"fqa"); DataGrid1.DataSource = ds.Tables["fqa"].DefaultView; DataGrid1.DataBind(); }加了下面這兩行就會reflesh網頁了,不然似乎刪除完網頁沒有反應。
private void Page_Load(object sender, System.EventArgs e) { // 在這裡放置使用者程式碼以初始化網頁 //檢查session Auth_check ac = new Auth_check(); string alert_str = ac.check_login(Session); Response.Write(alert_str);
this.dbp = new DBprocess(Server.MapPath("../ag.mdb")); this.dbp.dbconn.Open(); this.sql = "Select * From "+ this.tb_name; if(!IsPostBack) { DataGrid1.DataSource = dbp.GetDataTable(this.sql,dbp.dbconn,tb_name); DataGrid1.DataBind(); }this.dbp.dbconn.Close(); }