Default values on a databound form

[Vayse]

I have an access table Vehicles. There is a field Purchase Price, which has
a default value of zero.
In my databound form, I didn't include the purchase price. Now when I save,
the PurchasePrice is null. Likewise for other fields that were not on the
form.

How do I prevent vb.net from over writing the default values?
Thanks
Vayes

 

[Ken Tucker [MVP]]

Hi,

Any default values you set in access are not transfered to your
dataset. I would set the datacolumns default value.

ds.Tables("Employees").Columns.Item("Price").DefaultValue = 0



Ken

 

[Cor Ligthert [MVP]]

Vayse,

Use for this kind of operations the binding events.

You see them in use in the bottom of this sample on our website

http://www.windowsformsdatagridhelp.com/default.aspx?ID=c4832a2a-2b95-4ded-93d9-4deb7fa4a0b8

I hope this helps,

Cor