Hi

Windows Form and vb.net (Framework Properties)

How do you control the grid so that it uses the allow null, default values and field types and sizes from the Sql Database Table?

When I add a record to the grid it seems to ignore the information from the Sql Database Table. Puts in almost in every field.

On smaller sized fields with length of less than 7 is seems not to put in a value and works wtih the AddNew record without an error message of Column 'MlsOfficeId' does not allow nulls. Do you want to correct the value?

The grid put the value into the field in the first place. In SQL query the field shows nothing (varchar with the length of 0) and allownulls not checked.

Why is the grid putting in values where they do not belong?


Thanks
Roland