I'm having problem in displaying my crystal report. Whenever I run my program, details are not showing. I already created the layout(.rpt) and my webform which only contains the CrystalReportViewer. Details are connected to my SQL Database 2008.
Here's my code behind. What am I missing?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data;
namespace Demo
{
public partial class WebForm1 : System.Web.UI.Page
{
public string GetConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(GetConnectionString());
SqlDataAdapter ad = new SqlDataAdapter("Select city_code, city_cd from cities", GetConnectionString());
DataTable _dt = new DataTable();
ad.Fill(_dt);
CrystalReport3 rpt = new CrystalReport3();
rpt.SetDataSource(_dt);
CrystalReportViewer1.ReportSource = rpt;
CrystalReportViewer1.DataBind();
}
}