Member Avatar for Adrian99420

Hi,

I am trying to update a MS access table from my combobox selected item. Here is what I wrote:

String^sqlQuery= "UPDATE Profiles SET "+"Wallpaper='"+ comboBox1->SelectedItem->ToString()+"',Ringtone='"+comboBox2->SelectedItem->ToString()+"'"+"WHERE Profile_Name=MotoX";

this->oleDbDataAdapter1->SelectCommand->CommandText=sqlQuery;
this->oleDbConnection1->Open();
this->oleDbDataAdapter1->UpdateCommand->Connection=oleDbConnection1;
this->oleDbDataAdapter1->UpdateCommand->ExecuteNonQuery();
this->oleDbConnection1->Close();

However, I keep getting error of "Parameter ?_1 has no default value"
I searched through many website but still unable to slove this...pls lend me some help...million thanks.

  • 1 Contributor
  • 1 Reply
  • 78 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by Adrian99420
Member Avatar for Adrian99420

Any idea? I still unable to solve this issue....Pls lend me some help...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.