void Button2Click(object sender, System.EventArgs e) { int myIndex = comboBox1.SelectedIndex; string selectedIndex = ""; string selectedName = ""; dbResult localResult = new dbResult(); selectedIndex = localIndex[myIndex]; selectedName = localName[myIndex]; localResult.queryDatabase("WHERE ((MyNumber='" + selectedIndex + "')", ")", localResult, conn2); localResult.ClearIndex(); localResult.ClearName(); for (int i = 0; i < localIndex.Count; i++) { localResult.SetIndex(localIndex[i]); localResult.SetName(localName[i]); } //delete the entry we're going to edit localResult.deleteFromDatabase(localIndex[myIndex], conn2); //set up the extraction form and show ExtractionForm editForm = new ExtractionForm(myDBPath, localResult); editForm.Show(); }
void ComboBox1SelectedIndexChanged(object sender, EventArgs e) { //take the new index of the combobox and look up the index of the local list. //use the local list value to search the database user IDs. //then repopulate the form. //access connections have already been set up and everything. //TODO:after quert, point editResult to the localResult for use when button2 is pressed string selectedIndex = ""; string selectedName = ""; int myIndex = comboBox1.SelectedIndex; comboIndex = myIndex; dbResult localResult = new dbResult(); selectedIndex = localIndex[myIndex]; selectedName = localName[myIndex]; localResult.queryDatabase("WHERE ((MyNumber='" + selectedIndex + "')", ")", localResult, conn2); localResult.ClearIndex(); localResult.ClearName(); for (int i = 0; i < localIndex.Count; i++) { localResult.SetIndex(localIndex[i]); localResult.SetName(localName[i]); } //editResult = localResult; clearForm(); populateForm(localResult, myIndex); //localResult = null; }
public void queryDatabase(string whereClause, string endClause, dbResult findResult, System.Data.OleDb.OleDbConnection conn) { bool foundData = false; string sqlString = "SELECT LastName, FirstName, MiddleName, PersonName, StreetAddress, " + "Country, PlaceOfBirth, DateOfBirth, Passport, Notes, EyeColor, " + "HairColor, Height, Weight, Ethnicity, MyNumber, Photo " + "FROM tblPeeps " + whereClause + endClause; OleDbCommand Com = new OleDbCommand(); Com.CommandText = sqlString; Com.Connection = conn; OleDbDataReader objDataReader = null; objDataReader = Com.ExecuteReader(); if (objDataReader == null) { return; } while (objDataReader.Read()) { findResult.SetLastName(objDataReader["LastName"].ToString()); findResult.SetFirstName(objDataReader["FirstName"].ToString()); findResult.SetMiddleName(objDataReader["MiddleName"].ToString()); findResult.SetCountry(objDataReader["Country"].ToString()); findResult.SetPOB(objDataReader["PlaceOfBirth"].ToString()); findResult.SetDOB(objDataReader["DateOfBirth"].ToString()); findResult.SetPassport(objDataReader["Passport"].ToString()); findResult.SetNotes(objDataReader["Notes"].ToString()); findResult.SetEyecolor(objDataReader["EyeColor"].ToString()); findResult.SetHaircolor(objDataReader["HairColor"].ToString()); findResult.SetHeight(objDataReader["Height"].ToString()); findResult.SetWeight(objDataReader["Weight"].ToString()); findResult.SetEthnicity(objDataReader["Ethnicity"].ToString()); findResult.SetPics(objDataReader["Photo"].ToString()); findResult.SetName(objDataReader["PersonName"].ToString()); findResult.SetIndex(objDataReader["MyNumber"].ToString()); foundData = true; } objDataReader.Close(); if (foundData) { sqlString = "SELECT Entries, Addresses, Technologies, DateOfAddresses, " + "Associates, Universities, Degrees, FieldOfStudies, PlaceOfBiz, RoleInBiz, Links " + "FROM tblOtherInfo " + "WHERE (PersonID='" + findResult.GetIndex(findResult.GetIndexCount() - 1) + "')"; OleDbCommand Com2 = new OleDbCommand(); Com2.CommandText = sqlString; Com2.Connection = conn; OleDbDataReader objDataReader2 = null; objDataReader2 = Com2.ExecuteReader(); if (objDataReader2 == null) { return; } while (objDataReader2.Read()) { findResult.SetEntries(objDataReader2["Entries"].ToString()); findResult.SetAddress(objDataReader2["Addresses"].ToString() + "\t\t" + objDataReader2["DateOfAddresses"].ToString()); findResult.SetEducation(objDataReader2["Universities"].ToString() + "\t\t" + objDataReader2["Degrees"].ToString() + "\t\t" + objDataReader2["FieldOfStudies"].ToString()); findResult.SetTechnology(objDataReader2["Technologies"].ToString()); findResult.SetBusinesses(objDataReader2["PlaceOfBiz"].ToString() + "\t\t" + objDataReader2["RoleInBiz"].ToString()); findResult.SetAssociates(objDataReader2["Associates"].ToString()); findResult.SetLinks(objDataReader2["Links"].ToString()); } objDataReader2.Close(); } else { MessageBox.Show("Search Returned 0 matches.\nEnter * in LastName field to see all entries."); } }