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

1284

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

378

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

13042

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

1806

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

273

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

2227

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

1822

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

1209

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

25548

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

2777

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

2821

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

7223

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

7377

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7034

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5623

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5045

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

3191

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3179

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

762

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

412

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General