Click here to Skip to main content
15,893,622 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
  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
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900