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();
}
private void button5_Click(object sender, EventArgs e)
{
SalesReport sr = new SalesReport();
sr.Show();
}
