dataTable.Clear()

[goldie11]

Hi,

I would like to remove all the rows of a DataTable - but not by using a
loop through all the DataRows - but by using a single command.
I tried - dataTable.Clear() which is supposed to remove all rows of the
dataTable - but it doesn't seem to work - the table is still full.

Any idea?

Thanks you all.

 

[Jesús López]

Please, can you elaborate on "but it doesn't seem to work" ?. Based on my
experience, DataTable.Clear() works fine and as expected ...

Regards,

Jesús López

 

[diego]

Hi,

try using:

datatable.rows.clear()

hth

Ayon kay goldie11:

 

[Cor Ligthert [MVP]]

Diego,

Are you sure that this clears the columns as well?

Cor

 

[RobinS]

He could use datatable.reset -- this returns the datatable
to its original, uninitialized state.

Robin S.

 

[diego]

Cor,

the op said he only wanted to clear the rows, not the columns as well.

Diego

Ayon kay Cor Ligthert [MVP]:

 

[Cor Ligthert [MVP]]

Yea,

But datatable.clear as Jesus wrote should do that fine, therefore we should
in my idea wait on the answer on that, can be interesting..

Cor

 

[nil]

Yea,

But datatable.clear as Jesus wrote should do that fine, therefore we should
in my idea wait on the answer on that, can be interesting..

Cor

to clear rows of the datatable use
datatable.rows.clear
and it works fine and to clear columns use
datatable.columns.clear
and it will work

Thanks & Regards,
Nil
"Problem is just the distance between the expectation and the reality"