private void btnSatinAl_Click(object sender, EventArgs e) { Random random = new Random(); int siparisNo = random.Next(1, 1000); string query = "INSERT INTO Siparisler(MusteriId,SiparisNo,SiparisTarihi,Adet,Fiyat) VALUES (@MusteriId,@SiparisNo,@SiparisTarihi,@Adet,@Fiyat)"; command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@MusteriId", 1); command.Parameters.AddWithValue("@SiparisNo", Convert.ToString(siparisNo)); command.Parameters.AddWithValue("@SiparisTarihi", 2021 - 03 - 12); command.Parameters.AddWithValue("@Adet", Convert.ToInt32(txtAdet.Text)); command.Parameters.AddWithValue("@Fiyat", Convert.ToDecimal(txtBirimFiyati.Text)); connection.Open(); command.ExecuteNonQuery(); connection.Close(); frmSiparisler frmSiparisler = new frmSiparisler(); frmSiparisler.ShowDialog(); }
private void btnSiparisler_Click(object sender, EventArgs e) { frmSiparisler frmSiparisler = new frmSiparisler(); frmSiparisler.ShowDialog(); }