<LocalReport ReportPath="Report1.rdlc"> <DataSources> <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" /> </DataSources> </LocalReport> </rsweb:ReportViewer> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" ProviderName="<%$ ConnectionStrings:ApplicationServices.ProviderName %>" SelectCommand="SELECT [Site_ID], [Date_Rep], [Activity], [Product], [Number], [Time] FROM [Letters] WHERE Site_ID >=@Site AND Date_Rep <=@Date ORDER BY Date_Rep " DatasourceMode="DataReader" OnSelecting="SqlDataSource1_Selecting"> <SelectParameters> <asp:Parameter Name="Site" Type="String" /> <asp:Parameter Name="Date" Type="DateTime" /> </SelectParameters> </asp:SqlDataSource> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetData" TypeName="Securemail_Production.DataSet1TableAdapters.LettersTableAdapter" DataObjectTypeName="Securemail_Production.DataSet1+LettersDataTable" OldValuesParameterFormatString="original_{0}" UpdateMethod="Update" InsertMethod="Insert" > <InsertParameters> <asp:Parameter Name="Site_ID" Type="String" /> <asp:Parameter Name="Date_Rep" Type="DateTime" /> <asp:Parameter Name="Activity" Type="String" /> <asp:Parameter Name="Product" Type="String" /> <asp:Parameter Name="Number" Type="String" /> <asp:Parameter Name="Time" Type="String" /> </InsertParameters> </asp:ObjectDataSource> </asp:Content>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)