i used below coding to fetch data from database to bind in treeview., i am getting fromdate details according to selected company from table., for example if i choose A then i am getting treeview like
A
--20/10/2012
A
--23/10/2012
A
--27/10/2012
A
--29/10/2012
but actual i want like
A
--20/10/2012
--23/10/2012
--27/10/2012
--29/10/2012
private void ShowMenu_Click(object sender, EventArgs e)
{
try
{
gn.cnopen();
cmd = new SqlCommand("FETCH_CONFERENCE_HALL_DETAILS_MENUS", gn.cn());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TYPE", 2);
cmd.Parameters.AddWithValue("@FROM_DATE", "");
cmd.Parameters.AddWithValue("@TO_DATE", "");
cmd.Parameters.AddWithValue("@COMPANYNAME",ddlcompanyname.SelectedItem.ToString());
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
TreeNode trn;
TreeNode node;
TreeNode[] array;
treeView1.Nodes.Clear();
dt.Clear();
da.Fill(dt);
string cmn = dt.Rows[0]["company_name"].ToString();
if (dt.Rows.Count > 0)
{
for (int cn = 0; cn <= dt.Rows.Count - 1; cn++)
{
string getfrmdate = dt.Rows[cn]["fromdate"].ToString();
node = new TreeNode(getfrmdate);
getfrmdate = "";
array = new TreeNode[] { node };
trn = new TreeNode(cmn, array);
treeView1.Nodes.Add(trn);
}
}
}
catch (SqlException err)
{
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
[edit]code block added[/edit]