static void Main(string[] args) { //Establish a connection with DBConnect class to access patron table DBConnect db = new DBConnect(); Address myAddress = new Address(); PreviousVisit pVisit = new PreviousVisit(); Patron myPatron = new Patron(2, "Joe", "Bloggs", "S", "5550134", myAddress,pVisit); //holds quiried data. First element will contain cells of first column from table. Second element contains second column and so on.... List<Patron> list = new List<Patron>(); list = db.SelectPatron("SELECT * FROM patron WHERE firstName = 'Rob'"); for (int x = 0; x < list.Count; x++) { Console.WriteLine(list[x].Id); Console.WriteLine(list[x].FirstName); Console.WriteLine(list[x].LastName); Console.WriteLine(list[x].MiddleInitial); Console.WriteLine(list[x].Phone); Console.WriteLine(list[x].StreetNum); Console.WriteLine(list[x].AddressLine1); Console.WriteLine(list[x].AddressLine2); Console.WriteLine(list[x].City); Console.WriteLine(list[x].State); Console.WriteLine(list[x].Zip); Console.WriteLine(list[x].NumChildren); Console.WriteLine(list[x].NumAdults); Console.WriteLine(list[x].Date.Month+"/"+list[x].Date.Day+"/"+list[x].Date.Year); Console.WriteLine(" "); } /*list = db.SelectPatron("SELECT * FROM patron WHERE firstName = 'Rob'"); foreach (var i in list) { Console.WriteLine(i); } for (int x = 0; x < list.Length; x++) { for(int y=0;y<list[x].Count;y++){ Console.WriteLine(list[x].ElementAt(y)); } }*/ //db.Query("INSERT INTO patron (patron_id, firstName, lastName, middleInitial, phone) VALUES ('10', 'Tom', 'Maey', 'ff', '2353744')"); Console.ReadLine(); }
public Form1() { /* * dataGridView2 private System.Windows.Forms.DataGridViewTextBoxColumn viewAllFirstName; private System.Windows.Forms.DataGridViewTextBoxColumn viewAllLastName; private System.Windows.Forms.DataGridViewTextBoxColumn viewAllMiddleInitial; private System.Windows.Forms.DataGridViewTextBoxColumn viewAllAddressLine1; private System.Windows.Forms.DataGridViewTextBoxColumn viewAllAddressLine2; private System.Windows.Forms.DataGridViewTextBoxColumn viewAllPhone; private System.Windows.Forms.DataGridViewTextBoxColumn viewAllAdults; private System.Windows.Forms.DataGridViewTextBoxColumn viewAllChildren; private System.Windows.Forms.DataGridViewTextBoxColumn viewAllPrevVisit; */ InitializeComponent(); DBConnect db = new DBConnect(); int count = db.Count("SELECT * FROM patron"); String[] rows = new String[count]; List<Patron> list = new List<Patron>(); list = db.SelectPatron("SELECT * FROM patron"); for (int x = 0; x < list.Count; x++) { String date = list[x].Date.Month + "/" + list[x].Date.Day + "/" + list[x].Date.Year; String children = ""; children += list[x].NumChildren; String adults = ""; adults += list[x].NumAdults; string[] row = { list[x].FirstName, list[x].LastName, list[x].MiddleInitial, list[x].AddressLine1, list[x].AddressLine2, list[x].Phone, children, adults, date }; dataGridView2.Rows.Add(row); } }