private void RaporGir() { DataTable dt3 = new DataTable(); dt3 = db.maliyeSonID(); sonIDst = db.sonIDst; sonID = Convert.ToInt32(sonIDst); sonID += 1; if (comboTur.Text == "ÇIKTI") { stutar = "-" + txtTutarYeni.Text.Trim(); tutar = Convert.ToInt32(stutar); } else { tutar = Convert.ToInt32(txtTutarYeni.Text.Trim()); } MemoryStream ms = new MemoryStream(); pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat); byte[] img = ms.ToArray(); string insertQuery = "INSERT INTO karsavor_sistemdb.maliyeList(ID, SorumluKisi, SorumluID, Tur, Aciklama, Tutar, Makbuz, Olusturan, OlusturanID) VALUES (@id, @sorumlu, @sorumluid, @tur, @aciklama, @tutar, @makbuz, @olusturan, @olusturanid)"; mySqlCon.Open(); command = new MySqlCommand(insertQuery, mySqlCon); command.Parameters.Add("@id", MySqlDbType.UInt16, 255); command.Parameters.Add("@sorumlu", MySqlDbType.VarChar, 200); command.Parameters.Add("@sorumluid", MySqlDbType.UInt16, 255); command.Parameters.Add("@tur", MySqlDbType.VarChar, 50); command.Parameters.Add("@aciklama", MySqlDbType.VarChar, 300); command.Parameters.Add("@tutar", MySqlDbType.VarChar, 100); command.Parameters.Add("@makbuz", MySqlDbType.LongBlob); command.Parameters.Add("@olusturan", MySqlDbType.VarChar, 255); command.Parameters.Add("@olusturanid", MySqlDbType.UInt16, 255); command.Parameters["@id"].Value = sonID; command.Parameters["@sorumlu"].Value = sGrvAd; command.Parameters["@sorumluid"].Value = sGrvID; command.Parameters["@tur"].Value = comboTur.Text.Trim(); command.Parameters["@aciklama"].Value = txtAciklamaYeni.Text.Trim(); command.Parameters["@tutar"].Value = tutar; command.Parameters["@makbuz"].Value = img; command.Parameters["@olusturan"].Value = olusturan; command.Parameters["@olusturanid"].Value = AnaForm.grvID; if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Yeni Maliye Kaydı Eklendi."); } mySqlCon.Close(); MaliyeListe(); }