displaying sql query result

shriram iyer

15y3.4k

how do i display the sql query result in a grid ,so as to the other columns should be hidden .for example if i select name,,then only name entries shoould be der, tthere should be only one column.similarly for name ,rollno -2 columns and so on ..
databinding in xaml cant be applied obviously ...as colums are to be generated dynamically .

please help ..

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

shriram iyer15y ago
example: select student_name from student_table
result:
Student_name
Sam
Bam
tam
if query is select student_name,roll_no from student_table
result:
Student_name roll_no
Sam                  1
Bam                  2
tam                  3
if query is select roll_no from student_table
result: roll_no
            1
            2
            3

i.e:the other columns should not be displayed only the queried column entries sholud be displayed
Sam Hobbs15y ago
How does SQL Server show data? SQL Server is the database; it does not show data. Do you mean one of the applications in SQL Server? Which application? Note that binding data is what Microsoft considers to be the best way to show data; we can assume that any software that Microsoft develops uses controls bound to data to show the data, so saying you need to do it the same was as SQL Server does not help to explain what you need to do. Can you be more specific?
shriram iyer15y ago
my requirement is it should be done without binding ,the query result should be displayed in a wpf window in the same way as it is displayed in sql server
Crish15y ago
This Source Code is proper Example for display the sql query result in a grid ,so as to the other columns should be hidden
Suthish Nair15y ago
Shriram,

Is this a WPF thread?

Refer article by Mahesh Chand: Link