Delete all rows from datatable

[vbnetlearner]

How to delete all rows from a datatable?

 

[vis781]

The datatable has a clear method...

DataTable.Clear

 

[vbnetlearner]

re

Let me just try this and I will come back

 

[vbnetlearner]

thanks

Ya, it works, thanks

 

[jmcilhinney]

You should be careful with your terminology. Calling Clear actually "removes" all the rows from table. "Deleting" a DataRow and "removing" it are two different things.

 

[vis781]

Yea i know, i assumed a lot there. But based on the question i figured that it would be more about emptying the datatable rather than setting all the row states to deleted.