Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Configuration;
- using System.Data;
- using System.Data.SqlClient;
- using CrystalDecisions.CrystalReports.Engine;
- using CrystalDecisions.Shared;
- namespace Test1
- {
- public partial class CrystalReportSimple : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void Page_Init(object sender, EventArgs e)
- {
- ReportDocument crystalReport = new ReportDocument();
- crystalReport.Load(Server.MapPath("~/CrystalReportStandard.rpt")); // .rpt file path
- Bookings dsBookings = GetData("SELECT Bookings.BookingID, Bookings.BookingDate, CurrentProducts.ProductID, CurrentProducts.ProductName, Customer.LastName, Customer.FirstName, Bookings.NumberOfGuests" +
- " FROM Bookings INNER JOIN" +
- " CurrentProducts ON Bookings.ProductID = CurrentProducts.ProductID INNER JOIN" +
- " Customer ON Bookings.CustomerID = Customer.CustomerID");
- crystalReport.SetDataSource(dsBookings.Tables[0]); //set dataset to the report viewer
- CrystalReportViewer1.ReportSource = crystalReport;
- CrystalReportViewer1.DataBind();
- }
- private Bookings GetData(string query)
- {
- string conString = ConfigurationManager.ConnectionStrings["JProCoConnectionString"].ConnectionString;
- SqlCommand cmd = new SqlCommand(query);
- using (SqlConnection con = new SqlConnection(conString))
- {
- using (SqlDataAdapter sda = new SqlDataAdapter())
- {
- cmd.Connection = con;
- sda.SelectCommand = cmd;
- using (Bookings dsBookings = new Bookings())
- {
- sda.Fill(dsBookings, "DataTable1");
- return dsBookings;
- }
- }
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement