Empty row in datatable

C

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
 
S

Stanimir Stoyanov

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

About autoincrement 1
Store image (jpg) in datatable 5
AllowDBNull property 1
How to identify Auto Increment fient in Access database 2
How can an output parameter update a DataTable in a DataSet 0
Update Datatable not working 1
I lose data, when I try to save a loaded DataTable on the click ofanother button in an asp.net webfo 3
detached rows in DataTable 5

Top