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; }