This should help you out:
ADO.NET Overview[
^]
Using Dataset in ADO.NET[
^]
Using ADO.NET, get data in a dataset. Once you have dataset, pass that back to UI layer where you can bind it to the datagrid.
While fetching data, instead of query you would be using stored procedure. For that, commandType would be SP.
Try!