Need help fast, DataSet question!

[Lars Netzel]

I'm trying to copy data from two tables in a Source db into two Tables in a
Destination db and the Tables designa are the same.

I created 4 adapters...

2 for the two tables in the source db
2 for the 2 tables in the destination db

Then I filled a SourceDataSet with the Source adapters

and then I update the destination adapters with the SourceDataset.

But the information is not copied, what can I do???

I need help really fast, please!

/Lars

[Cor Ligthert]

Hi Lars,

First of all, we try to learn as well from this newsgroup and like to have
some feedback on questions.

I don't know how it is with others, however when I give an answer I get the
idea, that you never read it.

To give an answer on your question. What do you mean with copy because I get
the idea because you are talking about a dataadapter, that it is not this
code?

dim datasetNew as new dataset = datasetOld.copy

Cor

[Lars Netzel]

Okay I have this code!

Private Sub Importdata()

Try

dsDestination = dsSource.Copy

adpDestinationD isk.Update(dsDe stination, "Disktable" )

adpDestinationE vent.Update(dsD estination, "Eventtable ")

Catch ex As Exception

MsgBox(ex.Messa ge)

End Try

DataGrid2.DataS ource = dsDestination

End Sub
I dataset is updated alright but the changes are never written into the
Database associated with the Destination adapters.

I don't get any error, the Update Just does'nt seem to happen. But the
Datagrid shows the dataset fine.

And about the first thign you wrote, you mean I never say thank you or you
mean I don't answer questions?

I do both, but as you probably have noticed, i'm not that good yet and most
questions I have no idea abotu how to answer.

I'm very thankful I get answers in here, it's helping me a lot!

/Lars


"Cor Ligthert" <no**********@p lanet.nl> skrev i meddelandet
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

Hi Lars,

First of all, we try to learn as well from this newsgroup and like to have
some feedback on questions.

I don't know how it is with others, however when I give an answer I get the idea, that you never read it.

To give an answer on your question. What do you mean with copy because I get the idea because you are talking about a dataadapter, that it is not this
code?

dim datasetNew as new dataset = datasetOld.copy

Cor

[Cor Ligthert]

Hi Lars,

Am I right that the second update does not work and the first does.

The dataadapter has an automaticly accept.changes in it with a full dataset.
So all rowstates will be set as done and your second update *should* never
work.

If this does not answer your question, reply?

Cor

[Lars Netzel]

You might be on to something here.. I never thought about that the second
update might never happen and that will explain why the database in not
updated I guess.. but what can I do About this?

Why "should" it not work?
/Lars

"Cor Ligthert" <no**********@p lanet.nl> skrev i meddelandet
news:O1******** ******@tk2msftn gp13.phx.gbl...

Hi Lars,

Am I right that the second update does not work and the first does.

The dataadapter has an automaticly accept.changes in it with a full dataset. So all rowstates will be set as done and your second update *should* never
work.

If this does not answer your question, reply?

Cor

[Cor Ligthert]

Hi Lars.

I think you can try to use a copy dataset to update, or you can do the
first update using dataset.getchan ges because I saw than the datarowsetting
is not changed. However I am not sure if that last is as it should be or
that it is a bug and when it is the last you can get problems in future, I
am not using that one anymore.

Have a look at this article for the working of the update, in my opinion it
describes that very well.

http://msdn.microsoft.com/library/de...pdatetopic.asp

(Did you look at the command haschanges too, it is very usefull)
if dataset.haschan ges then
update
end if

If not clear, reply?

Cor

[Lars Netzel]

Still don't get it.

I mean... My Datasets are all updated Fine... but Not the adapters, but the
don't give me any error!

/Lars

"Cor Ligthert" <no**********@p lanet.nl> skrev i meddelandet
news:Ow******** ******@TK2MSFTN GP12.phx.gbl...

Hi Lars.

I think you can try to use a copy dataset to update, or you can do the
first update using dataset.getchan ges because I saw than the datarowsetting is not changed. However I am not sure if that last is as it should be or
that it is a bug and when it is the last you can get problems in future, I
am not using that one anymore.

