public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            CrystalReportProduct rpt = new CrystalReportProduct();

            rpt.Site = this.Site;
            return(rpt);
        }
示例#2
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         MySql.Data.MySqlClient.MySqlConnection mysqlconnect = new MySql.Data.MySqlClient.MySqlConnection("Server=localhost ; User Id=root; Password= ;Database=algdb(2.0)");
         string query = "SELECT * FROM product_print WHERE category_name = 'Gasoline Engine Oil'";
         mysqlconnect.Open();
         MySqlCommand     cmd = new MySqlCommand(query, dbcon.mysqlconnect);
         MySqlDataAdapter adp = new MySqlDataAdapter();
         DataSet          dt  = new DataSet();
         adp.SelectCommand = cmd;
         adp.Fill(dt, "dsProduct");
         CrystalReportProduct reporting = new CrystalReportProduct();
         reporting.SetDataSource(dt);
         frmReports frmreports = new frmReports();
         frmreports.crystalReportViewer.ReportSource = reporting;
         frmreports.crystalReportViewer.Refresh();
         cmd.Dispose(); adp.Dispose(); dt.Dispose(); dbcon.mysqlconnect.Close();
         frmreports.ShowDialog();
     }
     catch (Exception)
     {
         throw;
     }
 }
示例#3
0
        public void printproduct(string search, string searchBy)
        {
            try
            {
                MySql.Data.MySqlClient.MySqlConnection mysqlconnect = new MySql.Data.MySqlClient.MySqlConnection("Server=localhost ; User Id=root; Password= ;Database=algdb(2.0)");
                //string query = $"SELECT * FROM product_print WHERE category_name = 'Gasoline Engine Oil'";
                string query;
                if (searchBy == "Product ID")
                {
                    query = $"SELECT * FROM product_print WHERE product_ID LIKE '{search}'";
                }
                else if (searchBy == "Product Name")
                {
                    query = $"SELECT * FROM product_print WHERE product_name LIKE '{search}'";
                }
                else if (searchBy == "Brand")
                {
                    query = $"SELECT * FROM product_print WHERE brand_name LIKE '{search}'";
                }
                else if (searchBy == "Category")
                {
                    query = $"SELECT * FROM product_print WHERE category_name LIKE '{search}'";
                }
                else if (searchBy == "Description")
                {
                    query = $"SELECT * FROM product_print WHERE product_desc_value LIKE '{search}'";
                }
                else
                #region old query
                #endregion
                { query = "SELECT * FROM product_print"; }

                mysqlconnect.Open();
                MySqlCommand     cmd = new MySqlCommand(query, dbcon.mysqlconnect);
                MySqlDataAdapter adp = new MySqlDataAdapter();
                DataSet          dt  = new DataSet();
                adp.SelectCommand = cmd;
                adp.Fill(dt, "dsProduct");
                CrystalReportProduct reporting = new CrystalReportProduct();
                reporting.SetDataSource(dt);
                frmReports frmreports = new frmReports();
                frmreports.crystalReportViewer.ReportSource = reporting;
                frmreports.crystalReportViewer.Refresh();
                cmd.Dispose(); adp.Dispose(); dt.Dispose(); dbcon.mysqlconnect.Close();
                frmreports.ShowDialog();
            }
            catch (Exception ex)
            {
                throw;
            }
        }