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");
}
