Dear All, I am using storesprocedure to get multiple table results. how to bind the multiple result to Dataset or datatable? please anyone give me the solution ..... CREATE PROCEDURE [dbo] . [SP_GETMASTERDETAILS] AS BEGIN --Table1 - DEPARTMENT DETAILS SELECT [DeptId] , [Department_Code] , [Depart_Name] FROM EMP_DEPARTMENT_MASTER --Table2 -DESIGNATION DETAILS SELECT [DesignationID] , [DesignationName] FROM EMP_DESIGNATION_MASTER END [ Function (Name= "dbo.SP_GETMASTERDETAILS" )] [ ResultType ( typeof
Read More...