private void tsbRetrieve_Click(object sender, EventArgs e)
{
Datalayer d = Datalayer.Instance;
try
{
Properties.Settings s = Properties.Settings.Default;
statusLabel.Text = String.Format("Locations {0}", d.Open(s.OraUsername, s.OraPassword, s.OraTNS));
txtLocation.Text = txtLocation.Text.ToUpper();
DataTable dt = d.LocationClass(txtLocation.Text);
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
lblLocationDesc.Text = row["locdescription"].ToString();
lblEqClassCode.Text = row["eqclasscode"].ToString();
lblEqClassDesc.Text = row["eqclassdesc"].ToString();
lblSpecCode.Text = row["classificationid"].ToString();
lblSpecDesc.Text = row["classdescription"].ToString();
DataTable ds = d.LocationAttributes(txtLocation.Text, row["classstructureid"].ToString());
bindingSource1.DataSource = ds;
dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
else
{
statusLabel.Text = String.Format("There is no Location {0}", txtLocation.Text);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
