Dataset

[ats@jbex]

Hi there. I have a program that I am converting to VB.Net (2005). At
program start a number of "disconnected Recordsets" were created for use
throughtout the program. I have changed these for datasets and they are
populated as were the original VB6 Recordsets. In the VB6 version I could
then use the following:

rs.Filter = "Filter Clause Here"

I could then use the filtered records to e.g. fill a combobox etc and then
use the rs.Filter = "" to remove the filter.

Is there any way of doing this with a dataset in VB.Net 2005? Or will I
have to change the way I retrieve this data?

TIA

--
ats@jbex

But I learned to burn that bridge and delete
Those who compete...at a level that's obsolete
Instead I warm my hands upon the flames of the flag
As I recall our downfall
And the business that burned us all
See through the news and the views that twist reality

Rage Against The Machine - Bombtrack

 

[ats@jbex]

Hi there. I have a program that I am converting to VB.Net (2005). At
program start a number of "disconnected Recordsets" were created for use
throughtout the program. I have changed these for datasets and they are
populated as were the original VB6 Recordsets. In the VB6 version I could
then use the following:

rs.Filter = "Filter Clause Here"

I could then use the filtered records to e.g. fill a combobox etc and then
use the rs.Filter = "" to remove the filter.

Is there any way of doing this with a dataset in VB.Net 2005? Or will I
have to change the way I retrieve this data?

TIA

Ignore this I have done it by using a dataview.

--
ats@jbex

The world is my expense
The cost of my desire
Jesus blessed me with its future
And I protect it with fire

Rage Against The Machine - Sleep Now In The Fire

 

[Cor Ligthert[MVP]]

Ats,

As addition, try not to compare a recordset with a dataset. A recordset is a
kind of disconnected datatable, from which zero or more are located in a
dataset.

Cor