Search:

Thanks for your reply,

I have itemID in the form but its is hidden. what could be causing the ovewrite on the differend datarow.

Hu guys ,

I have a problem when updating my SQL database. When am trying to update an item, the update works fine but I get the following problems:
1. The ItemName combobox item list displays...

Tanx so much Make me rain

I finally got it Kudos

Best Regards!!

thanks alot almost there.. now i get the following error

Conversion failed when converting character string to smalldatetime data type.

Make me rain,

U have almost made my day.


I have used your code but i get an error that i must declare scalar variable ' requisitionID' How do i get to fix this one ?

Yes I did what u pointed out.

Thinks it is something to do with convertsion of datatype at runtime

Make me Rain,

Tried all that bt still getting "format exception was unhandled" . Failed to convert parameter value to a int32.

Can u show me how i can convert the datagrid cell values from...

Guys'

even after trying out your options i still get the same error at the line- nonqueryCommand.ExecuteNonQuery()

Pls review my current code and point out any mistakes.

Private Sub...

cicatrix
i forgot to remove the single quotes, m have also changed my database tables.le'me try again

make me rain
The datagridview is not bound to data " i fill it programmatically"

will...

sorry not the one i sent before but this:

nonqueryCommand.ExecuteNonQuery()

this line

nonqueryCommand.Prepare()

Thanks Citrix

I tried changing my table and code bu still get the same error 'failed to convert parameter value from string to int32".

My new code is as follows:

Private Sub...

Hi Guys,

I am new to Vb.net please help me sort out this problem. Formatexceptionunhandled:

i am trying to save data from unbound datagridview to sql database.

Failed to convert parameter...