private void FindButton_Click(object sender, EventArgs e) { //changes mouse curser style Cursor.Current = Cursors.WaitCursor; using (FakeBookV3DataSetTableAdapters.UserProfilesTableAdapter profilesTableAdapter = new FakeBookV3DataSetTableAdapters.UserProfilesTableAdapter()) { // Connects database to project and then Fill() to TableAdapter FakeBookV3DataSet fakebookDB = new FakeBookV3DataSet(); profilesTableAdapter.Fill(fakebookDB.UserProfiles); // appends datarows from Table Adapter into List view foreach (DataRow row in fakebookDB.UserProfiles.Rows) { // adds Labeled Rows/ Columns to list ListViewItem item = new ListViewItem(row["First Name"].ToString()); item.SubItems.Add(row["Last Name"].ToString()); item.SubItems.Add(row["Company"].ToString()); item.SubItems.Add(row["Address"].ToString()); item.SubItems.Add(row["State/District"].ToString()); item.SubItems.Add(row["County/Province"].ToString()); item.SubItems.Add(row["Country"].ToString()); item.SubItems.Add(row["Zip/Postal"].ToString()); item.SubItems.Add(row["Phone1"].ToString()); item.SubItems.Add(row["Email"].ToString()); item.SubItems.Add(row["Website"].ToString()); lvFriends.Items.Add(item); } lvFriends.View = View.List; } }
private void FindButton_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; /* * Test Code * * using (FakeBookV2DataSetTableAdapters.UserProfilesTableAdapter profilesTableAdapter = new FakeBookV2DataSetTableAdapters.UserProfilesTableAdapter()) * { * FakeBookV2DataSet db = new FakeBookV2DataSet(); * profilesTableAdapter.Fill(db.UserProfiles); * List<> list = db.UserProfiles.ToList(); * foreach(use) * * } */ { /*Test Code * * public int getCount() { * if (mList != null) { * return * Math.min(mList.size()), YOU_MAX_VALUE); * } else * { * return 0; * } * } */ using (FakeBookV3DataSetTableAdapters.UserProfilesTableAdapter profilesTableAdapter = new FakeBookV3DataSetTableAdapters.UserProfilesTableAdapter()) { FakeBookV3DataSet fakebookDB = new FakeBookV3DataSet(); profilesTableAdapter.Fill(fakebookDB.UserProfiles); foreach (DataRow row in fakebookDB.UserProfiles.Rows) { /* Test Code * foreach (DataRow row in dt.Rows) * { * //Add Item to ListView. * ListViewItem item = new ListViewItem(row["Name"].ToString()); * item.SubItems.Add(row["CustomerId"].ToString()); * TestView.Items.Add(item); * } */ ListViewItem item = new ListViewItem(row["First Name"].ToString()); item.SubItems.Add(row["Last Name"].ToString()); item.SubItems.Add(row["Company"].ToString()); //Test Code // //TestView.Items.Add(row["First Name"].ToString); //TestView.Items(TestView.Items.Count-1).SubItems.Add(row["Last Name"].ToString()); //TestView.Items(TestView.Items.Count - 1).SubItems.Add(row["Last Name"].ToString()); //TestView.Items(TestView.Items.Count - 1).SubItems.Add(row["Last Name"].ToString()); item.SubItems.Add(row["Address"].ToString()); item.SubItems.Add(row["State/District"].ToString()); item.SubItems.Add(row["County/Province"].ToString()); item.SubItems.Add(row["Country"].ToString()); item.SubItems.Add(row["Zip/Postal"].ToString()); item.SubItems.Add(row["Phone1"].ToString()); item.SubItems.Add(row["Email"].ToString()); item.SubItems.Add(row["Website"].ToString()); lvFriends.Items.Add(item); } lvFriends.View = View.List; } } }