I wrote a query "select * from tbl_School".
tbl_School has 7 columns say rollno, name, standard, sub1,sub2, sub3, Score.
Now I want to fill a DatagridOne using the above written query inwhich I will display first there columns(rollno, name, standard) and I want to fill an another DatagridTwo having the rest of the columns(Sub1, Sub2, Sub3 & Score) using the same query.

The problem is I do not want to write separate query for both the datagrids but want to use a common above written query. how is it possible?