1. Open Project solution
2. Create a Table and Insert Data's into a Table.
3. Example
4. Coding added to place of Web.config
<appSettings>
<add key="ConnString" value="Data Source=SAMITECHPC1\SQL2008R2;Initial Catalog=test;Integrated Security=True" />
<add key="CrystalImageCleaner-AutoStart" value="true" />
<add key="CrystalImageCleaner-Sleep" value="60000" />
<add key="CrystalImageCleaner-Age" value="120000" />
</appSettings>
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=SAMITECHPC1\SQL2008R2;Initial Catalog=test;Integrated Security=True"/>
</connectionStrings>
5. Example:
6.Solution Name To Right Click --> Add New Item --> Select DataSet and Add Button is Clicked
7. Now Open DataSet1.xsd page and Right Click --> Add --> DataTable
and now open DataTable again Add a column in DataTable
and Click a Properties to change a Datatype( same as Database column name and datatype) and click a
Save to DataSet1.xsd
8. Now Add a Crystal Report into Solution.
9. Now You Add a New Class into Solution
Coding:
public class Class1
{
//Connection Strings
string strConnection = System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
//DataSet1 is .xsd file name
public DataSet1 GetValues()
{
try
{
DataSet1 alldatas = null;
using (SqlConnection connection = new SqlConnection(strConnection))
{
using (SqlCommand command = connection.CreateCommand())
{
alldatas = new DataSet1();
// best practies ingore inline query
command.CommandText = "SELECT * FROM empdetails;";
command.CommandType = System.Data.CommandType.Text;
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
//DataTable1 is Datatable name of DataSet1
adapter.Fill(alldatas.DataTable1);
}
}
}
return alldatas;
}
catch (Exception ex)
{
throw ex;
}
}
}
10. Now You add a New Form into Solution
11. Now You Add a Crystal Report Viewer From Tool Box
12. To Open a PrintScreen.cs File and type a Following Coding
In Page Load Event
//Class1 is a file name of .cs
Class1 ps = new Class1();
ReportDocument report = new ReportDocument();
report.Load(Server.MapPath("CrystalReport.rpt"));
//DataSet is a .xsd File Name
DataSet1 Result = ps.GetAll();
if (Result != null)
{
report.SetDataSource(Result);
CrystalReportViewer1.ReportSource = report;
}
13. Now to Open a Crystal Report
Click Field Explorer of DataBase Fields --> right click --> DataBase Expert clicked
14. DataBase Expert Window is Opened and Now Click Project Data --> ADO.NET DataSets --> Select DataTable1 to Moved To another Box.
15. Now Click Field Explorer of Database Fields all DataTable1 Fileds are here.
16. And open a Page Print Click Event
17. To click Print to Type a Coding
protected void butPrint_Click(object sender, EventArgs e)
{
Response.Redirect("PrintScreen.aspx");
}
18.Output:
