how to get sql values in datagrid

Question

0.00/5 (No votes)

See more:

hi all,
i am trying to get the details from sql database to in my WPF application.
but tables fields are not getting in my application regrading in this code

XML

private void button1_Click(object sender, RoutedEventArgs e)
        {
            DataClasses1DataContext display = new DataClasses1DataContext();
            var q = from a in display.GetTable<EMP>()
                    select a;
            dataGrid1.ItemsSource = q;

}
is there any mistake ,is yes please any body help to me
thanks in advance........

Posted 18-May-12 1:31am

Unareshraju

Add a Solution

3 solutions

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)

Prasad_Kulkarni · Answer 1 · 2012-05-18T01:33:00

Solution 1

Please check following CP Articles:

In this article you will get information about how to display data from a SQL Server database table in a WPF DataGrid control:
Data binding in WPF DataGrid control using SQL Server database[^]
DataGrid in WPF using SQL Server Compact 3.5 Sp1[^]

Posted 18-May-12 1:33am

Prasad_Kulkarni

Unareshraju · Answer 2 · 2012-05-18T03:32:00

Solution 3

i changed in xaml code very simple............i was confused...

<dategird1 itemsource="{Binding}">

Posted 18-May-12 3:32am

Unareshraju

preet88 · Answer 3 · 2012-05-18T02:03:00

Solution 2

hi,
please use display member and value member property and databind function if it is in asp.net .

use following for window forms..
dataGrid1.DataMember="column name"; that you want to display

write this line.
If this Doesn't works then please let us know about the error as well that is coming.

Thanks.

Posted 18-May-12 2:03am

preet88

Updated 18-May-12 2:05am

v2

Comments

Unareshraju 18-May-12 8:41am

hi preet**,
thanks for reply.........actually here
dataGrid1.(not displaying DATAMEMBER") ..only teble values are not displayed in datagrid....not showing any error.

preet88 18-May-12 13:40pm

aah! sorry i was thinking it in a wrong way.
i think in this syntax you can also access the table
for eg from a in display.sometablename
select a;

here sometablename refers to a ienumerable class which has a same name that your table has in database and i hope that it may solve your problem i'm not sure but you can give a try