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 PatilPosted Jan 12, 2011, 10:08 AM
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.