Tuesday 28 October 2014

How To Pass Particular (Control ID) Parameter to .rdlc Report or Crystal Report Using Asp.Net

 Particular(Control ID) Pass Parameter to .rdlc Report


How To Pass Parameters  To  .rdlc Reports  Using Asp.Net  C#  .  Sql Query Using (Where Condition)  Partiular Field Select.

DEMO


HTML CODING


<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div> 
             
        <asp:TextBox ID="TextBox1" runat="server">3</asp:TextBox>       
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>       
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt">
            <LocalReport ReportPath="Report.rdlc">
                <DataSources>
                    <rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet1" />
                </DataSources>
            </LocalReport>
        </rsweb:ReportViewer>
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" 
SelectMethod="GetData" 
TypeName="DatabaseDataSetTableAdapters.billTableAdapter">
            <InsertParameters>
                <asp:Parameter Name="billno" Type="String" />
                <asp:Parameter Name="name" Type="String" />
                <asp:Parameter Name="amount" Type="String" />
            </InsertParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="billno" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:ObjectDataSource>       
   
    </div>
    </form>
</body>

</html>





                    




































































                    























































                                   

How To Pass Parameter to .rdlc Report or Crystal Report Using Asp.Net

         Pass Parameter to .rdlc Report


How To Pass Parameters  To  .rdlc Reports  Using Asp.Net  C#  .  Sql Query Using  All Field Select.


                       DEMO

            HTML CODING



<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
      
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
       
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" 
Font-Names="Verdana" Font-Size="8pt" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt">
            <LocalReport ReportPath="Report.rdlc">
                <DataSources>
                  <rsweb:ReportDataSource 
DataSourceId="ObjectDataSource1" Name="DataSet1" />
                </DataSources>
            </LocalReport>
        </rsweb:ReportViewer>
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
 InsertMethod="Insert"
 OldValuesParameterFormatString="original_{0}"
 SelectMethod="GetData" 
TypeName="DatabaseDataSetTableAdapters.billTableAdapter">
            <InsertParameters>
                <asp:Parameter Name="billno" Type="String" />
                <asp:Parameter Name="name" Type="String" />
                <asp:Parameter Name="amount" Type="String" />
            </InsertParameters>
         
        </asp:ObjectDataSource>
   
    </div>
    </form>
</body>


</html>





          














































































                   


















     








                                                                               






                             i think useful this post.