DataGridView and Adding Entries

[Ian Semmel]

I have a DataGridView bound to a DataTable which is keyed on an Identity.

Now I want users to be able to fill in the table just by enetering data and tab
between fields and across row boundaries.

What I am having trouble with is deciding when to update the table and I keep on
getting exceptions (like DbNull).

Do you have to do an update at the end of each row ?

Also, there appears to be a difference when the table is initially empty - what
do I do in _DefaultValuesNeeded ?

Obviously, I am a bit confused, but there appear to be so many places where
defaults etc can be filled in. Can anyone point me to a definitive example of
DataGridView used this way ?

[Kevin Spencer]

Are you not using a BindingSource?

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.

"Ian Semmel" <is***********@NOKUNKrocketcomp.com.au> wrote in message
news:u5**************@TK2MSFTNGP03.phx.gbl...

I have a DataGridView bound to a DataTable which is keyed on an Identity.

Now I want users to be able to fill in the table just by enetering data
and tab between fields and across row boundaries.

What I am having trouble with is deciding when to update the table and I
keep on getting exceptions (like DbNull).

Do you have to do an update at the end of each row ?

Also, there appears to be a difference when the table is initially empty -
what do I do in _DefaultValuesNeeded ?

Obviously, I am a bit confused, but there appear to be so many places
where defaults etc can be filled in. Can anyone point me to a definitive
example of DataGridView used this way ?

[Ian Semmel]

So is that where I should be looking ?

Yes, I am using BindingSource (but not BindingNavigator)

I forgot to mention that in the DataGridView, some of the columns (including the
identity) are not visible (if that makes a difference)

Kevin Spencer wrote:

Are you not using a BindingSource?

[Kevin Spencer]

Also, have you specified default values for database table columns that do
not allow null values?

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.

"Ian Semmel" <is***********@NOKUNKrocketcomp.com.au> wrote in message
news:eM**************@TK2MSFTNGP05.phx.gbl...

So is that where I should be looking ?

Yes, I am using BindingSource (but not BindingNavigator)

I forgot to mention that in the DataGridView, some of the columns
(including the identity) are not visible (if that makes a difference)

Kevin Spencer wrote:

Are you not using a BindingSource?

[Kevin Spencer]

Does the database table that it is bound to allow nulls in the columns which
are empty when you try to update the DataTable? The DataTable should be
using the constraints set up by the database table, including allowing or
disallowing nulls.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.

"Ian Semmel" <is***********@NOKUNKrocketcomp.com.au> wrote in message
news:eM**************@TK2MSFTNGP05.phx.gbl...

So is that where I should be looking ?

Yes, I am using BindingSource (but not BindingNavigator)

I forgot to mention that in the DataGridView, some of the columns
(including the identity) are not visible (if that makes a difference)

Kevin Spencer wrote:

Are you not using a BindingSource?