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.