C# DataTable
-
How do I select distinct rows from a DataTable?
-
How do I select distinct rows from a DataTable?
-
How do I select distinct rows from a DataTable?
By "DataTable", do you mean a table in a database? In my opinion, there should be no identical rows (rows with identical values for ALL fields) in a database table. So please clarify your question a bit. Thanks!
-
How do I select distinct rows from a DataTable?
Assuming that you want to select specific rows from a DataTable object rather than a database table, you can use the DataTable.Select method[^]
All those who believe in psycho kinesis, raise my hand.
-
By "DataTable", do you mean a table in a database? In my opinion, there should be no identical rows (rows with identical values for ALL fields) in a database table. So please clarify your question a bit. Thanks!
By definition no real database (as opposed to using excel or similar as a datasource) will allow two identical records in all fields: The primary key must be unique. It is perfectly possible (but very annoying) to have all other fields identical between two or more records, though. Software should cope with it (as well as try to prevent it), because people will make mistakes... I think the OP is talking about using a DataTable object, though.
All those who believe in psycho kinesis, raise my hand.