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...

Pravin Patil · Answer

Hi Rahul Download the DataAccessApplicationBloc from the following site http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f63d1f0a-9877-4a7b-88ec-0426b48df275&displaylang=en It has a class Sqlhelper which gives you a direct function ExecuteDataset. It needs the name of the sp you want to call. Just use this function to get the dataset. You can bind that dataset to the datagrid.