private void Form1_Load(object sender, EventArgs e) { string sql = "select* from LAPTOP"; OleDbConnection con = new OleDbConnection(koneksi); con.Open(); OleDbDataAdapter da = new OleDbCommand(sql, con); DataSet ds = new DataSet(); da.Fill(ds, "LAPTOP"); con.Close(); dgvLAPTOP.DataSource = ds.Tables["LAPTOP"].DefaultView; }
public void BilgilerGetir() { try { //Kullanicilar tablosundaki veriler çekiliyor baglantim.Open(); OleDbDataAdapter komut = new OleDbDataAdapter("SELECT k.Kimlik,k.İsim,k.Soyisim,k.Email,k.DogumTarihi,u.UrunAd FROM tbl_kullanici as k INNER JOIN tbl_urunler as u ON k.UrunKimlik = u.Kimlik", baglantim); DataTable tablo = new DataTable(); komut.Fill(tablo); dataGridView1.DataSource = tablo; baglantim.Close(); //Combobox'a veriler çekiliyor OleDbCommand command = new OleDbCommand("SELECT UrunAd , Kimlik FROM tbl_urunler", baglantim); baglantim.Open(); DataTable tb = new DataTable(); tb.Load(command.ExecuteReader()); baglantim.Close(); comboBoxUrun.DataSource = tb; comboBoxUrun.DisplayMember = "UrunAd"; comboBoxUrun.ValueMember = "Kimlik"; baglantim.Close(); //Urunler tablosuna veriler çekiliyor baglantim.Open(); komut = new OleDbDataAdapter("select * from tbl_urunler", baglantim); tablo = new DataTable(); komut.Fill(tablo); dataGridView2.DataSource = tablo; baglantim.Close(); } catch (Exception aciklama) { MessageBox.Show(aciklama.Message, "Veri tabanı işlemleri"); baglantim.Close(); } }
private void button1_Click(object sender, EventArgs e) { string txtConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\项目\\db\\ovehicles.mdb"; conn = new OleDbConnection(txtConn); string txtCommand = "SELECT VEHICLE.* , '' as 排放等级 FROM VEHICLE"; OleDbDataAdapter da = new OleDbDataAdapter(txtCommand, conn); DataSet ds = new DataSet("ds"); da.Fill(ds, "Student"); DataTable ff = ds.Tables[0]; foreach (DataRow dr in ff.Rows) { txtCommand = string.Format("SELECT FILENAME,PF FROM O_VEHICLES where CLXH='{0}' AND FDJXH='{1}' ORDER BY FILENAME DESC ", dr["车辆型号"], dr["发动机型号"]); da = new OleDbDataAdapter(txtCommand, conn); DataSet dtt = new DataSet("ds"); da.Fill(dtt, "Student"); if (dtt.Tables.Count > 0) { foreach (DataRow drD in dtt.Tables[0].Rows) { if (Convert.ToDateTime(drD["FILENAME"]) < Convert.ToDateTime(dr["出厂时间"])) { dr["排放等级"] = drD["PF"]; break; } } } } NPOIExcelHelper.DataTableToExcel(ff, "测试", "D:/myt2.xls"); }