// This method is invoked when the application has loaded its UI and its ready to run public override bool FinishedLaunching (UIApplication app, NSDictionary options) { dataSource = new EmployeeDataSource(this); @delegate = new EmployeeListDelegate(this); tableviewEmployee.DataSource = dataSource; tableviewEmployee.Delegate = @delegate; alertDelegate = new CallAlert (this); //System.MissingMethodException: Method not found: 'Default constructor not found...ctor() of CorporateDirectory1.Employee'. var e = new Employee(); e.Firstname = "a"; e.Work=1; e.Mobile=2; e.Lastname="b";e.Department="c";e.Email="@"; var f = e.Firstname; var g = e.Work; var h=e.Mobile; var i=e.Lastname; var j=e.Department; var k=e.Email; using (var db = new SQLiteClient.SQLiteConnection("phonebook")) { // Perform strongly typed queries var users = db.Query<Employee>("SELECT Firstname, Lastname, Work, Mobile, Department, Email FROM Phonebook ORDER BY Lastname", 1000); listData = users.ToList(); } window.MakeKeyAndVisible (); return true; }
// This method is invoked when the application has loaded its UI and its ready to run public override bool FinishedLaunching(UIApplication app, NSDictionary options) { dataSource = new EmployeeDataSource(this); @delegate = new EmployeeListDelegate(this); tableviewEmployee.DataSource = dataSource; tableviewEmployee.Delegate = @delegate; alertDelegate = new CallAlert(this); //System.MissingMethodException: Method not found: 'Default constructor not found...ctor() of CorporateDirectory1.Employee'. var e = new Employee(); e.Firstname = "a"; e.Work = 1; e.Mobile = 2; e.Lastname = "b"; e.Department = "c"; e.Email = "@"; var f = e.Firstname; var g = e.Work; var h = e.Mobile; var i = e.Lastname; var j = e.Department; var k = e.Email; using (var db = new SQLiteClient.SQLiteConnection("phonebook")) { // Perform strongly typed queries var users = db.Query <Employee>("SELECT Firstname, Lastname, Work, Mobile, Department, Email FROM Phonebook ORDER BY Lastname", 1000); listData = users.ToList(); } window.MakeKeyAndVisible(); return(true); }
// This method is invoked when the application has loaded its UI and its ready to run public override bool FinishedLaunching(UIApplication app, NSDictionary options) { tableviewEmployee.DataSource = new EmployeeDataSource(this); tableviewEmployee.Delegate = new EmployeeListDelegate(this); #if ORM using (var db = new SQLiteClient.SQLiteConnection("phonebook")) { db.Open(); // Perform strongly typed queries var users = db.Query<Employee>("SELECT Firstname, Lastname, Work, Mobile, Department, Email FROM Phonebook ORDER BY Lastname", 1000); listData = users.ToList(); } #else listData = new List<Employee>(); // System.Data test code from http://monotouch.net/Documentation/System.Data var sd = new SystemDataHelper("phonebook"); var connection = sd.GetConnection(); using (var cmd = connection.CreateCommand()) { connection.Open (); cmd.CommandText = "SELECT Firstname, Lastname, Work, Mobile, Department, Email " + "FROM Phonebook ORDER BY Lastname"; using (var reader = cmd.ExecuteReader ()) { while (reader.Read ()) { var emp = new Employee(); emp.Firstname = (string)reader["Firstname"]; emp.Lastname = (string)reader["Lastname"]; emp.Work = (string)reader["Work"]; emp.Mobile = (string)reader["Mobile"]; emp.Department = (string)reader["Department"]; emp.Email = (string)reader["Email"]; Console.WriteLine("Column {0}",reader["Lastname"]); listData.Add(emp); } } } #endif window.MakeKeyAndVisible (); return true; }