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;
}
}