Querying a Dataset

  • Thread starter Thread starter Evan Camilleri
  • Start date Start date
E

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
 
Probably by doing it manually. Joins are not supported while WHERE is
achievable through DataTable.Select and DataViews.
 
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 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 said:
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 said:
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.
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top