Filter Datagrid?

[Jason .]

I have 3 datagrids on my page that uses data from one stored proc. The
data is sorted by category (3 categories). Can I use the data from
mystored proc to fill the datagrid without having to create three trips
to the server to load the data?

in pseudocode:

If category = 1 then load that data into grid 1

If category = 2 then load that data into grid 2

If category = 3 then load that data into grid 3

Thanks.

 

[Jason .]

I don't know if this is the best way to go about it but I was able to
figure it out...

// Create dataviews to hold the table to filter
DataView dv1 = new DataView(ds.Tables["Results"]);
DataView dv2 = new DataView(ds.Tables["Results"]);
DataView dv3 = new DataView(ds.Tables["Results"]);
DataView dv4 = new DataView(ds.Tables["Results"]);
DataView dv5 = new DataView(ds.Tables["Results"]);

dv1.RowFilter = "SortId = 0";
dv2.RowFilter = "SortId = 1";
dv3.RowFilter = "SortId = 2";
dv4.RowFilter = "SortId = 3";
dv5.RowFilter = "SortId = 5";