dataTable.Clear()

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.

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



"goldie11" <ruthie_fy@yahoo.com> escribió en el mensaje
news:1166948793.051707.125700@79g2000cws.googlegroups.com...
> 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.
>

Hi,

try using:

datatable.rows.clear()

hth

Ayon kay 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.

Diego,

Are you sure that this clears the columns as well?

Cor

"diego" <diegobph@yahoo.com> schreef in bericht
news:1167040317.175017.178110@79g2000cws.googlegroups.com...
> Hi,
>
> try using:
>
> datatable.rows.clear()
>
> hth
>
> Ayon kay 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.
>

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

Robin S.
-----------------------------
"Cor Ligthert [MVP]" <notmyfirstname@planet.nl> wrote in message
news:OD2P2RCKHHA.2140@TK2MSFTNGP03.phx.gbl...
> Diego,
>
> Are you sure that this clears the columns as well?
>
> Cor
>
> "diego" <diegobph@yahoo.com> schreef in bericht
> news:1167040317.175017.178110@79g2000cws.googlegroups.com...
>> Hi,
>>
>> try using:
>>
>> datatable.rows.clear()
>>
>> hth
>>
>> Ayon kay 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.
>>
>
>

Cor,

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

Diego

Ayon kay Cor Ligthert [MVP]:
> Diego,
>
> Are you sure that this clears the columns as well?
>
> Cor
>
> "diego" <diegobph@yahoo.com> schreef in bericht
> news:1167040317.175017.178110@79g2000cws.googlegroups.com...
> > Hi,
> >
> > try using:
> >
> > datatable.rows.clear()
> >
> > hth
> >
> > Ayon kay 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.
> >

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

"diego" <diegobph@yahoo.com> schreef in bericht
news:1167123250.623399.325410@48g2000cwx.googlegroups.com...
> Cor,
>
> the op said he only wanted to clear the rows, not the columns as well.
>
> Diego
>
> Ayon kay Cor Ligthert [MVP]:
>> Diego,
>>
>> Are you sure that this clears the columns as well?
>>
>> Cor
>>
>> "diego" <diegobph@yahoo.com> schreef in bericht
>> news:1167040317.175017.178110@79g2000cws.googlegroups.com...
>> > Hi,
>> >
>> > try using:
>> >
>> > datatable.rows.clear()
>> >
>> > hth
>> >
>> > Ayon kay 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.
>> >
>

Cor Ligthert [MVP] wrote:
> 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
>
> "diego" <diegobph@yahoo.com> schreef in bericht
> news:1167123250.623399.325410@48g2000cwx.googlegroups.com...
> > Cor,
> >
> > the op said he only wanted to clear the rows, not the columns as well.
> >
> > Diego
> >
> > Ayon kay Cor Ligthert [MVP]:
> >> Diego,
> >>
> >> Are you sure that this clears the columns as well?
> >>
> >> Cor
> >>
> >> "diego" <diegobph@yahoo.com> schreef in bericht
> >> news:1167040317.175017.178110@79g2000cws.googlegroups.com...
> >> > Hi,
> >> >
> >> > try using:
> >> >
> >> > datatable.rows.clear()
> >> >
> >> > hth
> >> >
> >> > Ayon kay 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.
> >> >
> >


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"