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






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: sumExecute aggregate function: sum
2.Get column averageGet column average
3.Get max column valueGet max column value
4.Get count value from a select queryGet count value from a select query
5.Between certain dates
6.Delete database records through OleDbCommand and verify the results
7.Pass parameter to OleDbCommandPass parameter to OleDbCommand
8.How to execute a TableDirect command