private void button1_Click(object sender, EventArgs e)
        {
            if (comboBox1.Text == "" || textBox1.Text == "" || textBox2.Text == "")
            {
                MessageBox.Show("Fill up all fields correctly.");
            }
            else
            {
                try
                {

                    string q = "select sum(quantity) as quantity from challanIn where itemCode='" + comboBox1.Text + "' and cdate>='" + textBox1.Text + "' and cdate <='" + textBox2.Text + "'";
                    string q2 = "select distinct itemCode,itemName,pPrice,sPrice from challanIn where itemCode='" + comboBox1.Text + "' and cdate>='" + textBox1.Text + "' and cdate <='" + textBox2.Text + "'";
                    string q3 = "select sum(quantity) as squantity from Sales where itemCode='" + comboBox1.Text + "' and sDate>='" + textBox1.Text + "' and sDate <='" + textBox2.Text + "'";
                    con.Open();

                    SqlDataAdapter da = new SqlDataAdapter();
                    da.SelectCommand = new SqlCommand(q, con);
                    DataTable dt = new DataTable();

                    ItemLager mydataset = new ItemLager();
                    da.Fill(mydataset, "Qty");
                    da.Dispose();

                    SqlDataAdapter da2 = new SqlDataAdapter();
                    da2.SelectCommand = new SqlCommand(q2, con);
                    da2.Fill(mydataset, "itemInfo");
                    da2.Dispose();

                    SqlDataAdapter da3 = new SqlDataAdapter();
                    da3.SelectCommand = new SqlCommand(q3, con);
                    da3.Fill(mydataset, "salesQty");
                    da3.Dispose();

                    sLCrystal myreport = new sLCrystal();
                    myreport.SetDataSource(mydataset);
                    crystalReportViewer1.ReportSource = myreport;

                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
                finally
                {
                    con.Close();
                }
            }
        }
Beispiel #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (comboBox1.Text == "" || textBox1.Text == "" || textBox2.Text == "")
            {
                MessageBox.Show("Fill up all fields correctly.");
            }
            else
            {
                try
                {
                    string q  = "select sum(quantity) as quantity from challanIn where itemCode='" + comboBox1.Text + "' and cdate>='" + textBox1.Text + "' and cdate <='" + textBox2.Text + "'";
                    string q2 = "select distinct itemCode,itemName,pPrice,sPrice from challanIn where itemCode='" + comboBox1.Text + "' and cdate>='" + textBox1.Text + "' and cdate <='" + textBox2.Text + "'";
                    string q3 = "select sum(quantity) as squantity from Sales where itemCode='" + comboBox1.Text + "' and sDate>='" + textBox1.Text + "' and sDate <='" + textBox2.Text + "'";
                    con.Open();


                    SqlDataAdapter da = new SqlDataAdapter();
                    da.SelectCommand = new SqlCommand(q, con);
                    DataTable dt = new DataTable();

                    ItemLager mydataset = new ItemLager();
                    da.Fill(mydataset, "Qty");
                    da.Dispose();

                    SqlDataAdapter da2 = new SqlDataAdapter();
                    da2.SelectCommand = new SqlCommand(q2, con);
                    da2.Fill(mydataset, "itemInfo");
                    da2.Dispose();

                    SqlDataAdapter da3 = new SqlDataAdapter();
                    da3.SelectCommand = new SqlCommand(q3, con);
                    da3.Fill(mydataset, "salesQty");
                    da3.Dispose();

                    sLCrystal myreport = new sLCrystal();
                    myreport.SetDataSource(mydataset);
                    crystalReportViewer1.ReportSource = myreport;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
                finally
                {
                    con.Close();
                }
            }
        }
 private void itemLagerToolStripMenuItem_Click(object sender, EventArgs e)
 {
     ItemLager il = new ItemLager();
     il.Show();
 }
Beispiel #4
0
        private void itemLagerToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ItemLager il = new ItemLager();

            il.Show();
        }