dataset question

Hi

I am a newbie in vb.net 2005. Is it possible to do a Group By in a dataset?

thanks
E.

Jan 21 '07 #1

1281

Eric,
This is more of a question for the ado newsgroup:
microsoft.public.dotnet.framework.adonet. But to answer your question, the
following whitepaper may help you out:

HOW TO: Implement a DataSet GROUP BY Helper Class in Visual Basic .NET
http://support.microsoft.com/default...b;en-us;325685

--
Thanks,
Page Brooks, MCSD
www.explosivedog.com

"Eric Effer" <be****@gmail.comwrote in message
news:OG**************@TK2MSFTNGP06.phx.gbl...

Hi

I am a newbie in vb.net 2005. Is it possible to do a Group By in a
dataset?

thanks
E.

Jan 22 '07 #2

Eliyahu Goldin

No, you can do just basic filtering in Select method. You need to go to the
database for anything more sophisticated. Of cause, you can always do
whatever you wish programmatically, you may choose this if another database
query would be too expensive.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
"Eric Effer" <be****@gmail.comwrote in message
news:OG**************@TK2MSFTNGP06.phx.gbl...

Hi

I am a newbie in vb.net 2005. Is it possible to do a Group By in a

dataset?

>
thanks
E.

Jan 22 '07 #3

Similar topics

Question about a dataset

by: Simon Harvey | last post by:

Hi everyone, I was wondering if it is possible, to use SQL to return more than one table at a time into a dataset. I only know the basics of SQL and so I'm not sure if I'm just asking a stupid...

.NET Framework

Design question --- Return a DataSet?

by: JS | last post by:

I'm trying to create a data layer and having problems returning a DataSet from my code that's in a class module. Please forgive me. I'm new to C# (VB'er). I decided to create my data layer in...

C# / C Sharp

Simple SQL/DataSet question

by: Simon Harvey | last post by:

Hi everyone, I was wondering if it is possible, to use SQL to return more than one table at a time into a dataset. I only know the basics of SQL and so I'm not sure if I'm just asking a stupid...

C# / C Sharp

DataSet Question

by: Mike | last post by:

Hi, I am trying to solve a problem with a DataSet issue I am having. In my app the user selects certain options and based on those options it goes out to the db to get data based on those...

C# / C Sharp

Q: send dataset as a parameter

by: JIM.H. | last post by:

Hello, Can I send a dataset as a parameter into stored procedure and import data to a table in the stored procedure? Thanks, Jim.

ASP.NET

Dataset Declaration again ... CJ listening? Anyone else

by: Jeff Brown | last post by:

OK i have came to the conclusion that since this app will be run on multiple computers that loading a complete database and then updating on exit is a moot point. I have tried several ideas...

Visual Basic .NET

No of Dataset to Adapters

by: markerussell | last post by:

I have a question, in that if i have an application is it better to have one dataset per data adapter, ie daCustomerTable -> dsCustomer, daOrders -> dsOrders etc. or to say have a couple of dataset...

Visual Basic .NET

Passing a Dataset to a webservice

by: Arne | last post by:

How do I pass a dataset to a webservices? I need to submit a shoppingcart from a pocket PC to a webservice. What is the right datatype? II have tried dataset as a datatype, but I can't get it to...

.NET Framework

How to add a row to an SQL Dataset

by: JT | last post by:

I have an SQL database with one table in it. I want to load the table into a DataSet, add new records to the DataSet, then commit the changes back to the database. Using C#.NET, the following...

C# / C Sharp

How can I make this more efficient? (combining DataSet results with the results of a DB lookup.)

by: Ken Fine | last post by:

This is a question that someone familiar with ASP.NET and ADO.NET DataSets and DataTables should be able to answer fairly easily. The basic question is how I can efficiently match data from one...

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server