一个GridView的问题？？？
问个gridView的问题，为什么我的gridview删除或者添加数据在绑定后还是原来的数据呢？造成原因是什么? 我一直都这样做的,其他页面的又没有问题哦,晕哦
if (!IsPostBack)
{
if (Session["admin"] == null||Session["flag"].ToString().Trim()=="1")
{
Response.Redirect("AdminLogin.aspx");
}
else
{
BindUsers();
}
}
public void BindUsers()
{
string connstr = ConfigurationSettings.AppSettings["connection"] + Server.MapPath(ConfigurationSettings.AppSettings["data"]);
OleDbConnection cn = new OleDbConnection(connstr);
cn.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from admin", cn);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string admin = tbAdmin.Text.Trim();
string pwd = tbPwd.Text.Trim();
string flag = DropDownList1.SelectedValue.ToString();
string sql = "insert into admin(AdminName,AdminPwd,Flag) values ('"+admin+"','"+pwd+"','"+flag+"')";
string connstr = ConfigurationSettings.AppSettings["connection"] + Server.MapPath(ConfigurationSettings.AppSettings["data"]);
OleDbConnection cn = new OleDbConnection(connstr);
cn.Open();
OleDbCommand cmd = new OleDbCommand(sql, cn);
try
{
cmd.ExecuteNonQuery();
//BindUsers();
Response.Redirect("UserMan.aspx");//这里是我测试的,为什么不更新
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
BindUsers();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
string connstr = ConfigurationSettings.AppSettings["connection"] + Server.MapPath(ConfigurationSettings.AppSettings["data"]);
OleDbConnection cn = new OleDbConnection(connstr);
cn.Open();
OleDbCommand cmd = new OleDbCommand("delete from admin where AdminID="+id+"", cn);
try
{
cmd.ExecuteNonQuery();
BindUsers();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
问题点数：20、回复次数：2Top
1 楼artak（甜葡萄）回复于 2006-04-01 11:45:21 得分 0
问题解决了,谁快进来,给分Top
2 楼ice_frank（回归......）回复于 2006-04-01 11:54:55 得分 20
哦，恭喜LZ解决问题。Top
