Load all db tables in treeview??[Resolved]

I couldn't figure out how to do this ? I have only VB.NET version ! I've been trying to convert it for a while but to no avail . anyone show me how plz ?

VB Code:

'TreeView
Public Overloads Shared Sub LoadTables(ByVal TreView As TreeView)
                OpenDB.OpenDB()
                Dim Tables As DataTable = MyConnection.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, _
                New Object() {Nothing, Nothing, Nothing, "TABLE"})
                
                CloseDB.CloseDB() 
                If Tables.Rows.Count > 0 Then
                    TreView.BeginUpdate()
                    'add tables as child nodes
                    Dim dr As DataRow
                    For Each dr In Tables.Rows
                        'you can add icons here if you want
                        TreView.Nodes.Add(New TreeNode(dr("TABLE_NAME")))
                    Next
                    TreView.EndUpdate()
                End If
                Tables = Nothing
            End Sub

C#

Code:

---

//TreeView
                        public static void LoadTables (System.Windows.Forms.TreeView TreView)
                        {
                        OpenDB.OpenDB1() ;
                        DataTable Tables = MyConnection().GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,new object[]{null,null,null,"TABLE"});
                        CloseDB.CloseDB1();
                               
                                if (Tables.Rows.Count > 0 ){
                        TreView.BeginUpdate();
     
                                        foreach (DataRow dr in Tables.Rows ) {
TreView.Nodes.Add(new TreeNode (dr(("TABLE_NAME"))));
 TreView.EndUpdate ();
                                        }
                                        Tables=null;
                       
                                }               

                        }

---

This code keeps throwing an error says :
Class1.cs(72): 'dr' denotes a 'variable' where a 'method' was expected
I tried all possible ways but I don't get it to work ? Is my code correct ??
btw , I can load tables in listbox , combobox , checkedlistbox !

Thanks

Here is an example of how to populate the treeview control from a datatable:

Code:

---

private void button1_Click(object sender, System.EventArgs e) {
    DataTable dt = new DataTable();
    DataRow newRow = dt.NewRow();
    dt.Columns.Add("TABLE_NAME", typeof(System.String));
    newRow[0] = "Account";
    dt.Rows.Add(newRow);
    LoadTreeView(dt);
}

private void LoadTreeView(DataTable dt) {
    if(dt.Rows.Count > 0) {
        treeView1.BeginUpdate();
        foreach(DataRow r in dt.Rows) {
            treeView1.Nodes.Add(new TreeNode(r["TABLE_NAME"].ToString()));
        }
        treeView1.EndUpdate();
    }
}

---

Thanks Lethal for making me look at "[].tostring()" . I was messing it up :D . I just changed one line to

Code:

---

TreView.Nodes.Add(new TreeNode (dr["TABLE_NAME"].ToString ()));

---

No problem....I knew as soon as you looked at the code I posted you would realize the problem. :)

How do you translate this into C# ??

VB Code:

Dim flds(MyDataset.Tables(0).Columns.Count - 1) As DataColumn

I did this but not working

Code:

---

DataColumn flds(Property.MyDataset.Tables[0].Columns.Count -1);

---

Code:

---

DataColumn[] flds = new DataColumn[Property.MyDataset.Tables[0].Columns.Count -1];

---

Why this aint working ??:rolleyes: As I know about VB.NET, it's not necessary to instantiate new DataColumn obj ??

Code:

---

DataColumn[Property.MyDataset.Tables[0].Columns.Count -1] flds;

---

Thanks Lethal

I got the following error says "Additional information: Destination array was not long enough. Check destIndex and length, and the array's lower bounds"

Code:

---

public static void LoadColumns (System.Windows.Forms.ListBox LstBox,string TableStr) {
OpenDB.OpenDB1 ();
Property.SQLStr ="Select * from " + TableStr ;
OleDbDataAdapter myadapter = new OleDbDataAdapter (Property.SQLStr,Property.MyConnection());
myadapter.Fill (Property.MyDataset ,TableStr);
DataColumn[] flds = new DataColumn[Property.MyDataset.Tables[0].Columns.Count -1];
Property.MyDataset.Tables[0].Columns.CopyTo (flds,0);


//here it starts
if (LstBox.Items.Count==0) {
LstBox.Items.AddRange (flds);
}else{
//ends here


}
Property.MyDataset.Reset();
MyDB.CloseDB.CloseDB1();
myadapter=null;
                        }

---

What the hell is wrong again?? :confused:
Thanx for any help

Quote:

---

Originally posted by Pirate

Code:

---

DataColumn[Property.MyDataset.Tables[0].Columns.Count -1] flds;

---

---

any way around to get this working ?? I'm stuck .:(

Code:

---

DataColumn[] flds = new DataColumn[Property.MyDataset.Tables[0].Columns.Count];

---

Arrays in C# are zero based. Therfore, if the count property returns 10, you can access the 0-9 indices.

Quote:

---

Originally posted by Pirate
I got the following error says "Additional information: Destination array was not long enough. Check destIndex and length, and the array's lower bounds"

Code:

---


//here it starts
if (LstBox.Items.Count==0) {
LstBox.Items.AddRange (flds);
}else{
//ends here
}
                        }

---

Why it keeps throwing error on this line
Thanx Lethal for any help

---

aaaah it's been solved now . wow !