Empty row in datatable

[Cdude]

When i save the datatable to the database how can i remove a row that
has an auto increment column but the rest of the row has no values.

1 Jed 5 Heron Street
2 Maria 6 Crane Rode
3 NULL NULL

now when i update to the database i need to remove row 3 or whatever
row has no values.thanks

[Stanimir Stoyanov]

Re: Empty row in datatable

Assuming the column names are Person and Address, having updated the
database you could execute another query, deleting the rows for which Person
= NULL OR Address = NULL.

Best Regards,
Stanimir Stoyanov
www.stoyanoff.info

"Cdude" <cameljs18@yaho o.comwrote in message
news:131b36b1-fff8-4cb0-91e1-6b41c519a466@2g 2000hsn.googleg roups.com...

When i save the datatable to the database how can i remove a row that
has an auto increment column but the rest of the row has no values.
>
1 Jed 5 Heron Street
2 Maria 6 Crane Rode
3 NULL NULL
>
now when i update to the database i need to remove row 3 or whatever
row has no values.thanks