DataSet

[lothos12345]

How do I execute sql commands against a dataset in Visual Basic.NET? Edited November 1, 2005 by lothos12345

[VagabondSW]

You don't, as far as I know.

 

What you can do is assign a DataColumn.Expression to a DataTable.Select method or a DataView.RowFilter property.

[lothos12345]

Is there away to filter out the duplicate records in the dataset in Visual Basic.NET?

[Nerseus]

You can use the .Select method of the DataTable to get a list of matching rows (a filter). You can also use a DataView to do the same filtering.

 

Unfortunately, DISTINCT is not a keyword that's supported. The filtering represents mostly what you'd see in a WHERE clause such as "col = 'abc' and col2 < 5". Any type of duplicate matching will have to be done manually.

 

You can also use the .Compute method to get aggregates, like MIN, MAX, SUM, etc. but that still won't help you get distinct rows.

 

-nerseus

[FZelle]

On planetsourcecode.com is a library called Sql-Engine.

 

Thisone can perform SQL-queries on a dataset and returns a DataTable.