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