private void button3_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog1 = new OpenFileDialog(); if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { this.textBox11.Text = openFileDialog1.FileName; } string yolBaglantisi = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + textBox11.Text + ";Extended Properties=\"Excel 8.0;HDR=Yes;\";"; OleDbConnection con = new OleDbConnection(yolBaglantisi); OleDbDataAdapter myAdapter = new OleDbDataAdapter("select * from [Sayfa1$]", con); DataTable dt = new DataTable(); myAdapter.Fill(dt); dataGridView1.DataSource = dt; for (int i = 0; i < dataGridView1.RowCount - 1; i++) { MessageBox.Show(RandevuIslemleri.RandevuEkle(dataGridView1[0, i].Value.ToString(), dataGridView1[1, i].Value.ToString(), dataGridView1[2, i].Value.ToString(), Convert.ToInt32(dataGridView1[3, i].Value))); } //dataGridKayitGoster(); }