.net lover: crystal report and importing database

How to create Crystal report and database importing techniques?

Here i am going to define Step by step How to create Crystal report and database importing techniques?

Step 1). At first we need to download crystal report.

You can download a crystal Report from here.

Step 2). Here we learn how to create database?

Let say i want to create database named Pankaj.

then we need to open sql server what ever version you have installed in your System.

Now we will have to connect SQL Server now your system is connected with SQL Server.

Now you will see Object Explorer window

There is an option 'Database' then you have to right click on database and select the submenu New Database. A new window will open here you need to Give The name of Database. Then click on OK Button. A New a database has been created with the name Pankaj. Now you have to click on Object explorer window there is your database pankaj is available there is an option in Pankaj database named Table you need to right click on Table option and select New Table from Sub menu.

Database name Pankaj
Table name1—project1

Again you have to Put Up the value of your Databse item/attribute. and write like this.

Field name--Emp_Id-nvarchar(50)(Primary key)
P_Name-varchar(50)

If you want to create more than one Table in your database then you have to do the same step during creating new Table.

Again you have to Put Up the value of your Databse item/attribute. and write like this.

Table name2—project2
Field name--F_Namevarchar(50)
Department--varchar(50)
Emp_Id--nvarchar(50)(foreign key)

Now create a foreignkey for your database here we exploring this step using Screen Shot.