lothos12345
Well-known member
How do I execute sql commands against a dataset in Visual Basic.NET?
Last edited by a moderator:
DataSet
- Thread starter lothos12345
- Start date
VagabondSW
Well-known member
- Joined
- Feb 19, 2005
- Messages
- 66
You dont, as far as I know.
What you can do is assign a DataColumn.Expression to a DataTable.Select method or a DataView.RowFilter property.
What you can do is assign a DataColumn.Expression to a DataTable.Select method or a DataView.RowFilter property.
lothos12345
Well-known member
Is there away to filter out the duplicate records in the dataset in Visual Basic.NET?
Nerseus
Danner
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 thats supported. The filtering represents mostly what youd 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 wont help you get distinct rows.
-nerseus
Unfortunately, DISTINCT is not a keyword thats supported. The filtering represents mostly what youd 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 wont help you get distinct rows.
-nerseus