private void Form1_Load(object sender, EventArgs e) { d.InitializeDataAccess(ProviderType.Oledb,"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=person.accdb;Persist Security Info=True", "Select * from person"); dataGridView1.DataSource = d.getDataTable("select * from person"); var p = new PersonBLL(); MessageBox.Show(""+p.GetLastName(),"MESSAGE"); }
private void btnAdd_Click(object sender, EventArgs e) { //d.InitializeDataAccess(ProviderType.Oledb, // "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=person.accdb;Persist Security Info=True"); //DeclarePersonParametersForAdd(txtAddFname.Text, txtAddMname.Text, txtAddLname.Text); //d.SaveChanges("insert into person(fname,mname,lname) values(@fname,@mname,@lname)"); var p = new PersonBLL(); p.Add(txtAddFname.Text, txtAddMname.Text, txtAddLname.Text); getData(); }