Querying a Dataset

I have a dataset populated from a variety of sources, such as Access
Database, SQL Database and Web services.
I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE clause
etc in this dataset.

What's the best way to do it?


Evan Camilleri

Miha
Wed Nov 22 04:52:55 CST 2006

Probably by doing it manually. Joins are not supported while WHERE is
achievable through DataTable.Select and DataViews.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Evan Camilleri" <e70mt@yahoo.co.uk.nospam> wrote in message
news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>I have a dataset populated from a variety of sources, such as Access
> Database, SQL Database and Web services.
> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
> clause
> etc in this dataset.
>
> What's the best way to do it?
>
>
> Evan Camilleri
>
>
>
>

Marina
Wed Nov 22 08:02:07 CST 2006

In addition to what Miha said, if you truly needed all the power of a
relational database, you would have to put your data into a temporary access
database (or another database, I only say access because it's pretty much
always there and you don't need anything extra for it), and then use it as
your datasource and run your queries on that.

"Evan Camilleri" <e70mt@yahoo.co.uk.nospam> wrote in message
news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>I have a dataset populated from a variety of sources, such as Access
> Database, SQL Database and Web services.
> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
> clause
> etc in this dataset.
>
> What's the best way to do it?
>
>
> Evan Camilleri
>
>
>
>

Miha
Wed Nov 22 08:22:43 CST 2006

In such case I would recommend Sql Server 2005 CE

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Marina Levit [MVP]" <someone@nospam.com> wrote in message
news:OG6qp6jDHHA.3492@TK2MSFTNGP02.phx.gbl...
> In addition to what Miha said, if you truly needed all the power of a
> relational database, you would have to put your data into a temporary
> access database (or another database, I only say access because it's
> pretty much always there and you don't need anything extra for it), and
> then use it as your datasource and run your queries on that.
>
> "Evan Camilleri" <e70mt@yahoo.co.uk.nospam> wrote in message
> news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>>I have a dataset populated from a variety of sources, such as Access
>> Database, SQL Database and Web services.
>> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
>> clause
>> etc in this dataset.
>>
>> What's the best way to do it?
>>
>>
>> Evan Camilleri
>>
>>
>>
>>
>
>

Marina
Wed Nov 22 08:32:03 CST 2006

I thought CE is for mobile devices. There is no indication that this is
happening on a mobile device. In either case, I expect it requirest an
install whereas using Access does not.

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:5049E6B3-4BF8-4AA1-BFA1-990CC7D76384@microsoft.com...
> In such case I would recommend Sql Server 2005 CE
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "Marina Levit [MVP]" <someone@nospam.com> wrote in message
> news:OG6qp6jDHHA.3492@TK2MSFTNGP02.phx.gbl...
>> In addition to what Miha said, if you truly needed all the power of a
>> relational database, you would have to put your data into a temporary
>> access database (or another database, I only say access because it's
>> pretty much always there and you don't need anything extra for it), and
>> then use it as your datasource and run your queries on that.
>>
>> "Evan Camilleri" <e70mt@yahoo.co.uk.nospam> wrote in message
>> news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>>>I have a dataset populated from a variety of sources, such as Access
>>> Database, SQL Database and Web services.
>>> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
>>> clause
>>> etc in this dataset.
>>>
>>> What's the best way to do it?
>>>
>>>
>>> Evan Camilleri
>>>
>>>
>>>
>>>
>>
>>
>

Miha
Wed Nov 22 13:30:01 CST 2006

Hi Marina,

CE acronym might be misleading.
It is actually Compact Edition that you distribute as a single assembly (i
think there is only one) and not only on mobile devices. The beauty of this
approach is that you don't need any registration nor you have any dll-hell
issues (like it might happen with accesss).

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Marina Levit [MVP]" <someone@nospam.com> wrote in message
news:ekKZXLkDHHA.4808@TK2MSFTNGP03.phx.gbl...
>I thought CE is for mobile devices. There is no indication that this is
>happening on a mobile device. In either case, I expect it requirest an
>install whereas using Access does not.
>
> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
> news:5049E6B3-4BF8-4AA1-BFA1-990CC7D76384@microsoft.com...
>> In such case I would recommend Sql Server 2005 CE
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "Marina Levit [MVP]" <someone@nospam.com> wrote in message
>> news:OG6qp6jDHHA.3492@TK2MSFTNGP02.phx.gbl...
>>> In addition to what Miha said, if you truly needed all the power of a
>>> relational database, you would have to put your data into a temporary
>>> access database (or another database, I only say access because it's
>>> pretty much always there and you don't need anything extra for it), and
>>> then use it as your datasource and run your queries on that.
>>>
>>> "Evan Camilleri" <e70mt@yahoo.co.uk.nospam> wrote in message
>>> news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>>>>I have a dataset populated from a variety of sources, such as Access
>>>> Database, SQL Database and Web services.
>>>> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
>>>> clause
>>>> etc in this dataset.
>>>>
>>>> What's the best way to do it?
>>>>
>>>>
>>>> Evan Camilleri
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>
>

William
Wed Nov 22 14:28:09 CST 2006

Ah, it is. But the SQL Server 2005 Compact Edition is designed to ALSO work
on Windows Forms applications. I wrote an EBook about this new version. See
www.hitchhikerguides.net FMI. It's an ideal platform for single-user
applications that need a fast, light DBMS that also supports Merge
replication.

--
____________________________________
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.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
-----------------------------------------------------------------------------------------------------------------------

"Marina Levit [MVP]" <someone@nospam.com> wrote in message
news:ekKZXLkDHHA.4808@TK2MSFTNGP03.phx.gbl...
>I thought CE is for mobile devices. There is no indication that this is
>happening on a mobile device. In either case, I expect it requirest an
>install whereas using Access does not.
>
> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
> news:5049E6B3-4BF8-4AA1-BFA1-990CC7D76384@microsoft.com...
>> In such case I would recommend Sql Server 2005 CE
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "Marina Levit [MVP]" <someone@nospam.com> wrote in message
>> news:OG6qp6jDHHA.3492@TK2MSFTNGP02.phx.gbl...
>>> In addition to what Miha said, if you truly needed all the power of a
>>> relational database, you would have to put your data into a temporary
>>> access database (or another database, I only say access because it's
>>> pretty much always there and you don't need anything extra for it), and
>>> then use it as your datasource and run your queries on that.
>>>
>>> "Evan Camilleri" <e70mt@yahoo.co.uk.nospam> wrote in message
>>> news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>>>>I have a dataset populated from a variety of sources, such as Access
>>>> Database, SQL Database and Web services.
>>>> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
>>>> clause
>>>> etc in this dataset.
>>>>
>>>> What's the best way to do it?
>>>>
>>>>
>>>> Evan Camilleri
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>
>

Evan
Wed Nov 22 16:40:48 CST 2006

It will be part of a web application. I do not know what's best:
1: dump data back to a database and do a query
..or..
2: build something custom made.

In any case if many users are accessing the system then both may be slow!

I assume that what I need is something like Access does. There are tables
which are inside Access, tables that are linked from another Access database
or Excel or CSV or ODBC or whatever.


Evan


"Marina Levit [MVP]" <someone@nospam.com> wrote in message
news:ekKZXLkDHHA.4808@TK2MSFTNGP03.phx.gbl...
>I thought CE is for mobile devices. There is no indication that this is
>happening on a mobile device. In either case, I expect it requirest an
>install whereas using Access does not.
>
> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
> news:5049E6B3-4BF8-4AA1-BFA1-990CC7D76384@microsoft.com...
>> In such case I would recommend Sql Server 2005 CE
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "Marina Levit [MVP]" <someone@nospam.com> wrote in message
>> news:OG6qp6jDHHA.3492@TK2MSFTNGP02.phx.gbl...
>>> In addition to what Miha said, if you truly needed all the power of a
>>> relational database, you would have to put your data into a temporary
>>> access database (or another database, I only say access because it's
>>> pretty much always there and you don't need anything extra for it), and
>>> then use it as your datasource and run your queries on that.
>>>
>>> "Evan Camilleri" <e70mt@yahoo.co.uk.nospam> wrote in message
>>> news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>>>>I have a dataset populated from a variety of sources, such as Access
>>>> Database, SQL Database and Web services.
>>>> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
>>>> clause
>>>> etc in this dataset.
>>>>
>>>> What's the best way to do it?
>>>>
>>>>
>>>> Evan Camilleri
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>
>

William
Wed Nov 22 17:19:33 CST 2006

While the SQLCe engine can work with a web page, it's not really designed to
do so. MS tends to discourage (well, not encourage) it's use in these
architectures. I expect you're looking at a reload scenario.

--
____________________________________
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.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
-----------------------------------------------------------------------------------------------------------------------

"Evan Camilleri" <evan@holisticrd.com.nospam> wrote in message
news:uOBnCdoDHHA.3836@TK2MSFTNGP02.phx.gbl...
> It will be part of a web application. I do not know what's best:
> 1: dump data back to a database and do a query
> ..or..
> 2: build something custom made.
>
> In any case if many users are accessing the system then both may be slow!
>
> I assume that what I need is something like Access does. There are tables
> which are inside Access, tables that are linked from another Access
> database or Excel or CSV or ODBC or whatever.
>
>
> Evan
>
>
> "Marina Levit [MVP]" <someone@nospam.com> wrote in message
> news:ekKZXLkDHHA.4808@TK2MSFTNGP03.phx.gbl...
>>I thought CE is for mobile devices. There is no indication that this is
>>happening on a mobile device. In either case, I expect it requirest an
>>install whereas using Access does not.
>>
>> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
>> news:5049E6B3-4BF8-4AA1-BFA1-990CC7D76384@microsoft.com...
>>> In such case I would recommend Sql Server 2005 CE
>>>
>>> --
>>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>>> RightHand .NET consulting & development www.rthand.com
>>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>>
>>> "Marina Levit [MVP]" <someone@nospam.com> wrote in message
>>> news:OG6qp6jDHHA.3492@TK2MSFTNGP02.phx.gbl...
>>>> In addition to what Miha said, if you truly needed all the power of a
>>>> relational database, you would have to put your data into a temporary
>>>> access database (or another database, I only say access because it's
>>>> pretty much always there and you don't need anything extra for it), and
>>>> then use it as your datasource and run your queries on that.
>>>>
>>>> "Evan Camilleri" <e70mt@yahoo.co.uk.nospam> wrote in message
>>>> news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>>>>>I have a dataset populated from a variety of sources, such as Access
>>>>> Database, SQL Database and Web services.
>>>>> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
>>>>> clause
>>>>> etc in this dataset.
>>>>>
>>>>> What's the best way to do it?
>>>>>
>>>>>
>>>>> Evan Camilleri
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
>

Cor
Thu Nov 23 00:11:01 CST 2006

Marina,

You should more read the messages of Bill, beside his book he is endless
telling that the CE version is the best for this kind of things. (I have not
any problem with both of these messages in the way Bill does it).

:-)

Cor

"Marina Levit [MVP]" <someone@nospam.com> schreef in bericht
news:ekKZXLkDHHA.4808@TK2MSFTNGP03.phx.gbl...
>I thought CE is for mobile devices. There is no indication that this is
>happening on a mobile device. In either case, I expect it requirest an
>install whereas using Access does not.
>
> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
> news:5049E6B3-4BF8-4AA1-BFA1-990CC7D76384@microsoft.com...
>> In such case I would recommend Sql Server 2005 CE
>>
>> --
>> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
>> RightHand .NET consulting & development www.rthand.com
>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>>
>> "Marina Levit [MVP]" <someone@nospam.com> wrote in message
>> news:OG6qp6jDHHA.3492@TK2MSFTNGP02.phx.gbl...
>>> In addition to what Miha said, if you truly needed all the power of a
>>> relational database, you would have to put your data into a temporary
>>> access database (or another database, I only say access because it's
>>> pretty much always there and you don't need anything extra for it), and
>>> then use it as your datasource and run your queries on that.
>>>
>>> "Evan Camilleri" <e70mt@yahoo.co.uk.nospam> wrote in message
>>> news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>>>>I have a dataset populated from a variety of sources, such as Access
>>>> Database, SQL Database and Web services.
>>>> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
>>>> clause
>>>> etc in this dataset.
>>>>
>>>> What's the best way to do it?
>>>>
>>>>
>>>> Evan Camilleri
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>
>

Cor
Thu Nov 23 00:12:39 CST 2006

Evan,

You don't have the select, but by common VB or Csharp commands, you can do
so much that you don't need that.

See here a way to fake a join.
http://www.vb-tips.com/dbPages.aspx?ID=5fd5a8cf-54dc-4946-a193-8a9529b2b38b

Cor

"Evan Camilleri" <e70mt@yahoo.co.uk.nospam> schreef in bericht
news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>I have a dataset populated from a variety of sources, such as Access
> Database, SQL Database and Web services.
> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
> clause
> etc in this dataset.
>
> What's the best way to do it?
>
>
> Evan Camilleri
>
>
>
>

Adrian
Mon Dec 04 07:26:12 CST 2006

Evan,

Try www.queryadataset.com. It includes SQL SELECT that supports your needs
below.

Ad.

"Evan Camilleri" <e70mt@yahoo.co.uk.nospam> wrote in message
news:esJWVehDHHA.348@TK2MSFTNGP06.phx.gbl...
>I have a dataset populated from a variety of sources, such as Access
> Database, SQL Database and Web services.
> I would like to do a query including JOINs, LEFT, RIGHT, INNER, WHERE
> clause
> etc in this dataset.
>
> What's the best way to do it?
>
>
> Evan Camilleri
>
>
>
>