我试图在报表视图上显示数据，但它只显示一条记录 [英] i am trying to display data on a reportview but it only displays one record

问题描述

<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 &gt;=@Site AND Date_Rep &lt;=@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>

推荐答案

ConnectionStrings：ApplicationServices ％>

ProviderName = <％

ConnectionStrings:ApplicationServices %>" ProviderName="<%

ConnectionStrings：ApplicationServices.ProviderName ％>

SelectCommand = SELECT [Site_ID]，[Date_Rep]，[Activity]， [Product]，[Number]，[Time]
FROM [Letters]
WHERE Site_ID& gt; = @ Site AND Date_Rep& lt; = @ Date ORDER BY Date_Rep < span class =code-attribute>

< span class =code-attribute> DatasourceMode = DataReader

OnSelecting = SqlDataSource1_Selecting >
< SelectParameters >
< asp：参数 名称 = 网站 类型 = 字符串 / >
< asp：参数 名称 = 日期 类型 = DateTime / >
< / SelectParameters >
< / asp：SqlDataSource >
< asp：ObjectDataSource ID = ObjectDataSource1 runat = server

SelectMethod = GetData

TypeName = Securemail_Production.DataSet1TableAdapters.LettersTableAdapter

DataObjectTypeName = Securemail_Production.DataSet1 + LettersDataTable

< span class =code-attribute> OldValuesParameterFormatString = original_ {0} UpdateMethod = 更新

InsertMethod = 插入 >
< InsertParameters >
< asp：参数 名称 = Site_ID 类型 = 字符串 / >
< asp：参数 名称 = Date_Rep 类型 = DateTime / >
< asp：参数 < span class =code-attribute>名称 = 活动 类型 = 字符串 / >
< asp：参数 名称 = < span class =code-keyword> Product Type = 字符串 / >
< asp：参数 名称 = 数字 类型 = 字符串 / >
< asp：参数 名称 = 时间 类型 = 字符串 / >
< / InsertParameters >
< / asp：ObjectDataSource >
< / asp：Content >

ConnectionStrings:ApplicationServices.ProviderName %>" SelectCommand="SELECT [Site_ID], [Date_Rep], [Activity], [Product], [Number], [Time] FROM [Letters] WHERE Site_ID &gt;=@Site AND Date_Rep &lt;=@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>

这篇关于我试图在报表视图上显示数据，但它只显示一条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！