Click here to Skip to main content
15,860,844 members
Articles / Web Development / ASP.NET
Article

Crystal Report database connection in ASP.NET

Rate me:
Please Sign up or sign in to vote.
4.14/5 (6 votes)
18 Jan 2008CPOL1 min read 63.8K   23   6
In this article I am going to discuss how to use UDL file with Crystal Report to connect particular database.

Introduction

In this article I am going to discuss how to use UDL file with Crystal Report to connect particular database.

Using the code

What is UDL?<o:p>

Universal Data Link files (.udl files) can be used to store information of connection string. So it works as a common user interface for specifying connection attributes.

How to create a UDL file? <o:p>

  1. Open a notepad and save it using .udl extension. (Note: don not write anything in that notepad). Udl_Creation.JPG 2. Now it displays with small computer icon.

udl_file.JPG
3. Now you should configure your udl file. Double click on the udl file. Now it displays as follows.
udl_Configure_1.JPG
4. Now select a provider. In this example I have used Microsoft SQL server 2005 express edition. So I need to use Microsoft OLE DB Provider for SQL Server as the provider. Then click Next button or Connection tab.

5.Then you will have to select details which related to SQL server. After providing those data, you can check connection is success or not by clicking Test Connection button.

Now you can add crystal report to your project. Select OLE DB (ADO) as the data source of the project.

Report_Configure1.JPG

Then display OLE DB (ADO) dialog box. Now select use data link file and browse your .udl file.

Report_Configure2.JPG

After configuring data source, you can add SQL query to crystal report by double clicking AddCommand. Now you can SQL query here.

Report_Configure3.JPG

After creating crystal report you can display it on your asp.net web page. For that you have to add CrystalReportViwer control to your web page. After then write following code in the code behind page.

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;



using CrystalDecisions.CrystalReports.Engine;

using CrystalDecisions.Shared;

using CrystalDecisions.Web;

public partial class _Default : System.Web.UI.Page 

{

    ReportDocument doc;

    protected void Page_Load(object sender, EventArgs e)

    {

        try
        {
            doc = new ReportDocument();

            doc.Load(MapPath("~\\TestReport.rpt"));



            CrystalReportViewer1.ReportSource = doc;

        }

        catch (Exception ex)

        {

            Label1.Text = ex.Message;

        }

    }

}

Points of Interest

You can use the for windows based application development also.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
Sri Lanka Sri Lanka
I'm working with SAP and Microsoft Technologies such as C#, MS SQL server, ASP.NET, ASP.NET MVC, WebAPI.

Comments and Discussions

 
QuestionAbout the Crystal Report Pin
Member 1084400725-May-14 23:56
Member 1084400725-May-14 23:56 
GeneralMy vote of 3 Pin
bhagyap29-Dec-11 0:04
bhagyap29-Dec-11 0:04 
GeneralMy vote of 5 Pin
Pankaja Kanavi28-Dec-11 21:10
Pankaja Kanavi28-Dec-11 21:10 
GeneralThanks Pin
tkjbbs11-Jun-08 13:15
tkjbbs11-Jun-08 13:15 
GeneralMS SQL SERVER EXPRESS 2005 AND CRYSTAL REPORT Pin
AP Software14-Feb-08 8:36
AP Software14-Feb-08 8:36 
GeneralRe: MS SQL SERVER EXPRESS 2005 AND CRYSTAL REPORT Pin
Manjula Wickramathunga14-Feb-08 16:54
Manjula Wickramathunga14-Feb-08 16:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.