Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Show SQL from SqlCommandBuilder

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(                 @"Data Source=.\SQLEXPRESS;" +                 @"AttachDbFilename='NORTHWND.MDF';" +                 @"Integrated Security=True;Connect Timeout=30;User Instance=true");       thisConnection.Open();       SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT CustomerID from Customers", thisConnection);       SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);       Console.WriteLine(thisAdapter.SelectCommand.CommandText);       SqlCommand updateCommand = thisBuilder.GetUpdateCommand();       Console.WriteLine(updateCommand.CommandText);       SqlCommand insertCommand = thisBuilder.GetInsertCommand();       Console.WriteLine(insertCommand.CommandText);       SqlCommand deleteCommand = thisBuilder.GetDeleteCommand();       Console.WriteLine(deleteCommand.CommandText);       thisConnection.Close();     }   }