Show SQL : SqlCommandBuilder : ADO.Net C# Examples

    
using  System;
using  System.Data;                        //  Use  ADO.NET  namespace
using  System.Data.SqlClient;    //  Use  SQL  Server  data  provider  namespace
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");

                thisConnection.Open();
                SqlDataAdapter  thisAdapter  =  new  SqlDataAdapter("SELECT  CustomerID  from  Customers",  thisConnection);

                SqlCommandBuilder  thisBuilder  =  new  SqlCommandBuilder(thisAdapter);

                Console.WriteLine("SQL  SELECT  Command  is:\n{0}\n",  thisAdapter.SelectCommand.CommandText);

                SqlCommand  updateCommand  =  thisBuilder.GetUpdateCommand();
                Console.WriteLine("SQL  UPDATE  Command  is:\n{0}\n",updateCommand.CommandText);

                SqlCommand  insertCommand  =  thisBuilder.GetInsertCommand();
                Console.WriteLine("SQL  INSERT  Command  is:\n{0}\n",  insertCommand.CommandText);

                SqlCommand  deleteCommand  =  thisBuilder.GetDeleteCommand();
                Console.WriteLine("SQL  DELETE  Command  is:\n{0}",deleteCommand.CommandText);

                thisConnection.Close();

        }
}