Net-informations.com
SiteMap  | About    

C# Crystal Reports sample databse



For generating Crystal Reports from C# , we need to connect a database and some tables with data. In the following section you can see how to create a sample Database and Tables and the data for running of the following Crystal Reports - C# Tutorial . All examples in the CSharp Crystal Reports Tutorial is based on the following database .

First we have to create a database named it as "crystaldb"

In the crystaldb database , create three tables

  1. OrderMaster
  2. OrderDetails
  3. Product
The Table Structure follows :

OrderMaster

  1. OrderMaster_id
  2. OrderMaster_date
  3. OrderMaster_customer
  4. OrderMaster_createduser

OrderDetails

  1. OrderDetails_id
  2. OrderDetails_masterid
  3. OrderDetails_productid
  4. OrderDetails_qty

Product

  1. Product_id
  2. Product_name
  3. Product_price

The following picture shows the relation of tables in crystaldb database :

csharp-crystal-report-table-relations

SQL command for creating tables are follows :

Enter some data to the tables :

From the following pictures you can see some data in the table for C# - Crystal Reports tutorial

Order Master Table Data

csharp-crystal-report-ordermaster-data

Order Details Table Data

csharp-crystal-report-orderdetails-data

Product Table Data

csharp-crystal-report-product-data








net-informations.com (C) 2019    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.