예제 #1
0
        private void button1_Click_1(object sender, EventArgs e)
        {
            string compname = textBoxcomrpt.Text;

            cnn.Open();
            string       query = "select * from Ageingrpt where Companyname='" + compname + "';";
            MySqlCommand cmd   = new MySqlCommand(query, cnn);
            // MySqlDataReader reader = cmd.ExecuteReader(); // query will be executed and data saved to the db
            DataSet          dat  = new DataSet();
            MySqlDataAdapter cmd1 = new MySqlDataAdapter(query, cnn);

            cmd1.Fill(dat, "DataTable1");
            CrystalReportAgeing1.Load("CrystalReportAgeing.rpt");
            //crystalReportViewer1.Load("CrystalReport3");
            CrystalReportAgeing1.SetDataSource(dat);
            crystalReportViewer1.ReportSource = CrystalReportAgeing1;
            cnn.Close();
        }
예제 #2
0
        private void Ageing_Load(object sender, EventArgs e)
        {
            Ageingcalc1();

            cnn.Open();
            string       query = "select * from Ageingrpt;";
            MySqlCommand cmd   = new MySqlCommand(query, cnn);
            // MySqlDataReader reader = cmd.ExecuteReader(); // query will be executed and data saved to the db
            DataSet          dat  = new DataSet();
            MySqlDataAdapter cmd1 = new MySqlDataAdapter(query, cnn);

            cmd1.Fill(dat, "DataTable1");
            CrystalReportAgeing1.Load("CrystalReportAgeing.rpt");
            //crystalReportViewer1.Load("CrystalReport3");
            CrystalReportAgeing1.SetDataSource(dat);
            crystalReportViewer1.ReportSource = CrystalReportAgeing1;
            cnn.Close();
        }