How to bind data in treeview by retreiving data from database..?

Question

0.00/5 (No votes)

See more:

Hi..

I am using windowApplication.I dont have any idea about treeview control.I have to bind data in treeview from database.I have a table in database as "OrderDetails".In that i have two column like BillNo and OrderNo.so I have to show BillNo as parentnode
and orderno as childnode.Like this;
+BillNO
-OrderNo1
-OrderNo2.
how would i do this please sumbody help me..

Thanks.

Posted 16-Dec-12 18:20pm

Shivani Dash

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sanjeev Alamuri · Answer 1 · 2012-12-16T18:31:00

Solution 2

Check this logic it might helps u.

C#

dsModules = bfOnlyMasterPage.GetModuleTreeViewList(cmnOnlyMasterPage);// Get dataset from database.

DataTable dt=dsModules.Tables[0];
foreach (DataRow masterRow1 in dt.Rows)
{
      TreeNode masterNode1 = new TreeNode((string)masterRow1["BillNO"], Convert.ToString(masterRow1["BillNO"]));
      trView.Nodes.Add(masterNode1);
      foreach (TreeNode tn in trView.Nodes)
      {
           DataRow[] drlevels = dsModules.Tables[0].Select("BillNO=" + tn.Value);
           int i = 0;
           foreach (DataRow drlevel in drlevels)
           {
               tn.ChildNodes.Add(new TreeNode(drlevel["OrderNo1 "].ToString(), drlevel["OrderNo1 "].ToString()));
               i++;
           }
     }

}

Posted 16-Dec-12 18:31pm

Sanjeev Alamuri

Updated 16-Dec-12 19:01pm

v2

Comments

Shivani Dash 17-Dec-12 0:39am

if i'll use datatable instead of dataset will it b ok?

Sanjeev Alamuri 17-Dec-12 1:00am

dataset contains datatables. so u can extract datatable from datasets.
datatabel=dsModules.Tables[0];//0 means index.

U can replace top foreach loop as fallows.

foreach (DataRow masterRow1 in dtTables.Rows)
{
.
see my updated answer above.

Shivani Dash 17-Dec-12 1:22am

dsModules = bfOnlyMasterPage.GetModuleTreeViewList(cmnOnlyMasterPage);
what is ds?

Sanjeev Alamuri 17-Dec-12 1:28am

the first line is to get dataset from database using 3-tier architecture. u need not bother about this. here dsModule is dataset.
its the code in my project. there is nothing about ds. u have a datatable. so can move from foreach statement.

Shivani Dash 17-Dec-12 1:31am

ya but it shows error lines in
TreeNode masterNode1 = new TreeNode((string)masterRow1["BillNO"], Convert.ToString(masterRow1["BillNO"]));
its shows "invalid argument"

Sanjeev Alamuri 17-Dec-12 1:33am

so check the datatypes of ur column values "BillNo".

Shivani Dash 17-Dec-12 1:37am

ya both are string.

Sanjeev Alamuri 17-Dec-12 1:39am

okay use QUICKWATCH and check the value of "masterRow1["BillNO"]" in that line.

Shivani Dash 17-Dec-12 1:43am

bt that can v chk aftr running na.ds lines shows b4 running.den hw wud i?

Sanjeev Alamuri 17-Dec-12 1:46am

yes.okay post ur code here.

Shivani Dash 17-Dec-12 1:49am

iBO.Operation = "Tree";
DataTable dt = iBO.PopulateTree(iBO);
//DataTable dt=dsModules.Tables[0];
foreach (DataRow masterRow1 in dt.Rows)
{
TreeNode masterNode1 = new TreeNode(masterRow1["BillNO"], Convert.ToString(masterRow1["BillNO"]));
treeView1.Nodes.Add(masterNode1);
foreach (TreeNode tn in treeView1.Nodes)
{
DataRow[] drlevels = dsModules.Tables[0].Select("BillNO=" + tn.Value);
int i = 0;
foreach (DataRow drlevel in drlevels)
{
tn.ChildNodes.Add(new TreeNode(drlevel["OrderNo1 "].ToString(), drlevel["OrderNo1 "].ToString()));
i++;
}
}

Sanjeev Alamuri 17-Dec-12 1:50am

TreeNode masterNode1 = new TreeNode(masterRow1["BillNO"], Convert.ToString(masterRow1["BillNO"]));

change thisline to as follows, because this method accepts string, so before u sending this, convert into sting.

TreeNode masterNode1 = new TreeNode((string)masterRow1["BillNO"], Convert.ToString(masterRow1["BillNO"]));

Shivani Dash 17-Dec-12 1:50am

operation="tree" which is takg in database,in which i wrote the query as
select BillNO,OrderNo1 from dbo.Order_temp where OrderNo=@OrderNo

Shivani Dash 17-Dec-12 1:54am

still it showing the same error.

Sanjeev Alamuri 17-Dec-12 1:58am

can u connet me on sanjev1297@gmail.com.