insert a record rise an exception

[authorking]

I create the databse with the follwing code. I really don't know why the
insert operation can't be completed.
databse creation code:
ADOX.CatalogCla ss cat = new ADOX.CatalogCla ss();//define a Jet database
class
cat.Create("Pro vider=Microsoft .Jet.OLEDB.4.0; " + "Data
Source=history_ data.mdb;" + "Jet OLEDB:Engine Type=5");//create a Jet
database
System.Data.Ole Db.OleDbConnect ion hist_cnn = new
System.Data.Ole Db.OleDbConnect ion();
System.Data.Ole Db.OleDbCommand hist_command = new
System.Data.Ole Db.OleDbCommand ();
hist_command.Co mmandText="CREA TE TABLE hist_data_recor d(record_id char(8)
NOT NULL PRIMARY KEY , ball_1 smallint NOT NULL , ball_2 smallint NOT NULL ,
ball_3 smallint NOT NULL , ball_4 smallint NOT NULL , ball_5 smallint NOT
NULL , ball_6 smallint NOT NULL)";
hist_cnn.Connec tionString="Pro vider=Microsoft .Jet.OLEDB.4.0; " + "Data
Source=history_ data.mdb;" + "Jet OLEDB:Engine Type=5";
hist_cnn.Open() ;
hist_command.Co nnection=hist_c nn;
hist_command.Ex ecuteNonQuery() ;
hist_cnn.Close( );

record inersting code:
System.Data.Ole Db.OleDbConnect ion hist_cnn = new
System.Data.Ole Db.OleDbConnect ion();
System.Data.Ole Db.OleDbCommand hist_command = new
System.Data.Ole Db.OleDbCommand ();
System.Data.Dat aSet hist_data = new System.Data.Dat aSet();
hist_command.Co mmandText="inse rt into hist_data_recor d (record_id)
values('2003') ";
hist_cnn.Connec tionString="Pro vider=Microsoft .Jet.OLEDB.4.0; "
+ "Data Source=history_ data.mdb;" + "Jet OLEDB:Engine Type=5";

hist_cnn.Open() ;

hist_command.Co nnection=hist_c nn;

hist_command.Ex ecuteNonQuery() ;//rise a exception and the
operation ended

[Nick Malik]

You are getting an error because you are creating a table where each row
must have seven values... you defined each value as NOT NULL, which means
that you WANT the database to throw an error and reject any record where any
of the seven columns is null.

Then, you use an insert statement that only has one value. The rest of the
values are null.
The database is responding with an error, just like you told it to.

Either pass values for the other fields, or define the table so that the
other values are allowed to be stored as null. (Do what makes sense for
your application).

--- Nick

"authorking " <au************ @hotmail.com> wrote in message
news:uw******** *****@TK2MSFTNG P09.phx.gbl...

I create the databse with the follwing code. I really don't know why the
insert operation can't be completed.
databse creation code:
ADOX.CatalogCla ss cat = new ADOX.CatalogCla ss();//define a Jet database
class
cat.Create("Pro vider=Microsoft .Jet.OLEDB.4.0; " + "Data
Source=history_ data.mdb;" + "Jet OLEDB:Engine Type=5");//create a Jet
database
System.Data.Ole Db.OleDbConnect ion hist_cnn = new
System.Data.Ole Db.OleDbConnect ion();
System.Data.Ole Db.OleDbCommand hist_command = new
System.Data.Ole Db.OleDbCommand ();
hist_command.Co mmandText="CREA TE TABLE hist_data_recor d(record_id char(8) NOT NULL PRIMARY KEY , ball_1 smallint NOT NULL , ball_2 smallint NOT NULL , ball_3 smallint NOT NULL , ball_4 smallint NOT NULL , ball_5 smallint NOT
NULL , ball_6 smallint NOT NULL)";
hist_cnn.Connec tionString="Pro vider=Microsoft .Jet.OLEDB.4.0; " + "Data
Source=history_ data.mdb;" + "Jet OLEDB:Engine Type=5";
hist_cnn.Open() ;
hist_command.Co nnection=hist_c nn;
hist_command.Ex ecuteNonQuery() ;
hist_cnn.Close( );

record inersting code:
System.Data.Ole Db.OleDbConnect ion hist_cnn = new
System.Data.Ole Db.OleDbConnect ion();
System.Data.Ole Db.OleDbCommand hist_command = new
System.Data.Ole Db.OleDbCommand ();
System.Data.Dat aSet hist_data = new System.Data.Dat aSet();
hist_command.Co mmandText="inse rt into hist_data_recor d (record_id)
values('2003') ";
hist_cnn.Connec tionString="Pro vider=Microsoft .Jet.OLEDB.4.0; "
+ "Data Source=history_ data.mdb;" + "Jet OLEDB:Engine Type=5";

hist_cnn.Open() ;

hist_command.Co nnection=hist_c nn;

hist_command.Ex ecuteNonQuery() ;//rise a exception and the
operation ended