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(); }
private void button8_Click(object sender, EventArgs e) { string donustur = dateTimePicker1.Value.ToString("yyyy-MM-dd"); if (textBox1.Text == "" && textBox2.Text == "" && comboBox1.Text == "" && dateTimePicker1.Text == "") { MessageBox.Show("Lütfen Gerekli Alanları Doldurun"); } else { MessageBox.Show(RandevuIslemleri.RandevuEkle(comboBox1.Text, donustur, comboBox2.Text, Convert.ToInt32(textBox4.Text))); dataGridKayitGoster(); textBox4.Text = ""; textBox1.Text = ""; textBox2.Text = ""; comboBox1.Text = ""; dateTimePicker1.Text = ""; comboBox1.Text = ""; } }