|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Merging DatasetsI have 2 datasets , one returned as a dataset from a webservice and one
created client side form the same stored procedure that is returned from the webservice. I then try and merge the data, but they dont seem to merge. When I return a single table , this method works fine, but im returning 3 tables and the merge isnt happening. Is there anyway to find out how I can why a merge isnt occuring, as the merge doesnt return any errors, Jon,
Be aware that the tables inside the dataset need equal table names and that the datatables in that needs to have exactly the same description as well as primary keys. Here a simple sample. http://www.vb-tips.com/dbpages.aspx?ID=edb1409d-5394-468f-a63f-de3a5d92b14a I hope this helps, Cor Show quoteHide quote "Jon Vaughan" <jonnyvaug***@hotmail.com> schreef in bericht news:CiGGg.567125$tQ4.58708@fe01.news.easynews.com... >I have 2 datasets , one returned as a dataset from a webservice and one >created client side form the same stored procedure that is returned from >the webservice. I then try and merge the data, but they dont seem to merge. > > When I return a single table , this method works fine, but im returning 3 > tables and the merge isnt happening. Is there anyway to find out how I can > why a merge isnt occuring, as the merge doesnt return any errors, > > Cor,
can you dig out that link again, as its page cannot be displayed. thanks Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:OSU4BxgxGHA.1284@TK2MSFTNGP05.phx.gbl... > Jon, > > Be aware that the tables inside the dataset need equal table names and > that the datatables in that needs to have exactly the same description as > well as primary keys. > > Here a simple sample. > http://www.vb-tips.com/dbpages.aspx?ID=edb1409d-5394-468f-a63f-de3a5d92b14a > > I hope this helps, > > Cor > > "Jon Vaughan" <jonnyvaug***@hotmail.com> schreef in bericht > news:CiGGg.567125$tQ4.58708@fe01.news.easynews.com... >>I have 2 datasets , one returned as a dataset from a webservice and one >>created client side form the same stored procedure that is returned from >>the webservice. I then try and merge the data, but they dont seem to >>merge. >> >> When I return a single table , this method works fine, but im returning 3 >> tables and the merge isnt happening. Is there anyway to find out how I >> can why a merge isnt occuring, as the merge doesnt return any errors, >> >> > > Jon,
For me it works completely http://www.vb-tips.com/dbpages.aspx?ID=edb1409d-5394-468f-a63f-de3a5d92b14a Cor Show quoteHide quote "Jon Vaughan" <jonnyvaug***@hotmail.com> schreef in bericht news:_lHGg.623590$C62.129876@fe12.news.easynews.com... > Cor, > > can you dig out that link again, as its page cannot be displayed. > > thanks > > > "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message > news:OSU4BxgxGHA.1284@TK2MSFTNGP05.phx.gbl... >> Jon, >> >> Be aware that the tables inside the dataset need equal table names and >> that the datatables in that needs to have exactly the same description as >> well as primary keys. >> >> Here a simple sample. >> http://www.vb-tips.com/dbpages.aspx?ID=edb1409d-5394-468f-a63f-de3a5d92b14a >> >> I hope this helps, >> >> Cor >> >> "Jon Vaughan" <jonnyvaug***@hotmail.com> schreef in bericht >> news:CiGGg.567125$tQ4.58708@fe01.news.easynews.com... >>>I have 2 datasets , one returned as a dataset from a webservice and one >>>created client side form the same stored procedure that is returned from >>>the webservice. I then try and merge the data, but they dont seem to >>>merge. >>> >>> When I return a single table , this method works fine, but im returning >>> 3 tables and the merge isnt happening. Is there anyway to find out how I >>> can why a merge isnt occuring, as the merge doesnt return any errors, >>> >>> >> >> > > Jon,
Here is the same link Cor posted: http://tinyurl.com/g9ogz I have had similar trouble merging datasets on occasion. If you can't get the dataset to merge, try using the merge method of the data tables rather than the dataset. Even if you only do so for debugging purposes, it will help you narrow down where the problem lies, and you can go from there. adm Jon Vaughan wrote: Show quoteHide quote > Cor, > > can you dig out that link again, as its page cannot be displayed. > > thanks > > > "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message > news:OSU4BxgxGHA.1284@TK2MSFTNGP05.phx.gbl... > > Jon, > > > > Be aware that the tables inside the dataset need equal table names and > > that the datatables in that needs to have exactly the same description as > > well as primary keys. > > > > Here a simple sample. > > http://www.vb-tips.com/dbpages.aspx?ID=edb1409d-5394-468f-a63f-de3a5d92b14a > > > > I hope this helps, > > > > Cor > > > > "Jon Vaughan" <jonnyvaug***@hotmail.com> schreef in bericht > > news:CiGGg.567125$tQ4.58708@fe01.news.easynews.com... > >>I have 2 datasets , one returned as a dataset from a webservice and one > >>created client side form the same stored procedure that is returned from > >>the webservice. I then try and merge the data, but they dont seem to > >>merge. > >> > >> When I return a single table , this method works fine, but im returning 3 > >> tables and the merge isnt happening. Is there anyway to find out how I > >> can why a merge isnt occuring, as the merge doesnt return any errors, > >> > >> > > > > great tip ad, thanks !
Show quoteHide quote "adm" <admspam@yahoo.com> wrote in message news:1156274351.174820.161960@m79g2000cwm.googlegroups.com... > Jon, > > Here is the same link Cor posted: > http://tinyurl.com/g9ogz > > I have had similar trouble merging datasets on occasion. > > If you can't get the dataset to merge, try using the merge method of > the data tables rather than the dataset. Even if you only do so for > debugging purposes, it will help you narrow down where the problem > lies, and you can go from there. > > adm > > Jon Vaughan wrote: >> Cor, >> >> can you dig out that link again, as its page cannot be displayed. >> >> thanks >> >> >> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message >> news:OSU4BxgxGHA.1284@TK2MSFTNGP05.phx.gbl... >> > Jon, >> > >> > Be aware that the tables inside the dataset need equal table names and >> > that the datatables in that needs to have exactly the same description >> > as >> > well as primary keys. >> > >> > Here a simple sample. >> > http://www.vb-tips.com/dbpages.aspx?ID=edb1409d-5394-468f-a63f-de3a5d92b14a >> > >> > I hope this helps, >> > >> > Cor >> > >> > "Jon Vaughan" <jonnyvaug***@hotmail.com> schreef in bericht >> > news:CiGGg.567125$tQ4.58708@fe01.news.easynews.com... >> >>I have 2 datasets , one returned as a dataset from a webservice and one >> >>created client side form the same stored procedure that is returned >> >>from >> >>the webservice. I then try and merge the data, but they dont seem to >> >>merge. >> >> >> >> When I return a single table , this method works fine, but im >> >> returning 3 >> >> tables and the merge isnt happening. Is there anyway to find out how I >> >> can why a merge isnt occuring, as the merge doesnt return any errors, >> >> >> >> >> > >> > > Seems merging tables is new to Framework 2
Show quoteHide quote "Jon Vaughan" <jonnyvaug***@hotmail.com> wrote in message news:I5JGg.964$zw6.406@fe02.news.easynews.com... > great tip ad, thanks ! > > "adm" <admspam@yahoo.com> wrote in message > news:1156274351.174820.161960@m79g2000cwm.googlegroups.com... >> Jon, >> >> Here is the same link Cor posted: >> http://tinyurl.com/g9ogz >> >> I have had similar trouble merging datasets on occasion. >> >> If you can't get the dataset to merge, try using the merge method of >> the data tables rather than the dataset. Even if you only do so for >> debugging purposes, it will help you narrow down where the problem >> lies, and you can go from there. >> >> adm >> >> Jon Vaughan wrote: >>> Cor, >>> >>> can you dig out that link again, as its page cannot be displayed. >>> >>> thanks >>> >>> >>> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message >>> news:OSU4BxgxGHA.1284@TK2MSFTNGP05.phx.gbl... >>> > Jon, >>> > >>> > Be aware that the tables inside the dataset need equal table names and >>> > that the datatables in that needs to have exactly the same description >>> > as >>> > well as primary keys. >>> > >>> > Here a simple sample. >>> > http://www.vb-tips.com/dbpages.aspx?ID=edb1409d-5394-468f-a63f-de3a5d92b14a >>> > >>> > I hope this helps, >>> > >>> > Cor >>> > >>> > "Jon Vaughan" <jonnyvaug***@hotmail.com> schreef in bericht >>> > news:CiGGg.567125$tQ4.58708@fe01.news.easynews.com... >>> >>I have 2 datasets , one returned as a dataset from a webservice and >>> >>one >>> >>created client side form the same stored procedure that is returned >>> >>from >>> >>the webservice. I then try and merge the data, but they dont seem to >>> >>merge. >>> >> >>> >> When I return a single table , this method works fine, but im >>> >> returning 3 >>> >> tables and the merge isnt happening. Is there anyway to find out how >>> >> I >>> >> can why a merge isnt occuring, as the merge doesnt return any errors, >>> >> >>> >> >>> > >>> > >> > > 
Other interesting topics
Conversion
DLL created in .NET cannot use? (Inno Setup) Drawing images in different shapes VB.Net Incorrect behavior of IIf in VB.NET (.NET Framework 1.1 SP1) problem in converting to C# Catch reference error how? Getting error LIBCMT.lib(tidtable.obj) : error LNK2005: __encode_pointer already defined in atlmincr database connection Change code in Debug mode Remove x number of charaters from string. Vb.net |
|||||||||||||||||||||||
