Dataadapter UpdateCommand

[kedar dave]

//String* con = S"Provider=Microsoft.Jet.OLEDB.4.0;" + S" DataSource=C:\\AEM\\Database\\ProTunerDatabase.mdb"; OleDbConnection* ole = new OleDbConnection( S"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\AEM\\Database\\ProTunerDatabase.mdb" ); //OleDbDataAdapter* dadapter = new OleDbDataAdapter(S"select * from Item_List", ole); OleDbDataAdapter* dadapter = new OleDbDataAdapter(); DataSet* dset = new DataSet(); ole->Open(); OleDbParameter* par; dadapter->SelectCommand = new OleDbCommand(S"select * from test", ole); dadapter->Fill( dset, S"test" ); dadapter->UpdateCommand = new OleDbCommand(S"update test set Item_name=@str where Item_id=@prev"); par = dadapter->UpdateCommand->Parameters->Add(new OleDbParameter ("@str", OleDbType::VarChar)); par->SourceColumn = "Item_name"; par->SourceVersion = DataRowVersion::Current; par = dadapter->UpdateCommand->Parameters->Add(new OleDbParameter ("@prev", OleDbType::Integer)); par->SourceColumn = "Item_id"; par->SourceVersion = DataRowVersion::Original; dadapter->UpdateCommand->Connection = ole; dadapter->Update(dset,"test"); HOW DO I SPECIFY VALUES FOR @str and @prev ???? so that i can update my database. I am using Visual C++.NET in Visual Studio 2005 Thanks, Kedar Dave:confused:

[Rob Graham]

dadapter->UpdateCommand->Parameters("@str")->Value = "test".

[kedar dave]

dadapter->UpdateCommand->Parameters("@str")->Value = "test"; I tried it....but it gave me the following errors:- error C2064: term does not evaluate to a function taking 1 arguments error C2227: left of '->Value' must point to class/struct/union/generic type why do i get this? setting par->Value = "test"; -- doesnt giv any errors but doesnt work either Thanks, Kedar Dave

[Rob Graham]

My mistake. Parameres["@str"] - square brackets, not parentheses

[kedar dave]

i did Parameters["@str"]->Value = S"test"; but got the following when i compiled : error C2107: illegal index, indirection not allowed hw do i get rid of this error? thanks a lot, Kedar Dave