insert a data record into a data table of a access database(mdb)
From: authorking (authorking2002_at_hotmail.com)
Date: 08/03/04
- Next message: Tiago Costa: "string error"
- Previous message: Wayne: "Re: Using C# Classes in win 32 application"
- Next in thread: Nicholas Paldino [.NET/C# MVP]: "Re: insert a data record into a data table of a access database(mdb)"
- Reply: Nicholas Paldino [.NET/C# MVP]: "Re: insert a data record into a data table of a access database(mdb)"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 3 Aug 2004 20:22:17 +0800
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.
- Next message: Tiago Costa: "string error"
- Previous message: Wayne: "Re: Using C# Classes in win 32 application"
- Next in thread: Nicholas Paldino [.NET/C# MVP]: "Re: insert a data record into a data table of a access database(mdb)"
- Reply: Nicholas Paldino [.NET/C# MVP]: "Re: insert a data record into a data table of a access database(mdb)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
