ASP.NET
  Home arrow ASP.NET arrow Working with ADO.NET Datasets and .NET Obj...
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Dedicated Servers 
Actuate Whitepapers 
Moblin 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
ASP.NET

Working with ADO.NET Datasets and .NET Objects using Crystal Reports and ASP.NET 2.0
By: Jagadish Chaterjee
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 7
    2007-08-06

    Table of Contents:
  • Working with ADO.NET Datasets and .NET Objects using Crystal Reports and ASP.NET 2.0
  • Adding a strongly typed dataset to the project: designer code
  • Binding the Crystal Report with a strongly typed dataset
  • .NET objects as data sources to Crystal Reports: adding an entity class
  • .NET objects as data sources to Crystal Reports: adding a collection class
  • .NET objects as data sources to Crystal Reports: adding and binding a crystal report

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT

    Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

    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.

    More ASP.NET Articles
    More By Jagadish Chaterjee


       · Hello guys,This is my third article focusing on "Programming with Crystal...
       · Hi,how we can use .net objects in crystal reports.
     

    ASP.NET ARTICLES

    - Enhancing PHP Via the ASP.NET AJAX Framework...
    - Enhancing PHP Programming with the ASP.NET A...
    - Classes and ASP.NET AJAX
    - Using ASP.NET AJAX
    - Building a Simple Storefront with LINQ
    - Developing a Dice Game Using ASP.NET Futures...
    - Completing an ASP.NET AJAX Server-Centric Ba...
    - Information Management for an ASP.NET AJAX S...
    - Comment and Order Management for an ASP.NET ...
    - Back-end Management Tasks for an ASP.NET AJA...
    - User Information Management for an ASP.NET A...
    - Adding Comments and Search to an ASP.NET AJA...
    - Order-Related Modules for an ASP.NET AJAX Se...
    - User and Role Management for an ASP.NET AJAX...
    - Programming an ASP.NET AJAX Server-Centric B...





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway