public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
Exprpt rpt = new Exprpt();
rpt.Site = this.Site;
return(rpt);
}
private void EXP_Load(object sender, EventArgs e)
{
try
{
string s1 = PaymentMain.com;
MessageBox.Show(s1);
string q2 = "SELECT * FROM [expenses] where expensesID='" + s1 + "'";
SqlCeConnection con = new SqlCeConnection(Properties.Settings.Default.conne);
SqlCeCommand cmd11 = new SqlCeCommand();
SqlCeDataAdapter sad = new SqlCeDataAdapter();
DataSet dt = new DataSet();
con.Open();
cmd11.Connection = con;
cmd11.CommandText = q2;
sad.SelectCommand = cmd11;
sad.Fill(dt);
Exprpt ex = new Exprpt();
// inv1b2 i = new inv1b2();
ex.Database.Tables["expenses"].SetDataSource(dt.Tables[0]);
//ReportDocument crystal = new ReportDocument();
//string path = System.IO.Path.GetDirectoryName(Application.ExecutablePath);
//path = System.IO.Directory.GetParent(System.IO.Directory.GetParent(path).ToString()).ToString();
//path = System.IO.Path.Combine(path, "Exprpt.rpt");
//crystal.Load("C:\\VensarkBill\\Rest\\Exprpt.rpt");
//crystal.SetDataSource(dt);
crystalReportViewer1.ReportSource = null;
crystalReportViewer1.ReportSource = ex;
//crystalReportViewer1.Refresh();
}
catch (Exception exc1)
{
MessageBox.Show("" + exc1);
}
}
