我的Delete事件的代码为:
public void Delete(Object sender, DataGridCommandEventArgs E)
{
try
{
String deleteCmd = "delete from news where id = @id";
myConnection = new System.Data.SqlClient.SqlConnection(conString);
myCommand = new System.Data.SqlClient.SqlCommand(deleteCmd, myConnection);
myCommand.Parameters.Add("@id", SqlDbType.Int, 4);
myCommand.Parameters["@id"].Value =dg.DataKeys[(int)E.Item.ItemIndex]; myConnection.Open(); try
{
myCommand.ExecuteNonQuery();
}
catch
{
}
myConnection.Close();
BindGrid();
}
catch
{
}
}
public void Delete(Object sender, DataGridCommandEventArgs E)
{
try
{
String deleteCmd = "delete from news where id = @id";
myConnection = new System.Data.SqlClient.SqlConnection(conString);
myCommand = new System.Data.SqlClient.SqlCommand(deleteCmd, myConnection);
myCommand.Parameters.Add("@id", SqlDbType.Int, 4);
myCommand.Parameters["@id"].Value =dg.DataKeys[(int)E.Item.ItemIndex]; myConnection.Open(); try
{
myCommand.ExecuteNonQuery();
}
catch
{
}
myConnection.Close();
BindGrid();
}
catch
{
}
}
if(!IsPostBack)
{
BindGrid();
}