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