dataview problem after clear()

[toufik]

Hi,
In my winform, I bind the controls to a dataview DV1 that is created on a
datatable TABLE1,
The problem is the I loose the binding when I refill the datatable (CLEAR(),
dataadapter.fill(dataset1,"TABLE1")).

Any idea pllease

 

[Cor Ligthert [MVP]]

Toufik,

How do you do the clear exactly?

Because I don't know a command
Datatable(Clear()

And if you do it by
mydatatable = new datatable,

Than it is clear

Cor

 

[toufik]

exactly here is the process:
1- ONLOAD:
- create dataadapter DA1
- DA1.fill(DS1,"TABLE1")
- create dataview DV1 on table TABLE1
- bind the controls to the dataview DV1
(every thing works OK)

2- On ACTIVATE event (because I change the data in another form and I
re-load the information)
- create a new datadapter DA1 (which has the same structure but not the same
rows)
- DS1.tables("TABLE1").clear()
- DA1.fill(DS1,"TABLE1")

here I loose the binding, exactly because of the CLEAR thar I did for the
dataset.tables("TABLE1"), if I remove the clear the binding still here but I
don't have the information I need (the old information stay here)

Thanks for any help.

 

[Cor Ligthert [MVP]]

Toufik,

I am not so sure about that datatable.clear (the information on MSDN is
obviously wrong, which I have reported)

Can you try this instead

http://msdn.microsoft.com/library/d...ystemdatadatarowcollectionclasscleartopic.asp

Cor