public Form1() { InitializeComponent(); } OleDbConnection bag = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=db1.mdb"); DataTable tablo = new DataTable(); DataSet komut = new DataSet(); OleDbDataAdapter adtr = new OleDbDataAdapter(); //7private void AyGetir() //{ // OleDbCommand Aylar = new OleDbCommand("select * from Aylar ",bag); //OleDbDataReader Ayoku = Aylar.ExecuteReader(); // while (Ayoku.Read()) // { // Aylar.Items.Add(urunoku.GetString(0)); // } // } private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'db1DataSet.Girdi' table. You can move, or remove it, as needed. //this.girdiTableAdapter.Fill(this.db1DataSet.Girdi); bag.Open(); OleDbDataAdapter adtr1 = new OleDbDataAdapter("select * From Aylar", bag); DataTable dt = new DataTable(); adtr1.Fill(dt); comboBox1.DataSource = dt; comboBox1.ValueMember = "Kimlik"; // burada combobox ın value memberını yani değer parametresini veritabanındaki id alanından almasını istedim. comboBox1.DisplayMember = "Ay"; bag.Close(); // dateTimePicker1.Value = Convert.ToDateTime(dataGridView1.CurrentRow.Cells[0].Value); bag.Open(); OleDbCommand cmd = new OleDbCommand("select * From Girdi Where Aylar='" + comboBox1.Text + "'", bag); OleDbDataAdapter adtr = new OleDbDataAdapter(cmd); DataSet komut = new DataSet(); adtr.Fill(komut,"tablo"); dataGridView1.DataSource = tablo; dataGridView2.DataSource = tablo; adtr.Dispose(); bag.Close(); dataGridView1.DataSource = komut; dataGridView1.DataMember = "tablo"; dataGridView1.Columns["Kimlik"].Visible = false; dataGridView1.Columns["Aylar"].HeaderText = "Aylar"; dataGridView1.Columns["Tarih"].HeaderText = "Tarih"; dataGridView1.Columns["Girdi_Aciklama"].HeaderText = "Açıklama"; dataGridView1.Columns["Girdi_Evrak"].HeaderText = "Evrak"; dataGridView1.Columns["Girdi_Tutar"].HeaderText = "Tutar"; dataGridView1.Columns["Cikti_Tarih"].Visible = false; dataGridView1.Columns["Cikti_Aciklama"].Visible = false; dataGridView1.Columns["Cikti_Evrak"].Visible = false; dataGridView1.Columns["Cikti_Tutar"].Visible = false; dataGridView2.DataSource = komut; dataGridView2.DataMember = "tablo"; dataGridView2.Columns["Kimlik"].Visible = false; dataGridView2.Columns["Tarih"].Visible = false; dataGridView2.Columns["Girdi_Aciklama"].Visible = false; dataGridView2.Columns["Girdi_Evrak"].Visible = false; dataGridView2.Columns["Girdi_Tutar"].Visible = false; dataGridView2.Columns["Aylar"].HeaderText = "Aylar"; dataGridView2.Columns["Cikti_Tarih"].HeaderText = "Tarih"; dataGridView2.Columns["Cikti_Aciklama"].HeaderText = "Açıklama"; dataGridView2.Columns["Cikti_Evrak"].HeaderText = "Evrak"; dataGridView2.Columns["Cikti_Tutar"].HeaderText = "Tutar"; dataGridView1.Columns["Aylar"].Width = 50; dataGridView1.Columns["Tarih"].Width = 100; dataGridView1.Columns["Girdi_Aciklama"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView1.Columns["Girdi_Evrak"].Width = 60; dataGridView1.Columns["Girdi_Tutar"].Width= 100; dataGridView2.Columns["Aylar"].Width = 50; dataGridView2.Columns["Tarih"].Width = 100; dataGridView2.Columns["Cikti_Aciklama"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView2.Columns["Cikti_Evrak"].Width = 60; dataGridView2.Columns["Cikti_Tutar"].Width = 100; } private void button1_Click(object sender, EventArgs e) { foreach (DataGridViewRow Satir in dataGridView1.Rows) { DataSet komut = new DataSet(); if (bag.State == ConnectionState.Closed) bag.Open(); OleDbCommand Ckomut = new OleDbCommand("Update Girdi set Aylar='" + comboBox1.Text + "' ,Tarih= '" +Satir.Cells["Tarih"] + "' where Aylar='" + comboBox1.Text + "'", bag); Ckomut.ExecuteNonQuery(); dataGridView1.Update(); bag.Close(); } MessageBox.Show("kayıt güncellendi"); }</pre> I've tried them did not
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)