quote:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace Günlük_Yapılacak_Ürünler
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
//kapat butonunu kaldırma
private const int CP_NOCLOSE_BUTTON = 0x200;
protected override CreateParams CreateParams
{
get
{
CreateParams myCp = base.CreateParams;
myCp.ClassStyle = myCp.ClassStyle | CP_NOCLOSE_BUTTON;
return myCp;
}
}


MySqlConnection baglan = new MySqlConnection("Server=20.0.0.198;port=3306;Database=sevkiyat2019;Uid=gsevkiyat;Pwd='153624sevkiyat';SslMode=none");


MySqlDataAdapter da;
DataSet ds;
DataTable dt;
MySqlCommandBuilder cmdb;
MySqlCommand komut;
MySqlDataReader dr;



string toplam_koli;
string toplam_kutu;
string tarih_date;
private void Form1_Load(object sender, EventArgs e)
{
try
{
baglan.Open();
urun_listele();
btn_ara.PerformClick();
//kayit_listele_ambalaj();
// kayit_listele_imalat();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

}

void kayit_listele_ambalaj() //Ambalajlama için Kayıtları Datagridviewde listeleme
{

try
{
tarih_date = kayit_tarihi.Value.ToShortDateString();
da = new MySqlDataAdapter("Select * From gunluk_liste where kayit_tarihi='" + tarih_date + "' and is_durum='Ambalaj' ORDER BY departman", baglan);
ds = new DataSet();
da.Fill(ds, "gunluk_liste");
ambalaj_dgv.DataSource= ds.Tables[0];

//toplamkutuf();
//toplamkolif();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

}
void kayit_listele_imalat() //imalat için Kayıtları Datagridviewde listeleme
{

try
{
tarih_date = kayit_tarihi.Value.ToShortDateString();
da = new MySqlDataAdapter("Select * From gunluk_liste where kayit_tarihi='" + tarih_date + "' and is_durum='İmalat' ORDER BY departman", baglan);
ds = new DataSet();
da.Fill(ds, "gunluk_liste");
imalat_dgv.DataSource = ds.Tables[0];


//toplamkutuf();
//toplamkolif();
}

catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
void kayit_guncelle()
{
try
{
cmdb = new MySqlCommandBuilder(da);
da.Update(ds, "gunluk_liste");


}

catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void guncelle_btn_Click(object sender, EventArgs e)
{

try
{
kayit_guncelle();
MessageBox.Show("Kayıt güncellendi");

kayit_listele_ambalaj();
//kayit_listele_imalat();

}

catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}