private void btnLoadFromDb_Click(object sender, EventArgs e)
{
try
{
dgvTreeList.DataSource = null;
dgvTreeList.Refresh();
if (!string.IsNullOrEmpty(txtTreeId.Text))
{
DataTable dt = DAL.get_Tree_By_TreeId_DataTable(txtTreeId.Text);
//sort the dataview (can't sort datatable)
DataView dv = dt.DefaultView;
dv.Sort = "leafName asc";
DataTable sortedDT = dv.ToTable();
//bind the DataGridView
dgvTreeList.DataSource = sortedDT;
dgvTreeList.Refresh();
txtTreeName.Text = dt.Rows[0]["treeName"].ToString();
txtComment.Text = dt.Rows[0]["treeComment"].ToString();
txtCreateDate.Text = dt.Rows[0]["treeCreateDate"].ToString();
lblTreeId.Text = string.Format("Tree ID ({0}):", dt.Rows.Count.ToString());
Application.DoEvents();
lblStat.Text = "Load from DB complete. Ready.";
}
else
{
lblStat.Text = "Error loading from DB. Ready.";
}
}
catch (Exception ex)
{
lblStat.Text = "Error loading from DB (" + ex.Message.ToString() + "). Ready.";
}
}
private void cboUTrees_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboUTrees.SelectedValue.ToString().Length == 36)
{
DataTable dt = DAL.get_Tree_By_TreeId_DataTable(cboUTrees.SelectedValue.ToString());
txtTreeName.Text = dt.Rows[0]["treeName"].ToString();
txtComment.Text = dt.Rows[0]["treeComment"].ToString();
txtCreateDate.Text = dt.Rows[0]["treeCreateDate"].ToString();
txtNumLeafs.Text = dt.Rows.Count.ToString();
}
dgvTreeList.DataSource = null;
dgvTreeList.Refresh();
lvLeafSizes.Clear();
}
