"Imran Aziz" <imran@tb2.net> wrote in message
news:eQm0mfIPGHA.2628@TK2MSFTNGP15.phx.gbl...
> Hello All,
> I have a dataset that I populate using a SQL Server database, and the
> second one that I populate using a mySQL Server database, I need to
> combine the results in memory and then sort them, how do I go about doing
> that ? This is a search query, so I do not want to create another temp
> table to do this, any idea's please.
>
> Imran.
>

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:eFXqMRJPGHA.1532@TK2MSFTNGP12.phx.gbl...
> There are a couple of options here. First, you could link the MySQL
> database to SQL Server (see "linked servers" in Books Online) and do the
> JOIN on the SQL Server when you fetch the data. Next, you could try to do
> it in place on the client. This is tougher as ADO.NET does not include a
> JOIN engine. I might try to Merge the two DataSet objects together and go
> from there...
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "Imran Aziz" <imran@tb2.net> wrote in message
> news:eQm0mfIPGHA.2628@TK2MSFTNGP15.phx.gbl...
>> Hello All,
>> I have a dataset that I populate using a SQL Server database, and the
>> second one that I populate using a mySQL Server database, I need to
>> combine the results in memory and then sort them, how do I go about doing
>> that ? This is a search query, so I do not want to create another temp
>> table to do this, any idea's please.
>>
>> Imran.
>>
>
>

"Imran Aziz" <imran@tb2.net> wrote in message
news:uIpbFFSPGHA.3864@TK2MSFTNGP10.phx.gbl...
> Thanks for your response William. I will have a look at "linked Servers"
> as you mentioned. I have tried the Merge method of DataSet but keep on
> getting this error.
>
> [System.Data.DataException] = {"<target>.nID and <source>.nID have
> conflicting properties: DataType property mismatch."}
>
> Any idea as to why this is happening, my piece of code is as under.
>
> DataSet dsMT = new DataSet();
> dsMT = GetSearchEntries(sSearch, intGroupID);
> ds.EnforceConstraints = false;
> ds.Merge(dsMT, true, MissingSchemaAction.AddWithKey);
>
> where both the datasets have the same Schema.
>
> Any suggestions please how to sort this issue out.
>
> Imran.
>
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> news:eFXqMRJPGHA.1532@TK2MSFTNGP12.phx.gbl...
>> There are a couple of options here. First, you could link the MySQL
>> database to SQL Server (see "linked servers" in Books Online) and do the
>> JOIN on the SQL Server when you fetch the data. Next, you could try to do
>> it in place on the client. This is tougher as ADO.NET does not include a
>> JOIN engine. I might try to Merge the two DataSet objects together and go
>> from there...
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>>
>> "Imran Aziz" <imran@tb2.net> wrote in message
>> news:eQm0mfIPGHA.2628@TK2MSFTNGP15.phx.gbl...
>>> Hello All,
>>> I have a dataset that I populate using a SQL Server database, and the
>>> second one that I populate using a mySQL Server database, I need to
>>> combine the results in memory and then sort them, how do I go about
>>> doing that ? This is a search query, so I do not want to create another
>>> temp table to do this, any idea's please.
>>>
>>> Imran.
>>>
>>
>>
>
>

> Hello All,
> I have a dataset that I populate using a SQL Server database, and the
> second one that I populate using a mySQL Server database, I need to
> combine the results in memory and then sort them, how do I go about doing
> that ? This is a search query, so I do not want to create another temp
> table to do this, any idea's please.
>
> Imran.
>