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