Create table and populate data : OleDbCommand « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. OleDbCommand

Create table and populate data

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

public class Create {    
 public static void Main () { 
   String connect = "Provider=Microsoft.JET.OLEDB.4.0;data source=.\\Employee.mdb";
   OleDbConnection con = new OleDbConnection(connect);
   con.Open();
   OleDbCommand cmd = con.CreateCommand();

   cmd.CommandText = "CREATE TABLE Customer (CustomerID "
       + "CHAR(4), CustomerName VARCHAR(25), Address "
       + "VARCHAR(25), BalanceDue DECIMAL)";
   cmd.ExecuteNonQuery();
   cmd.CommandText = "INSERT INTO Customer VALUES (1234,'F F','22 First St.',67.00)";
   cmd.ExecuteNonQuery();
   cmd.CommandText = "INSERT INTO Customer VALUES (5678,'D D','33 Second St.',130.95)";
   cmd.ExecuteNonQuery();
   cmd.CommandText = "INSERT INTO Customer VALUES (4321,'M M','44 Third St.',0)";
   cmd.ExecuteNonQuery();
   cmd.CommandText = "INSERT INTO Customer VALUES (8765,'C C','55 Fourth St.', 0)";
   cmd.ExecuteNonQuery();

   con.Close();
 }
} 

           
       

Related examples in the same category

1.	Execute aggregate function: sum
2.	Get column average
3.	Get max column value
4.	Get count value from a select query
5.	Between certain dates
6.	Delete database records through OleDbCommand and verify the results
7.	Pass parameter to OleDbCommand
8.	How to execute a TableDirect command