DataAdapter.Update method problem.

[Emil]

I've created a very simple data base in Microsoft Access 2003. It consists
of only one table called "Students" and it contains 2 information about each
student: id-student and name.

When I try to manipulate data in database I get an error, here's a sample:

OleDbConnection connection;
connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\ecdl.mdb");


OleDbDataAdapter dataAdapter = new OleDbDataAdapter ("SELECT * FROM
Students",connection);

OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter);

DataSet dataSet = new DataSet();

dataAdapter.Fill(dataSet, "Students");



DataRow dataRow = dataSet.Tables["Students"].Rows[4];

dataRow["Name"] = "Peter";


dataAdapter.Update(dataSet, "Students"); //here I get an error



connection.Close();

Console.ReadLine();

And the error is: " Any value given for one or many parameters required"
Please help
Thanks in advance
Emil

 

[Jacob]

I'm guessing the student-id in your database table is the primary key
and that it has an auto-increment value, correct?

This does not automatically get copied into your datatable, so you need
to set AutoIncrement to true on the column and possible set the
relevant seed also.

 

[Emil]

I'm guessing the student-id in your database table is the primary key
and that it has an auto-increment value, correct?

This does not automatically get copied into your datatable, so you need
to set AutoIncrement to true on the column and possible set the
relevant seed also.

id-student is the primary key but it hasn't an auto-increment value (it must
be typed by hand).

 

[Emil]

id-student is the primary key but it hasn't an auto-increment value (it
must be typed by hand).

I've solved the problem. I switched from Access to SQL Express and now
everything works fine

Thanks for help anyway

 

[Cor Ligthert [MVP]]

Emil,

To nie moze byc prawda

Cor

I've solved the problem. I switched from Access to SQL Express and now
everything works fine

Thanks for help anyway

 

[Emil]

Ich habe das in bericht nicht geschreiben.

Uzytkownik "Cor Ligthert [MVP]" <[email protected]> napisal w wiadomosci Emil,

To nie moze byc prawda

Cor