آنتریوم
پنج شنبه 20 تیر 1392, 18:56 عصر
سلام من میخوام وقتی کلیک میکنم button رو اطلاعات textbox ها به عنوان مقادیر دو پارامتر در کوئری assign بشن ولی این اتفاق نمی افته لطفا راهنماییم کنید چه جوری با کلیک کردن button اون دو مقدار رو بفرستم.
<
form>
startDate:
<asp:TextBox id="startDate" runat="server"/> 
endDate:
<asp:TextBox id="endDate" runat="server"/> <asp:Button Text="Submit" ID="Submit" runat="server" />
<
asp:ScriptManager ID="ScriptManager1" runat="server" >
</asp:ScriptManager>
<rsweb:reportviewer id="ReportViewer1" runat="server" height="500px"
width="500px" AsyncRendering="False" Font-Names="Verdana" Font-Size="8pt"
InteractiveDeviceInfos="(Collection)" WaitMessageFont-Names="Verdana"
WaitMessageFont-Size="14pt">
<LocalReport ReportPath="Views\item\Report6.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
</DataSources>
</LocalReport>
</rsweb:reportviewer>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:StorageContext %>"
ProviderName="<%$ ConnectionStrings:StorageContext.ProviderName %>"
SelectCommand="SELECT itemID, submission FROM Item WHERE (submission BETWEEN @startDate AND @endDate)">
<SelectParameters>
<asp:ControlParameter ControlID="startDate" Name="startDate"
PropertyName="Text" />
<asp:ControlParameter ControlID="endDate" Name="endDate" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
</form>
<
form>
startDate:
<asp:TextBox id="startDate" runat="server"/> 
endDate:
<asp:TextBox id="endDate" runat="server"/> <asp:Button Text="Submit" ID="Submit" runat="server" />
<
asp:ScriptManager ID="ScriptManager1" runat="server" >
</asp:ScriptManager>
<rsweb:reportviewer id="ReportViewer1" runat="server" height="500px"
width="500px" AsyncRendering="False" Font-Names="Verdana" Font-Size="8pt"
InteractiveDeviceInfos="(Collection)" WaitMessageFont-Names="Verdana"
WaitMessageFont-Size="14pt">
<LocalReport ReportPath="Views\item\Report6.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
</DataSources>
</LocalReport>
</rsweb:reportviewer>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:StorageContext %>"
ProviderName="<%$ ConnectionStrings:StorageContext.ProviderName %>"
SelectCommand="SELECT itemID, submission FROM Item WHERE (submission BETWEEN @startDate AND @endDate)">
<SelectParameters>
<asp:ControlParameter ControlID="startDate" Name="startDate"
PropertyName="Text" />
<asp:ControlParameter ControlID="endDate" Name="endDate" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
</form>