TAILIEUCHUNG - C# Crystal Reports Tutorial

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" Create DataBase "crystaldb" In the crystaldb database , create three tables. | C Crystal Reports Tutorial 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 Create DataBase crystaldb In the crystaldb database create three tables OrderMaster OrderDetails Product . The Table Structure follows OrderMaster OrderMaster_id OrderMaster_date OrderMaster_customer OrderMaster_createduser OrderDetails OrderDetails_id OrderDetails_masterid OrderDetails_productid OrderDetails_qty Product Product_id Product_name Product_price The following picture shows the relation of tables in crystaldb database OrderMaster OrderMasterjd OrderMasterjdate OrderMaster_customername OrderMaster_createduser OrderDetails Prt Jduct Productjd Product_name Product_price A 1 1 1 A OrderDetailsjd OrderDetail5_masterid OrderDetail5_productid OrderDetails_qty http SQL command for creating tables are follows CREATE TABLE dbo . OrderMaster OrderMaster_id int NOT NULL OrderMaster_date datetime NULL OrderMaster_customername varchar 50 OrderMaster_createduser varchar 50 ON PRIMARY CREATE TABLE dbo . OrderDetails OrderDetails_id int NOT NULL OrderDetails_masterid int NULL OrderDetails_productid int NULL OrderDetails_qty int NULL ON PRIMARY CREATE TABLE dbo . Product Product_id int NOT NULL Product_name varchar 50 Product_price numeric 18 0 NULL ON PRIMARY 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 0rderMa3ter_id OrderKaster_date OrderMa3ter_customernane OrderMaster_createduser 1 1 2007-01-01 a. . customerl user 2 2 2007-01-16 0. customers user 3 3 2007-02-06 0. customer user 4. . . 2 .

• Kỹ thuật lập trình
• Programming Web
• c Program
• Key terms
• programming language
• Java applications
• c# tutorial
• Web technologies
• Web programming
• Web applications
• Computer programming
• Web development technologies
• Web project management
• Web application development process
• Modeling web applications
• Testing web application
• Web services
• Web hosting
• Just Enough Web Programming with XHTML
• PHP
• and MySQL
• XHTML
• MySQL
• programming techniques
• web design
• Categories of web applications
• Characteristics of web applications
• Web application architecture
• Requirement engineering
• HTML images
• Web pages
• Phát triển ứng dụng Web
• Bài giảng Phát triển ứng dụng Web
• Môn Phát triển ứng dụng Web
• Nội dung Phát triển ứng dụng Web
• Tài liệu Phát triển ứng dụng Web
• Hyper Text Markup Language
• Markup Language
• HTML page
• Text formatting tags
• HTML links
• Creating tables
• Table attributes
• HTML forms
• HTML form elements
• HTML 5 form elments
• Adding form elements
• Cascading Style Sheets
• CSS writing option
• CSS rules