参考一下,试试
    public void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs e)
    {
        String deleteCmd = "DELETE from farelist where farenumber = @fnumber";        SqlCommand myCommand = new SqlCommand(deleteCmd, myConnection);
        myCommand.Parameters.Add(new SqlParameter("@fnumber", SqlDbType.NVarChar, 50));
        myCommand.Parameters["@fnumber"].Value = MyDataGrid.DataKeys[(int)e.Item.ItemIndex];        myCommand.Connection.Open();        try
        {
            myCommand.ExecuteNonQuery();
            Message.InnerHtml = "<b><font color=red>删除成功</font></b><br>";
        }
        catch (SqlException)
        {
            Message.InnerHtml = "ERROR: Could not delete record";
            Message.Style["color"] = "red";
        }        myCommand.Connection.Close();
    }