private void Drill_Into_Pad(string idvalue)
{
int fieldcount;
string temp;
string SQL = "SELECT * from Nodes where id = " + idvalue.ToString();
OleDbCommand aCommand = new OleDbCommand(SQL, local);
try
{
//create the datareader object to connect to table
OleDbDataReader aReader = aCommand.ExecuteReader();
DrillList.Items.Clear();
//Iterate throuth the database
while (aReader.Read())
{
for (fieldcount = 0; fieldcount <= aReader.FieldCount - 1; fieldcount++)
{
ListBoxItem lbi = new ListBoxItem();
temp = aReader.GetName(fieldcount);
temp = temp + " : " + Convert.ToString(aReader.GetValue(fieldcount));
lbi.Content = temp;
DrillList.Items.Add(lbi);
}
}
aReader.Close();
}
catch (Exception eDrill)
{
MessageBox.Show("Unable to Drill into values for " + idvalue.ToString());
MessageBox.Show(eDrill.Message);
}
}