public static void PEkle(Epersonel eklenecekler) { OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Veritabani\\Data.mdb;Jet OLEDB:Database Password=ayakkabi_gelisimsoft;"); OleDbCommand com = new OleDbCommand("insert into personeller(adsoyad,tcno,adres,ceptlf,evtlf,isegiris,departmanID) values(@adsoyad,@tcno,@adres,@ceptlf,@evtlf,@isegiris,@departman)", con); com.Parameters.AddWithValue("@adsoyad", eklenecekler._adsoyad); com.Parameters.AddWithValue("@tcno", eklenecekler._tcno); com.Parameters.AddWithValue("@adres", eklenecekler._adres); com.Parameters.AddWithValue("@ceptlf", eklenecekler._ceptlf); com.Parameters.AddWithValue("@evtlf", eklenecekler._evtlf); com.Parameters.AddWithValue("@isegiris", eklenecekler._isegiris); com.Parameters.AddWithValue("@departman", eklenecekler._departman); if (con.State != ConnectionState.Open) { con.Open(); } try { if (com.ExecuteNonQuery() > 0) { MessageBox.Show("Kayıt İşlemi Yapılmıştır.", "Sonuc", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception Ex) { MessageBox.Show(Ex.ToString(), "Hata", MessageBoxButtons.OK, MessageBoxIcon.Warning); } con.Close(); }
public static DataTable PersonelID(Epersonel GetirID) { OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Veritabani\\Data.mdb;Jet OLEDB:Database Password=ayakkabi_gelisimsoft;"); if (con.State == ConnectionState.Closed) { con.Open(); } OleDbCommand comdept = new OleDbCommand("select personeller.adsoyad,personeller.tcno,personeller.adres,personeller.ceptlf,personeller.evtlf,personeller.isegiris,personeller.cikisdate,personeller.bakiye,departman.adi from personeller inner join departman on personeller.departmanID=departman.departmanId WHERE ((personeller.personelID)=@ID)", con); comdept.Parameters.AddWithValue("@ID", GetirID._personelID); OleDbDataAdapter dappersn = new OleDbDataAdapter(comdept); DataTable dtdptmn = new DataTable(); dappersn.Fill(dtdptmn); con.Close(); return(dtdptmn); }