pls help with sample sp calling coding

Question

Hi all,

i have written one SP which has two paramter one is custnumber(input parameter) another one is xmloutput parameter(outputparameter).While passing custid its creating xmloutput result.To generate xmloutput i have written: FOR XML PATH('Customer'), ROOT('doc'). While running this SP from backend i am getting the correct result in xml format.

Now i want to call this sp from C#.net DAL layer return the sp result should be in Dataset(i mean there will be a method whose return type will be dataset). And while i will call this datasetet return type method from presentation layer want to display in gridview: how can i do this????pls help with sample coding....pls...