Execute Non Query : OleDbCommand : ADO.Net C# Examples

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

class  MainClass
{
    static  void  Main(string[]  args)
        {
                string  ConnectionString  =  @"Provider=Microsoft.Jet.OLEDB.4.0;  Data  Source=c:\Northwind.mdb";
                OleDbConnection  conn  =  new  OleDbConnection(ConnectionString);

        conn.Open();
        OleDbCommand  cmd  =  new  OleDbCommand("Customers",  conn);


        cmd.CommandText  =  @"DELETE  *  FROM  Customers";

        cmd.ExecuteNonQuery();
                    
                conn.Close();                                    
        }
}