question

Ajith avatar image
Ajith asked

populate treeview control with tables views and columns from a sql server database

select TABLE_NAME,COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS By using this i am getting all Column_name and Table_Name. May I know required SQL Query to call in C# for populating treeview control with tables views and columns from a sql server database in C# language ?
sql-server-2012mssql
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
What do you mean by TreeStructure?
0 Likes 0 ·
Ajith avatar image Ajith commented ·
With Nodes.. i.e Table 1 - Table_name with node level 1 & their column_name with node level 2 ex: + Table_Name1 - Column_Name - Column_Name - Column_Name + Table_Name2 - Column_Name - Column_Name (Like this)
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.