public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
cust_bill rpt = new cust_bill();
rpt.Site = this.Site;
return(rpt);
}
private void Bill_Load(object sender, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection();
SqlCommand sqlcomm = new SqlCommand();
try
{
cust_bill bill_report = new cust_bill();
sqlcon = new SqlConnection(ConfigurationSettings.AppSettings["photostudioConnectionString"].ToString());
sqlcon.Open();
sqlcomm = new SqlCommand();
sqlcomm.Connection = sqlcon;
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.CommandText = "bill_cust_select";
sqlcomm.Parameters.Add(new SqlParameter("@cust_id", SqlDbType.Int, 4));
sqlcomm.Parameters["@cust_id"].Value = c_id;
SqlDataAdapter dta = new SqlDataAdapter(sqlcomm);
DataSet ds = new DataSet();
dta.Fill(ds, "table");
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("No data Found", "CrystalReportWithOracle");
return;
}
bill_report.SetDataSource(ds.Tables[0]);
cust_bill_crystalreportviewer.ReportSource = bill_report;
sqlcon.Close();
sqlcon.Dispose();
}
catch
{
}
finally
{
sqlcon.Close();
sqlcon.Dispose();
}
}
