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>





                    




































































                    























































                                   

0 comments:

Post a Comment