public static bool AddPerson(Person p) { AccessDBHelper.ExcuteNonQuery(@"insert into Persons (姓名,年龄) values (@Name,@Age)", new OleDbParameter("@Name", p._name), new OleDbParameter("@Age", p._age)); return(true); }
public static List <Person> GetAllPerson1() { List <Person> personArray = new List <Person>(); DataSet dataset = AccessDBHelper.ExcuteGetDataset(@"select * from Persons"); DataTable table = dataset.Tables[0]; DataRowCollection rows = table.Rows; foreach (DataRow row in rows) { string strName = (string)row[@"姓名"]; int age = (int)row[@"年龄"]; personArray.Add(new Person(strName, age)); } return(personArray); }