Querying a Dataset

[Evan Camilleri]

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 Markic [MVP C#]]

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

 

[Marina Levit [MVP]]

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.

 

[Miha Markic [MVP C#]]

In such case I would recommend Sql Server 2005 CE

 

[Marina Levit [MVP]]

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.

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/

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.

 

[Miha Markic [MVP C#]]

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/

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.

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/

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.

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 \(Bill\) Vaughn]

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)
-----------------------------------------------------------------------------------------------------------------------

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.

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/

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.

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 Camilleri]

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

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.

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/

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.

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 \(Bill\) Vaughn]

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)
-----------------------------------------------------------------------------------------------------------------------

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

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.

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/

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.

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 Ligthert [MVP]]

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

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.

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/

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.

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 Ligthert [MVP]]

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

 

[Adrian Moore]

Evan,

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

Ad.