Delete Data using CommandBuilder : SqlCommandBuilder : ADO.Net C# Examples

    
using  System;
using  System.Data;
using  System.Data.SqlClient;

    class  MainClass  
    {
        static  void  Main(string[]  args)
        {
            SqlConnection  MyConnection  =  new  SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated  Security=SSPI;");
            SqlDataAdapter  MyDataAdapter  =  new  SqlDataAdapter("SELECT  *  FROM  Employee",  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);
        }
    }