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();
}
}
|
