So say you have a dataset "ds" that has the results back from the database<BR><BR>you could then say:<BR><BR>[code language="VB.NET"]Dim dv1, dv2 as DataView<BR>dv1 = ds.Tables(0).DefaultView<BR>dv1.RowFilter = "some criteria"<BR>dv2 = ds.Tables(0).DefaultView<BR>dv2.RowFilter = "some other criteria"[/code]<BR>
I did know about RowFilter. The problem is, I don't know what to put for criteria. I want the first half of the data in one. For instance, if the ds has 10 rows, I want the first 5 rows in the first dataview and the last 5 in the second. Thanks.
Create a datatable with an AutoIncrement DataColumn. Get the Rows.Count of the datatable and split the first half into dataview 1 and the second half into dataview 2 using the AutoIncrement DataColumn for RowFilter.