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; }
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 FindButtonClick(object sender, System.EventArgs e) { //create the form to show results, create teh SQL string, run the command and then show results on form dbResult findResult = new dbResult(); string queryCriteria = ""; string queryEnd = ""; if (!isConnected) { MessageBox.Show("Please connect to database prior to searching."); } else { //last name must be entered prior to search. entering * is a wildcard, and entering nothing actually searches for a blank criteria if (lastName.Text != "") { if (lastName.Text != "*") { queryEnd = ")"; queryCriteria = "WHERE ((LastName='" + lastName.Text.ToString() + "')"; if (firstName.Text != "") { queryCriteria = queryCriteria + "AND " + "(FirstName='" + firstName.Text.ToString() + "')"; } if (middleName.Text != "") { queryCriteria = queryCriteria + "AND " + "(middleName='" + middleName.Text.ToString() + "')"; } } findResult.queryDatabase(queryCriteria, queryEnd, findResult, conn); //set up the form and show dbForm findForm = new dbForm(findResult, dataBasePath); findForm.Show(); } } }