insert a data record into a data table of a access database(mdb)

  • Thread starter Thread starter authorking
  • Start date Start date
A

authorking

I use the following code to insert a data record in to a datatable of an
access database.But every time I execute the command, there will rise an
exception and the insert operation can't be completed.
here's the code:
System.Data.OleDb.OleDbConnection hist_cnn = new
System.Data.OleDb.OleDbConnection();

System.Data.OleDb.OleDbCommand hist_command = new
System.Data.OleDb.OleDbCommand();

System.Data.DataSet hist_data = new System.Data.DataSet();

hist_command.CommandText="insert into hist_data_record
(record_id) values('2003') ";

hist_cnn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=history_data.mdb;" + "Jet OLEDB:Engine Type=5";

hist_cnn.Open();

hist_command.Connection=hist_cnn;

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

I want to know where the problems is.
 
authorking,

Does it give any more information than that in the exception? There
should be more information than that in the exception message and the call
stack (for example, it was a COM error code that was returned, what is
that?).
 
The more information given by system is :
"Unhandled"System.Data.OleDb.OleException" exception rised in
system.data.dll"

Is there any better menthod to insert a data record into an access database
table?





Nicholas Paldino said:
authorking,

Does it give any more information than that in the exception? There
should be more information than that in the exception message and the call
stack (for example, it was a COM error code that was returned, what is
that?).


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

authorking said:
I use the following code to insert a data record in to a datatable of an
access database.But every time I execute the command, there will rise an
exception and the insert operation can't be completed.
here's the code:
System.Data.OleDb.OleDbConnection hist_cnn = new
System.Data.OleDb.OleDbConnection();

System.Data.OleDb.OleDbCommand hist_command = new
System.Data.OleDb.OleDbCommand();

System.Data.DataSet hist_data = new System.Data.DataSet();

hist_command.CommandText="insert into hist_data_record
(record_id) values('2003') ";

hist_cnn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=history_data.mdb;" + "Jet OLEDB:Engine Type=5";

hist_cnn.Open();

hist_command.Connection=hist_cnn;

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

I want to know where the problems is.
Click to expand...
Click to expand...
 
authorking,

That's probably the way you do it. Can you give a short example, as
well as post the MDB that you are trying to insert the record into that
displays the problem?


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

authorking said:
The more information given by system is :
"Unhandled"System.Data.OleDb.OleException" exception rised in
system.data.dll"

Is there any better menthod to insert a data record into an access database
table?





"Nicholas Paldino [.NET/C# MVP]" <[email protected]> дÈëÓʼþ
authorking,

Does it give any more information than that in the exception? There
should be more information than that in the exception message and the call
stack (for example, it was a COM error code that was returned, what is
that?).


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

authorking said:
I use the following code to insert a data record in to a datatable of an
access database.But every time I execute the command, there will rise an
exception and the insert operation can't be completed.
here's the code:
System.Data.OleDb.OleDbConnection hist_cnn = new
System.Data.OleDb.OleDbConnection();

System.Data.OleDb.OleDbCommand hist_command = new
System.Data.OleDb.OleDbCommand();

System.Data.DataSet hist_data = new System.Data.DataSet();

hist_command.CommandText="insert into hist_data_record
(record_id) values('2003') ";

hist_cnn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=history_data.mdb;" + "Jet OLEDB:Engine Type=5";

hist_cnn.Open();

hist_command.Connection=hist_cnn;

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

I want to know where the problems is.
Click to expand...
Click to expand...
Click to expand...
 
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.CatalogClass cat = new ADOX.CatalogClass();//define a Jet database
class
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data
Source=history_data.mdb;" + "Jet OLEDB:Engine Type=5");//create a Jet
database
System.Data.OleDb.OleDbConnection hist_cnn = new
System.Data.OleDb.OleDbConnection();
System.Data.OleDb.OleDbCommand hist_command = new
System.Data.OleDb.OleDbCommand();
hist_command.CommandText="CREATE TABLE hist_data_record(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.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;" + "Data
Source=history_data.mdb;" + "Jet OLEDB:Engine Type=5";
hist_cnn.Open();
hist_command.Connection=hist_cnn;
hist_command.ExecuteNonQuery();
hist_cnn.Close();

record inersting code:
System.Data.OleDb.OleDbConnection hist_cnn = new
System.Data.OleDb.OleDbConnection();
System.Data.OleDb.OleDbCommand hist_command = new
System.Data.OleDb.OleDbCommand();
System.Data.DataSet hist_data = new System.Data.DataSet();
hist_command.CommandText="insert into hist_data_record (record_id)
values('2003') ";
hist_cnn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=history_data.mdb;" + "Jet OLEDB:Engine Type=5";

hist_cnn.Open();

hist_command.Connection=hist_cnn;

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



Nicholas Paldino said:
authorking,

That's probably the way you do it. Can you give a short example, as
well as post the MDB that you are trying to insert the record into that
displays the problem?


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

authorking said:
The more information given by system is :
"Unhandled"System.Data.OleDb.OleException" exception rised in
system.data.dll"

Is there any better menthod to insert a data record into an access database
table?





"Nicholas Paldino [.NET/C# MVP]" <[email protected]> дÈëÓʼþ
authorking,

Does it give any more information than that in the exception? There
should be more information than that in the exception message and the call
stack (for example, it was a COM error code that was returned, what is
that?).


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I use the following code to insert a data record in to a datatable
Click to expand...
Click to expand...
of
an
Click to expand...
rise
an
Click to expand...
Click to expand...
 
Back
Top