这是Page_Load private void Page_Load(object sender, System.EventArgs e)
{
if(Request.Cookies["UserID"]==null)
{
Response.Redirect("../inc/login.aspx");
}
else
{
System.Data.OleDb.OleDbDataAdapter mycommand=new System.Data.OleDb.OleDbDataAdapter("select * from CP_GouMai where Isok=false and UserID=" + Request.Cookies["UserID"].Value +" order by id desc",oleDbConnection1);
System.Data.DataSet mydataset=new DataSet();
mycommand.Fill(mydataset,"gouwulan");
DataGrid1.DataSource=mydataset;
DataGrid1.DataMember="gouwulan";
DataGrid1.DataBind();
}
}这是更新代码
protected void DataGrid1_update(object obj,System.Web.UI.WebControls .DataGridCommandEventArgs e)
{
System.Web.UI.WebControls.TextBox mytextbox;
mytextbox=(System.Web.UI.WebControls.TextBox)(e.Item.Cells[5].Controls[0]);
System.Data.OleDb.OleDbCommand myup=new System.Data.OleDb.OleDbCommand("update CP_GouMai set [counts]=@counts where id="+ e.Item.Cells[1].Text,oleDbConnection1);
myup.Parameters.Add("@counts",mytextbox.Text );
myup.Connection.Open();
try
{
myup.ExecuteNonQuery();
}
catch(Exception exx)
{
Response.Write(exx.ToString()+"数据库操作失败!");
}
myup.Connection.Close();
DataGrid1.DataBind();
DataGrid1.EditItemIndex=-1;
}
点更新后还是编辑状态。好象没执行到最后一句的DataGrid1.EditItemIndex=-1;
{
if(Request.Cookies["UserID"]==null)
{
Response.Redirect("../inc/login.aspx");
}
else
{
System.Data.OleDb.OleDbDataAdapter mycommand=new System.Data.OleDb.OleDbDataAdapter("select * from CP_GouMai where Isok=false and UserID=" + Request.Cookies["UserID"].Value +" order by id desc",oleDbConnection1);
System.Data.DataSet mydataset=new DataSet();
mycommand.Fill(mydataset,"gouwulan");
DataGrid1.DataSource=mydataset;
DataGrid1.DataMember="gouwulan";
DataGrid1.DataBind();
}
}这是更新代码
protected void DataGrid1_update(object obj,System.Web.UI.WebControls .DataGridCommandEventArgs e)
{
System.Web.UI.WebControls.TextBox mytextbox;
mytextbox=(System.Web.UI.WebControls.TextBox)(e.Item.Cells[5].Controls[0]);
System.Data.OleDb.OleDbCommand myup=new System.Data.OleDb.OleDbCommand("update CP_GouMai set [counts]=@counts where id="+ e.Item.Cells[1].Text,oleDbConnection1);
myup.Parameters.Add("@counts",mytextbox.Text );
myup.Connection.Open();
try
{
myup.ExecuteNonQuery();
}
catch(Exception exx)
{
Response.Write(exx.ToString()+"数据库操作失败!");
}
myup.Connection.Close();
DataGrid1.DataBind();
DataGrid1.EditItemIndex=-1;
}
点更新后还是编辑状态。好象没执行到最后一句的DataGrid1.EditItemIndex=-1;
解决方案 »
- 请都一个搜索的问题,进者有分,100相送!解决立马结贴!!!!!!!!!
- 关于DIV刷新的问题!!!就10分了,都给你!
- asp.net2.0中换肤
- 顶都给分!~~~用户控件,页面的数值传递出错
- TeeChart 控件问题 急急
- mapxtreme 2008 状态管理 SaveZoomCenterState
- DataGrid 不能正常显示数据? 急
- 急得要哭了,朋友们,你们知道怎么把一个visual studio 2005的网站项目,移动到另一台机器上去继续开发???
- 怎么把一个已经存在的streamwriter流,保存成一个硬盘上的文件
- system.draw.Rectangle和system.draw.RectangleF,有什么区别,怎么转换?
- 关于vs05里用dropdownlist筛选gridview的小问题..
- WEB和winform之间的通信,请高人指点.
DataGrid1.DataBind();