public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport10 rpt = new CrystalReport10();
rpt.Site = this.Site;
return(rpt);
}
private void Form33_Load(object sender, EventArgs e)
{
con = new MySqlConnection("server=localhost;username=root;pwd=niku2912;database=canteen");
con.Open();
// cmd = new MySqlCommand("select * from purchase_new", con);
da = new MySqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
// da.Fill(ds);
cmd = new MySqlCommand("select raw_material.prod_code,raw_material.Prod_name, raw_material.prod_type, stock.total_qty from stock,raw_material where stock.prod_code=raw_material.prod_code and stock.total_qty<=5", con);
da = new MySqlDataAdapter(cmd);
da.Fill(ds);
CrystalReport10 myreport = new CrystalReport10();
myreport.SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = myreport;
crystalReportViewer1.Show();
}
