How to Create RDLC Report in .NET

   private DataTable ViewReport()
    {
        ReportBAL objBaseReport = new ReportBAL();
        objBaseReport.GVSerialNumber = txtGiftVoucher.Text.Trim();
        if (objBaseReport.GVSerialNumber == "")
            objBaseReport.GVSerialNumber = "0";
        objBaseReport.ShopId = Convert.ToInt32(ddlShop.SelectedValue);
        objBaseReport.FromDate = txtFromDate.Text;
        objBaseReport.ToDate = txtToDate.Text;

        objBaseReport.IsDateChk = true;
        DataSet ds = objDAL.ReportGiftVoucher(objBaseReport);

        return ds.Tables[0];
    }

private void BindReport()
    {
        DataTable dtComp = new DataTable();
        dtComp = objDAL.GetMasterCompany();
        if (dtComp.Rows.Count > 0)
        {
            CompanyName = Convert.ToString(dtComp.Rows[0]["CName"]);
            CompanyAddress = Convert.ToString(dtComp.Rows[0]["CAddress"]);
        }
        ReportDataSource rds = new ReportDataSource();
        rds.Name = "GiftVoucher";
        rds.Value = ViewReport();

        ReportViewer1.LocalReport.ReportPath = Server.MapPath("rptGiftVoucher.rdlc");
        ReportViewer1.LocalReport.DataSources.Clear();
        ReportViewer1.LocalReport.DataSources.Add(rds);

        ReportViewer1.LocalReport.EnableExternalImages = true;

        ReportParameter rp = new ReportParameter("CompanyName", CompanyName);
        ReportParameter rp1 = new ReportParameter("Address", CompanyAddress);
        ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp, rp1 });

        ReportViewer1.LocalReport.Refresh();
    }


    protected void btnSearch_Click(object sender, EventArgs e)
    {
        try
        {
            BindReport();
            ReportViewer1.Visible = true;
            divSearch.Style.Add("display", "none");
        }
        catch (Exception ex)
        {
            uctrlPositiveMessage.Visible = false;
            uctrlErrorMessage.Visible = true;
            ErrorMessage.Text = "Error:" + ex.Message;
        }

    }

Comments

Post a Comment

Popular posts from this blog

ASP.NET Session States in SQL Server Mode

Image
ASP.NET Session States in SQL Server Mode  1. Run --> Cmd press enter 2. on DOS screen , type "C:\Windows\Microsoft.NET\Framework64\v4.0.30319" press enter 3. type "aspnet_regsql.exe -S  Test_DB -U sa -P bajaj@123 -ssadd -sstype p" press enter Then ASP State is in Database created. Then Go to web application and define the session state mode in web.config <system.web> <sessionState mode="SQLServer" timeout="30" sqlConnectionString="Data Source=192.168.68.10; User ID=sa;Password=Test@123;" cookieless="false" /> </system.web>
Read more

How to find client's MAC Address in Asp.Net and C#.net

For Web Application using System.Runtime.InteropServices; [DllImport("Iphlpapi.dll")]     private static extern int SendARP(Int32 dest, Int32 host, ref Int64 mac, ref Int32 length);     [DllImport("Ws2_32.dll")]     private static extern Int32 inet_addr(string ip); protected void Page_Load(object sender, EventArgs e)     {         try         {             string userip = Request.UserHostAddress;             string strClientIP = Request.UserHostAddress.ToString().Trim();             Int32 ldest = inet_addr(strClientIP);             Int32 lhost = inet_addr("");             Int64 macinfo = new Int64();             Int32 len = 6;             int res = SendARP(ldest, 0, ref macinfo, ref...
Read more

Use XML Data For Save in Database

CREATE PROCEDURE [dbo].[SaveData] @MH INT, @TxTest INT, @ID INT, @CreatedBy INT, @strXML VARCHAR(MAX) AS BEGIN SET NOCOUNT ON; DECLARE @XMLDocHandle INT; DECLARE @InvestorID INT SET @ID=(SELECT Id FROM tbl_Test WHERE  ID=@ID) IF(@strXML IS NOT NULL AND @strXML<>'') BEGIN EXEC sp_xml_preparedocument @XMLDocHandle OUTPUT, @strXML CREATE TABLE #temp(ID INT,ClientID INT,InvID INT,Name VARCHAR(100),MaxAmount NVARCHAR(20),BankName NVARCHAR(500), AN VARCHAR(30),Status VARCHAR(20),CreatedDate DATETIME,CreatedBy VARCHAR(10),StartDate DATETIME) INSERT INTO #temp SELECT ID,ClientID,@InvestorID,MName,MA,BName,AN,Status,GETDATE(),@CreatedBy,GETDATE() FROM OPENXML (@XMLDocHandle, 'NewDataSet/Table1',2)  WITH( ID VARCHAR(10) 'ID', ClientID VARCHAR(10) 'ClientID', MN VARCHAR(100) 'MN', MA NVARCHAR(20) 'MA', BN NVARCHAR(500) 'BN', ANumber VAR...
Read more