okay i have a problem with my programm...i am using OleDb for my database .And updating the database is throwing an exception ...
that states "no value given for one or more specific parameter"
the code is
Code:
cmd.CommandText = @"UPDATE "+ client.GetKey(clientComboBox.SelectedIndex).ToString().Replace(' ','_').Replace(',','_') + @" SET Cno = Cno, [Date] = date,Origin = origin, Destination = destination, SenderAddress = senderAdd, ConAddress = conAdd, Dox = ""dox"", NonDox = nonDox, Express = express, AirCargo = airCargo, Surface = road, Kgms = kgms, Amount = amount WHERE Cno = str" ;
cmd.ExecuteNonQuery();
amount = cno = kgms are int
the rest are strings