Wednesday, 29 January 2014

objectDatasource binding using storeprocedure


Here is a way of binding datasource using storeprocedure

<dx:ASPxGridView ID="ASPxGridView1" runat="server" DataSourceID="DataSource11">
    </dx:ASPxGridView>
<asp:ObjectDataSource  runat="server" TypeName="ROCE.Services.RoceProductionDataService"  SelectMethod="OverallByDimensionDepartment"
        ID="DataSource11">
       <SelectParameters>
       <data:SqlParameter Name="dimensionId" DefaultValue="1" Type="Int16"></data:SqlParameter>
       <data:SqlParameter Name="departmentId" DefaultValue="1" Type="Int16"></data:SqlParameter>
       </SelectParameters>
    </asp:ObjectDataSource>



No comments:

Post a Comment