|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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 Show quote "goldie11" <ruthie***@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: Show quote > 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 Show quote "diego" <diego***@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. ----------------------------- Show quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:OD2P2RCKHHA.2140@TK2MSFTNGP03.phx.gbl... > Diego, > > Are you sure that this clears the columns as well? > > Cor > > "diego" <diego***@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]: Show quote > Diego, > > Are you sure that this clears the columns as well? > > Cor > > "diego" <diego***@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 Show quote "diego" <diego***@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" <diego***@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:
Show quote > Yea, to clear rows of the datatable use> > 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" <diego***@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" <diego***@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. > >> > > > 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"  |
|||||||||||||||||||||||
Other interesting topics