请问为什么DataGrid修改后刷新不了?
Button1_Click修改后刷新不了数据,要点击浏览器的刷新 ,数据才会更新
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindGrid();
}
}
private void BindGrid()
{
String conn_str = "provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ Server.MapPath("../") + Constants.conn_string;
String sql = "select count(*) from [reg] ";
OleDbConnection conn = new OleDbConnection(conn_str);
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
this.Pager.RecordCount = (int)cmd.ExecuteScalar();
int pageIndex = this.Pager.CurrentPageIndex - 1;
int pageSize = this.Pager.PageSize = 20;
int firstPage = pageIndex * pageSize;
sql = "select * from [reg] order by regdate desc";
cmd = new OleDbCommand(sql, conn);
DataSet ds = new DataSet();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = cmd;
dataAdapter.Fill(ds, firstPage, pageSize, "kk");
DataGrid.DataSource = ds.Tables["kk"];
DataGrid.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
String conn_str = "provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ Server.MapPath("../") + Constants.conn_string;
OleDbConnection conn = new OleDbConnection(conn_str);
conn.Open();
String sql = "update [reg] set [level]='11' where [uusername]='22' ";
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.ExecuteNonQuery();
BindGrid();
}