public void queryDatabase(string sqlString, customQuery findResult, System.Data.OleDb.OleDbConnection conn) { OleDbCommand Com = new OleDbCommand(); Com.CommandText = sqlString; Com.Connection = conn; OleDbDataReader objDataReader = null; objDataReader = Com.ExecuteReader(); if (objDataReader == null) { return; } while (objDataReader.Read()) { findResult.SetIndex(objDataReader["PersonID"].ToString()); } objDataReader.Close(); string whereClause = "(MyNumber='" + findResult.GetIndex(0) + "') "; for (int i = 1; i < findResult.GetIndexCount(); i++) { whereClause = whereClause + "OR (MyNumber='" + findResult.GetIndex(i) + "') "; } string localsqlString = "SELECT PersonName FROM tblPeeps WHERE (" + whereClause + ")"; OleDbCommand Com2 = new OleDbCommand(); Com2.CommandText = localsqlString; Com2.Connection = conn; OleDbDataReader objDataReader2 = null; objDataReader2 = Com2.ExecuteReader(); if (objDataReader2 == null) { return; } while (objDataReader2.Read()) { findResult.SetName(objDataReader2["PersonName"].ToString()); } objDataReader2.Close(); }
void OpenToolStripMenuItemClick(object sender, EventArgs e) { customQuery newQuery = new customQuery(); string newRoot = ""; //open the dialog box so user can choose path openFileDialog1.ShowDialog(); string path = openFileDialog1.FileName; //get root and branches from file string textIn = File.ReadAllText(path); string [] textArray = textIn.Split(new string [] { "###" }, StringSplitOptions.RemoveEmptyEntries); string [] contentsArray = textArray[3].Split(new string [] { "<EOL>" }, StringSplitOptions.RemoveEmptyEntries); string [] newRootArray = new string[2]; string [] newBranchArray = new String[2]; //check that an actual connectMap file has been selected if (textArray[0].Contains("connectMap")) { //grab teh root file newRootArray = contentsArray[0].Split(new string [] { ">" }, StringSplitOptions.RemoveEmptyEntries); newRoot = newRootArray[1]; //get the branches and set up the localQuery object for (int i = 1; i < contentsArray.Length; i++) { newBranchArray = contentsArray[i].Split(new string [] { ">" }, StringSplitOptions.RemoveEmptyEntries); newQuery.SetName(newBranchArray[1]); } } //create new display and pass it the root and query objects displayForm analyzeDisplay = new displayForm(newQuery, newRoot); analyzeDisplay.Show(); }