DataAdapter fills wrong table?

  • Thread starter Thread starter al
  • Start date Start date
A

al

Greetings,

I have an app. One MDI parent(main),one dataset,two MDI childs,
Employees and Custoemrs,respectivly. User starts app, cliks button
to show Employees form and dataadapter(DA) then fills dataset from
Select * from employee. Then user clicks another button to show the
Customers Form and DA fills the same dataset from Select * from
customers. The problem is when the user tries to refresh the first
form, Employees form in this case, an error occurs saying mismatch
happens betweeen dataset tables then shows some fields from customers
table in Employees form. The tables I use are ActiveMdiChild.Text
property which is passed to the dataadapter.fill method.


Case Refresh
If ActiveMdiChild is ActiveMdiChild Then
DatasetNorthwind.Tables(ActiveMdiChild.Text).Clear()
DataadapterNorthwind.Fill(DatasetNorthwind,ActiveControl.Text)
End If
End Case

It seems to me that DA fills the last used table, no matter what.
Help please.

MTIA,
Grawsha
 
Hi al,

It should be better if you were using two dataadapters - for one table one
adapter.
Anyway, did you notice that you are using different controls
(ActiveMdiChild, ActiveControl.Text) in your method?
And what is the meaning of
If ActiveMdiChild is ActiveMdiChild Then?
 
Miha Markic said:
Hi al,

It should be better if you were using two dataadapters - for one table one
adapter.
Anyway, did you notice that you are using different controls
(ActiveMdiChild, ActiveControl.Text) in your method?
And what is the meaning of
If ActiveMdiChild is ActiveMdiChild Then?
Click to expand...

Miha,
Thanks for your help.
It should be better if you were using two dataadapters - for one table one
adapter.
Click to expand...
But if I have the same connection(to one db) and even the same SQL
statement (but different tables), will it be better to just pass those
to a global DA in class module?
Anyway, did you notice that you are using different controls
(ActiveMdiChild, ActiveControl.Text) in your method?
Click to expand...
Sorry, that was a typo.
And what is the meaning of
If ActiveMdiChild is ActiveMdiChild Then?
Click to expand...
Refresh case is the same for all mdi child form. And Since i'm dealing
with MDI app, I will always have one ACTIVE Mdi Child. just a way to
have .net excute this refresh case.
 
Al,

What overload of Fill are you using? You can pass the explicit DataTable you
want filled if you like and side step these issues.

Kathleen
 
Back
Top