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

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 wrote:
> 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

Uzytkownik "Jacob" <(E-Mail Removed)> napisal w wiadomosci
news:(E-Mail Removed)...
> 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).

U¿ytkownik "Emil" <(E-Mail Removed)> napisa³ w wiadomo¶ci
news:emqrr0$q4r$(E-Mail Removed)...
>
> Uzytkownik "Jacob" <(E-Mail Removed)> napisal w wiadomosci
> news:(E-Mail Removed)...
>> 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).
>
I've solved the problem. I switched from Access to SQL Express and now
everything works fine

Thanks for help anyway

Emil,

To nie moze byc prawda

Cor

"Emil" <(E-Mail Removed)> schreef in bericht news:emqub6$s9l$(E-Mail Removed)...
>
> U¿ytkownik "Emil" <(E-Mail Removed)> napisa³ w wiadomo¶ci
> news:emqrr0$q4r$(E-Mail Removed)...
>>
>> Uzytkownik "Jacob" <(E-Mail Removed)> napisal w wiadomosci
>> news:(E-Mail Removed)...
>>> 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).
>>
> I've solved the problem. I switched from Access to SQL Express and now
> everything works fine
>
> Thanks for help anyway
>
>

Ich habe das in bericht nicht geschreiben.

Uzytkownik "Cor Ligthert [MVP]" <(E-Mail Removed)> napisal w wiadomosci news:(E-Mail Removed)...
Emil,

To nie moze byc prawda

Cor

"Emil" <(E-Mail Removed)> schreef in bericht news:emqub6$s9l$(E-Mail Removed)...
>
> U¿ytkownik "Emil" <(E-Mail Removed)> napisa³ w wiadomo¶ci
> news:emqrr0$q4r$(E-Mail Removed)...
>>
>> Uzytkownik "Jacob" <(E-Mail Removed)> napisal w wiadomosci
>> news:(E-Mail Removed)...
>>> 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).
>>
> I've solved the problem. I switched from Access to SQL Express and now
> everything works fine
>
> Thanks for help anyway
>
>