Have a look at this article for the working of the update, in my opinion it describes that very well.

http://msdn.microsoft.com/library/de...pdatetopic.asp
(Did you look at the command haschanges too, it is very usefull)
if dataset.haschan ges then
update
end if

If not clear, reply?

Cor

[Lars Netzel]

I have gone the booring way now... I fiuxed it wil ExecuteNOnQuery s and
wrote the Updates myself.. I have fixed my "mission" but not in the way I
wanted and I still dont' get why I can't

Fill one Dataset with one adapter... copy it and then use the DatasetCopy to
update the another adapter.

/Lars
"Lars Netzel" <[no_spam_please]la*********@qlo gic.se> skrev i meddelandet
news:%2******** *******@tk2msft ngp13.phx.gbl.. .

Still don't get it.

I mean... My Datasets are all updated Fine... but Not the adapters, but the don't give me any error!

/Lars

"Cor Ligthert" <no**********@p lanet.nl> skrev i meddelandet
news:Ow******** ******@TK2MSFTN GP12.phx.gbl...

Hi Lars.

I think you can try to use a copy dataset to update, or you can do the
first update using dataset.getchan ges because I saw than the

datarowsetting

is not changed. However I am not sure if that last is as it should be or
that it is a bug and when it is the last you can get problems in future, I am not using that one anymore.

Have a look at this article for the working of the update, in my opinion

it

describes that very well.

http://msdn.microsoft.com/library/de...pdatetopic.asp

(Did you look at the command haschanges too, it is very usefull)
if dataset.haschan ges then
update
end if

If not clear, reply?

Cor

[Lars Netzel]

When I use the HasChanges check it seems the dataset is actually not
updated.. It never goes into my IF statement although dsDestination is
originally Empty and the dsSource.Copy is not giving an error...

Private Function Importdata() As Boolean
Try
dsDestination = dsSource.Copy
If dsDestination.H asChanges Then
adpDestinationD isk.Update(dsDe stination, "Disktable" )
adpDestinationE vent.Update(dsD estination, "Eventtable ")
DestinationGrid .DataSource =
dsDestination.T ables("Eventtab le")
Return True
Else
DestinationGrid .DataSource() =
dsDestination.T ables("Eventtab le")
End If
Catch ex As Exception
MsgBox(ex.Messa ge)
Return False
End Try

/Lars
"Lars Netzel" <[no_spam_please]la*********@qlo gic.se> skrev i meddelandet
news:uV******** ******@tk2msftn gp13.phx.gbl...

I have gone the booring way now... I fiuxed it wil ExecuteNOnQuery s and
wrote the Updates myself.. I have fixed my "mission" but not in the way I
wanted and I still dont' get why I can't

Fill one Dataset with one adapter... copy it and then use the DatasetCopy to update the another adapter.

/Lars
"Lars Netzel" <[no_spam_please]la*********@qlo gic.se> skrev i meddelandet
news:%2******** *******@tk2msft ngp13.phx.gbl.. .

Still don't get it.

I mean... My Datasets are all updated Fine... but Not the adapters, but the

don't give me any error!

/Lars

"Cor Ligthert" <no**********@p lanet.nl> skrev i meddelandet
news:Ow******** ******@TK2MSFTN GP12.phx.gbl...

Hi Lars.

I think you can try to use a copy dataset to update, or you can do the first update using dataset.getchan ges because I saw than the

datarowsetting

is not changed. However I am not sure if that last is as it should be or that it is a bug and when it is the last you can get problems in future, I

am not using that one anymore.

Have a look at this article for the working of the update, in my

opinion it

describes that very well.

http://msdn.microsoft.com/library/de...pdatetopic.asp
(Did you look at the command haschanges too, it is very usefull)
if dataset.haschan ges then
update
end if

If not clear, reply?

Cor

[Cor Ligthert]

Hi Lars,

What is the code before that, where you put the changes in the dataset.
The most made mistake is that people put an dataset.acceptc hanges somewhere
before the update, what means that all updates will be set as done.

Cor