Csharp/C Sharp/Database ADO.net/Delete

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

Deleting Data

<source lang="csharp">

using System; using System.Data; using System.Data.SqlClient; using System.Collections.Generic; using System.Text; class Program {

   static void Main(string[] args) {
       SqlConnection thisConnection = new SqlConnection(
            @"Server=(local)\sqlexpress;Integrated Security=True;" +
            "Database=northwind");
       SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT CustomerID, CompanyName FROM Customers", thisConnection);
       SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
       DataSet thisDataSet = new DataSet();
       thisAdapter.Fill(thisDataSet, "Customers");
       Console.WriteLine("# rows before change: {0}",thisDataSet.Tables["Customers"].Rows.Count);
       DataColumn[] keys = new DataColumn[1];
       keys[0] = thisDataSet.Tables["Customers"].Columns["CustomerID"];
       thisDataSet.Tables["Customers"].PrimaryKey = keys;
       DataRow findRow = thisDataSet.Tables["Customers"].Rows.Find("ZACZI");
       if (findRow != null) {
           findRow.Delete();
           thisAdapter.Update(thisDataSet, "Customers");
       }
       Console.WriteLine("# rows after change: {0}",
            thisDataSet.Tables["Customers"].Rows.Count);
       thisConnection.Close();
   }

}


      </source>


Deleting Data Using SqlCommandBuilder

<source lang="csharp"> /*

* C# Programmers Pocket Consultant
* Author: Gregory S. MacBeth
* Email: gmacbeth@comporium.net
* Create Date: June 27, 2003
* Last Modified Date:
* Version: 1
*/

using System; using System.Data; using System.Data.SqlClient; namespace Client.Chapter_13___ADO.NET {

   public class DeletingDataUsingCommandBuilder
   {
       static void Main(string[] args)
       {
           SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
           SqlDataAdapter MyDataAdapter = new SqlDataAdapter("SELECT * FROM Test", MyConnection);
           SqlCommandBuilder MyCmd = new SqlCommandBuilder(MyDataAdapter);
           DataSet MyDataSet = new DataSet();
           MyDataAdapter.Fill(MyDataSet);
           DataColumn[] MyKey = new DataColumn[1];
           MyKey[0] = MyDataSet.Tables[0].Columns[0];
           MyDataSet.Tables[0].PrimaryKey = MyKey;
           DataRow FindMyRow = MyDataSet.Tables[0].Rows.Find(1);
           FindMyRow.Delete();
           MyDataAdapter.Update(MyDataSet);
       }
   }

}


      </source>


Deleting Data Using SQLStatements

<source lang="csharp"> /*

* C# Programmers Pocket Consultant
* Author: Gregory S. MacBeth
* Email: gmacbeth@comporium.net
* Create Date: June 27, 2003
* Last Modified Date:
* Version: 1
*/

using System; using System.Data; using System.Data.SqlClient; namespace Client.Chapter_13___ADO.NET {

   public class DeletingDataUsingSQLStatements
   {
       static void Main(string[] args)
       {
           SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
           MyConnection.Open();
           String MyString = "DELETE Test";
           SqlCommand MyCmd = new SqlCommand(MyString, MyConnection);
           MyCmd.ExecuteScalar();
           MyConnection.Close();
       }
   }

}


      </source>