Hi Bonnie,
I checked that parameters and they apper to be correct.
Do you know if the dataadapter and dataset wizards generate code that will update fields that are in the dataset but defined with a control on the form?
Thanks
Roland
=======================================================================
>Roland,
>
>Is it possible that your parameter datatypes are not datetime?
>
>~~Bonnie
>
>
>>Hi,
>>
>>Using VS Framework .net, Windows Forms and VB .net
>>
>>I am trying to insert a new value when a new record is inserted into the Sql Table using the following commands. The Connection and DataAdapter are created using the dataadapter wizards. Not having any problems with fields that have controls assigned to them in the form, just sql fields with not controls defined. SqlInsertCommand1 is the assigned name that shows in the property window.
>>
>> SqlInsertCommand1.Parameters("@DateInsert").Value = Now
>> SqlInsertCommand1.Parameters("@DateUpdate").Value = Now
>> SqlInsertCommand1.Parameters("@StatusDate").Value = Now
>>
>> Me.SqlDaListing.Update(Listing01_Ds1, "Listing")
>>
>>All fields except the three parameter fields above gets inserted into the sql record.
>>
>>What do I need to do to have these values inserted properly?
>>
>>Thanks
>>Roland
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only