private void button2_Click_1(object sender, EventArgs e) { open_file_dialog.ShowDialog(); textBox1.Text = open_file_dialog.FileName; string dosya_yolu = open_file_dialog.FileName; OleDbConnection deneme = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source = " + dosya_yolu + "; Extended Properties = Excel 12.0"); deneme.Open(); string sorgu = "select * from [Arabalar$] "; OleDbDataAdapter data_adaptor = new OleDbDataAdapter(sorgu, deneme); deneme.Close(); DataTable dt = new DataTable(); data_adaptor.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.Columns["sil"].Visible = false; dataGridView1.Columns["guncelle"].Visible = false; for (int i = 0; i <= dt.Rows.Count - 1; i++) { string cumle = "insert into tblArac values('" + dataGridView1.Rows[i].Cells["marka"].Value + "','" + dataGridView1.Rows[i].Cells["model"].Value + "','" + dataGridView1.Rows[i].Cells["plaka"].Value + "','" + dataGridView1.Rows[i].Cells["yakit_turu"].Value + "'," + dataGridView1.Rows[i].Cells["motor_gucu"].Value + "," + dataGridView1.Rows[i].Cells["tork"].Value + "," + dataGridView1.Rows[i].Cells["motor_hacmi"].Value + ",'" + dataGridView1.Rows[i].Cells["renk"].Value + "','" + dataGridView1.Rows[i].Cells["vites"].Value + "'," + dataGridView1.Rows[i].Cells["klima"].Value + "," + dataGridView1.Rows[i].Cells["ruhsat_no"].Value + "," + dataGridView1.Rows[i].Cells["sigorta"].Value + ",'" + dataGridView1.Rows[i].Cells["muayne_bit_tar"].Value.ToString() + "'," + dataGridView1.Rows[i].Cells["ucret"].Value + "," + dataGridView1.Rows[i].Cells["kiraDurumu"].Value + ")"; SqlCommand komut = new SqlCommand(cumle, baglanti); komut.ExecuteNonQuery(); } MessageBox.Show("Yükleme İşlemi başarılı", "Başarılı", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Hide(); baglanti.Close(); araclar a = new araclar(); a.Show(); }
private void button1_Click(object sender, EventArgs e) { araclar a = new araclar(); if (ytk.yetkiAnahtar.ToString() == "OKUYUCU") { a.button1.Enabled = false; a.importY.Enabled = false; } a.Show(); }
private void AracEkle_FormClosed(object sender, FormClosedEventArgs e) { baglanti.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from tblArac", baglanti); DataTable dt = new DataTable(); da.Fill(dt); araclar a = new araclar(); a.dataGridView1.DataSource = dt; a.Show(); baglanti.Close(); }
private void AracGuncelle_FormClosed(object sender, FormClosedEventArgs e) { string sql = "select * from tblArac"; if (baglanti.State == ConnectionState.Closed) { baglanti.Open(); } SqlDataAdapter da = new SqlDataAdapter(sql, baglanti); DataTable dt = new DataTable(); da.Fill(dt); araclar a = new araclar(); a.dataGridView1.DataSource = dt; a.Show(); baglanti.Close(); }