예제 #1
0
        private void but_insert_Click(object sender, EventArgs e)
        {
            con.Open();
            SqlCommand cmd = new SqlCommand();
            //   string queryLog = "SELECT 1 FROM signup WHERE email = '" + textBox_id.Text + "'and Name = '" + textBox_name.Text + "' ;";
            string qurey = "Insert into Sales_Pers(SP_qty,SP_Date,SP_area,SP_Name) values ('" + textBox_qty.Text + "','" + dateTimePicker1.Text + "','" + textBox_area.Text + "','" + textBox_name.Text + "') ";

            cmd.CommandText = qurey;
            cmd.Connection  = con;
            if (cmd.ExecuteNonQuery() > 0)
            {
                MessageBox.Show("DataInserted");
            }
            //Inventory id = new Inventory();
            //id.Show();
            con.Close();
            this.Close();
            SalesReport sr = new SalesReport();

            sr.Show();
            this.Close();
        }
예제 #2
0
        private void button5_Click(object sender, EventArgs e)
        {
            SalesReport sr = new SalesReport();

            sr.Show();
        }