事件都写了,代码如下:
private void LoadGrid()
{
SqlConnection con=new SqlConnection("server=(local) \\LITTECATOO;uid=cabin;pwd=wyy1365720;database=friends");
string sql = "select * from score";
SqlDataAdapter da = new SqlDataAdapter(sql,con);
DataSet ds = new DataSet();
da.Fill(ds,"score");
DataGrid1.DataSource = ds.Tables[0];
DataGrid1.DataBind();
}
private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = e.Item.ItemIndex;
LoadGrid();
} private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = -1;
LoadGrid();
} private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
SqlConnection con =new SqlConnection("server=(local)\\LITTECATOO;uid=cabin;pwd=wyy1365720;database=friends");
string updateCmd = "update score set math = @math, English =@english, computer=@computer where studname = @studname";
SqlCommand cmm = new SqlCommand(updateCmd,con);
cmm.Parameters.Add(new SqlParameter("@studname",SqlDbType.VarChar,20));
cmm.Parameters.Add(new SqlParameter("@math",SqlDbType.Int,4));
cmm.Parameters.Add(new SqlParameter("@english",SqlDbType.Int,4));
cmm.Parameters.Add(new SqlParameter("@computer",SqlDbType.Int,4));
cmm.Parameters["@studname"].Value = DataGrid1.DataKeys[e.Item.ItemIndex];
string[] cols = new string[]{"@studname,@math,@english,@computer"};
int NumCols = e.Item.Cells.Count;
for(int i = 1;i<=NumCols-1;i++)
{
TextBox CurrentTb= (TextBox)e.Item.Cells[i].Controls[0];
string ColValue = CurrentTb.Text;
cmm.Connection.Open();
try
{
cmm.ExecuteNonQuery();
DataGrid1.EditItemIndex = -1; }
catch(SqlException Exp)
{
Console.WriteLine(Exp.Message);
}
cmm.Connection.Close();
LoadGrid();
}
}
点击“编辑”按钮,一点反应都没有,不出“取消”和“更新”按钮呀???为什么哦?
private void LoadGrid()
{
SqlConnection con=new SqlConnection("server=(local) \\LITTECATOO;uid=cabin;pwd=wyy1365720;database=friends");
string sql = "select * from score";
SqlDataAdapter da = new SqlDataAdapter(sql,con);
DataSet ds = new DataSet();
da.Fill(ds,"score");
DataGrid1.DataSource = ds.Tables[0];
DataGrid1.DataBind();
}
private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = e.Item.ItemIndex;
LoadGrid();
} private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = -1;
LoadGrid();
} private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
SqlConnection con =new SqlConnection("server=(local)\\LITTECATOO;uid=cabin;pwd=wyy1365720;database=friends");
string updateCmd = "update score set math = @math, English =@english, computer=@computer where studname = @studname";
SqlCommand cmm = new SqlCommand(updateCmd,con);
cmm.Parameters.Add(new SqlParameter("@studname",SqlDbType.VarChar,20));
cmm.Parameters.Add(new SqlParameter("@math",SqlDbType.Int,4));
cmm.Parameters.Add(new SqlParameter("@english",SqlDbType.Int,4));
cmm.Parameters.Add(new SqlParameter("@computer",SqlDbType.Int,4));
cmm.Parameters["@studname"].Value = DataGrid1.DataKeys[e.Item.ItemIndex];
string[] cols = new string[]{"@studname,@math,@english,@computer"};
int NumCols = e.Item.Cells.Count;
for(int i = 1;i<=NumCols-1;i++)
{
TextBox CurrentTb= (TextBox)e.Item.Cells[i].Controls[0];
string ColValue = CurrentTb.Text;
cmm.Connection.Open();
try
{
cmm.ExecuteNonQuery();
DataGrid1.EditItemIndex = -1; }
catch(SqlException Exp)
{
Console.WriteLine(Exp.Message);
}
cmm.Connection.Close();
LoadGrid();
}
}
点击“编辑”按钮,一点反应都没有,不出“取消”和“更新”按钮呀???为什么哦?
解决方案 »
- gridview 如何令编辑字段在 自定义字段 后面
- aps.net web services + ajax 建站 问题
- 100分求解决 asp .net 调用excel 2007 打开.xls问题
- 在使用ReportView浏览报表时候,Toolbar上面的上下翻页按钮无效
- 怎样将组件中的web控件传递到网页上显示出来?谢谢!
- 为什么DataGrid事件会无故丢失?
- dataset 根据word模版 写入数据 【Aspose.Words】大牛进下!
- 怎么调出新的页面?
- 为什么.net 的平台上,框架这个工具为什么没有,能否吿知一二))))))))))
- 填写汉字为什么出错?
- 那位人士可以给我介绍份工作,本人现在东莞
- [高分求代码] 哪位大哥有智能客户端的代码,请给过来,分不够再加!
的委托注册没有了
然后单步执行下
this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
单步调试中,发现三个时间代理都报错,错误都同上。
if(!IsPostBack)
{
LoadGrid();
}