SqlDataAdapter.DeleteCommand删除记录

SqlConnection nwindConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
nwindConn.Open();
SqlDataAdapter catDA = new SqlDataAdapter("SELECT CategoryID, CategoryName FROM Categories", nwindConn);
DataSet catDS = new DataSet();
catDA.Fill(catDS, "Categories");

catDA.DeleteCommand = new SqlCommand("DELETE FROM Categories WHERE CategoryID=@CategoryID", nwindConn);
SqlParameter workParm3 = catDA.DeleteCommand.Parameters.Add("@CategoryID", SqlDbType.Int);
workParm3.SourceColumn = "CategoryID";
workParm3.SourceVersion = DataRowVersion.Original;
catDS.Tables["Categories"].Rows[catDS.Tables["Categories"].Rows.Count - 1].Delete();
catDA.Update(catDS, "Categories");

nwindConn.Close();
Console.WriteLine("按任意键继续...");
Console.ReadLine();

SqlDataAdapter catDA = new SqlDataAdapter("SELECT CategoryID, CategoryName FROM Categories", nwindConn);

SqlDataAdapter catDA = new SqlDataAdapter("SELECT * FROM Categories", nwindConn);