Perform the Edit//Cancel//Update//Delete function of the DataGrid.
来源:互联网 发布:魔兽对战平台mac 编辑:程序博客网 时间:2024/06/14 00:20
this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
switch(((LinkButton)e.CommandSource).CommandName)
{
case "Edit":
try
{
this.DataGrid1.EditItemIndex = e.Item.ItemIndex;
this.binddata();
}
catch(Exception ex)
{
this.errorLabel.Text = ex.Message ;
}
break;
case "Cancel":
try
{
this.DataGrid1.EditItemIndex = -1;
this.binddata();
}
catch(Exception ex)
{
this.errorLabel.Text = ex.Message ;
}
break;
case "Delete":
try
{
this.DataGrid1.EditItemIndex = -1;
//update record
int newsId = Convert.ToInt32(e.Item.Cells[0].Text);
cmd = new SqlCommand();
conn = new SqlConnection(db.connection);
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "deletenews";
// cmd.Parameters.Add("@newsid",SqlDbType.Int).Value = newsId;
cmd.Parameters.Add("@newsid",SqlDbType.Int);
cmd.Parameters[0].Value = newsId;
conn.Open();
if(cmd.ExecuteNonQuery() == 0)
{
this.errorLabel.Text = "account error!";
}
conn.Close();
this.binddata();
}
catch(Exception ex)
{
this.errorLabel.Text = ex.Message ;
}
break;
case "Update":
try
{
this.DataGrid1.EditItemIndex = -1;
//update record
int newsId = Convert.ToInt32(e.Item.Cells[0].Text);
string title = ((TextBox)(e.Item.Cells[1].Controls[0])).Text.Trim();
string content = ((TextBox)(e.Item.Cells[2].Controls[0])).Text.Trim();
cmd = new SqlCommand();
conn = new SqlConnection(db.connection);
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "updatenews";
cmd.Parameters.Add("@newsid",SqlDbType.NVarChar).Value = newsId;
cmd.Parameters.Add("@title",SqlDbType.NVarChar).Value = title;
cmd.Parameters.Add("@content",SqlDbType.NVarChar).Value = content;
conn.Open();
if(cmd.ExecuteNonQuery() == 0)
{
this.errorLabel.Text = "account error!";
}
conn.Close();
this.binddata();
}
catch(Exception ex)
{
this.errorLabel.Text = ex.Message ;
}
break;
default:
break;
}
}
- Perform the Edit//Cancel//Update//Delete function of the DataGrid.
- GridView 编辑功能实现 Delete 、 Update、Edit、Cancel
- 【MongoDB】The basic operation of Mongodb, Insert\Query\Delete\Update
- flex/in the datagrid,how to get the new value of cell in the datagrid after edit
- The Function of MaxValue
- The pointer of function
- The Semantics of Function
- 错误信息:Couldn't perform the edit because another user changed the record.
- delete the element of array
- "delete this;" in the member function
- The useage of statfs function
- the implement of system function.
- The properties of Impulse Function
- You must perform a full uninstall of the application
- the Demo of Beep function of WinAPI
- delete ^M at the end of line
- 【MonogoDB】The high update operation of MongoDB
- You must perform a full uninstall of the application. WARNING: This will remove the application data!
- dataGrid前台修改数据,不刷新页面
- A Map instance
- use ItemCreated to set the page style of DataGrid
- 自定义控件(可以动态加载用户控件)
- 改变 PropertyGrid 控件的编辑风格(1)——加入日期控件
- Perform the Edit//Cancel//Update//Delete function of the DataGrid.
- osworkflow 小培训(1)
- 浅谈WebForm中DataGrid的ItemDataBound事件
- 怎么对数据库进行压缩处理
- 【翻译】用EXcel扩展.NET应用程序
- 改变 PropertyGrid 控件的编辑风格(2)——编辑多行文本
- 存储过程DataGrid分页及注意点
- Socket:SendMail
- 改变 PropertyGrid 控件的编辑风格(3)——打开对话框