Working with ADO.NET Datasets and .NET Objects using Crystal Reports and ASP.NET 2.0

(Page 1 of 6 )

This is the third article in a series focusing on programming with Crystal Reports with ASP.NET 2.0. In this article, we will focus on working with Crystal Reports with data sources that include ADO.NET datasets and .NET objects.

---

A downloadable zip file is available for this article.

---

If you are new to Crystal report programming, I strongly suggest that you go through the following articles:

Programming Crystal Reports with ASP.NET 2.0

Working with Parameters with Crystal Reports and ASP.NET 2.0

This article uses and enhances the solution (source code) provided at the above links. 

If you are new to OOP-based database applications in Visual Basic 2005, I suggest that you go through the following article:

Implementing OOP to Develop Database-Oriented Applications using VB.NET 2005

The entire solution (source code) for this article is available as a free download (in the form of a zip). The source code in this article has been developed using Microsoft Visual Studio 2005 Professional Edition on Microsoft Windows XP Professional Edition with Microsoft SQL Server 2005 Express Edition.  I used the same version of Crystal Reports which comes with Visual Studio 2005 Professional Edition.  I didn't really test any of the code in any other tools/IDEs/servers/editions/versions. If you have any problems, please feel free to post in the discussion area.

Adding a strongly typed dataset to the project: designer

Before proceeding further, open the "SampleWebSite01" website (available as a download through the first article in this series) and add a new dataset as follows:

• Using the "Solution Explorer," right click on the project name (SampleWebSite01) and click "Add New Item."
• In the templates, select "Dataset," provide "Orders.xsd" as the "Name" and click on "Add."
  
  
  
• Click "Yes" when it asks for confirmation of placing the dataset in "App_Code" folder.
• When it opens the TableAdapter Configuration Wizard, cancel it.
• Using ToolBox, select DataTable.
  
  
  
• Place a new DataTable on the designer and rename DataTable to "Orders."
• Right click on the "Orders" datatable, go to Add -> Column and give the column name as "OrderID"
  
  
  
• Similarly, add OrderDate, CustomerID and EmployeeID.
• Using the Properties window, modify the data types of the columns respectively.

Next: Adding a strongly typed dataset to the project: designer code >>
 

More ASP.NET Articles
More By Jagadish Chaterjee

Comments On: Working with ADO.NET Datasets and .NET Objects using Crystal Reports and ASP.NET 2.0

· Hello guys,This is my third article focusing on "Programming with Crystal...    · Hi,how we can use .net objects in crystal reports.    · i have a question,how can we add .net objects and align them in the designer...    · Hi, the tutorial works fine with only one datasource and one .xsd but when I try to...   >>> Post your comment now!