how to display data in datagridview

Question

1.00/5 (2 votes)

See more:

note it is windows application.

SELECT [Sch_Date] &"," & [Session] &"," & [Course] &","&[FAculty_Code] AS Message
FROM Tb_SCh_TIme_Table;

when i run the above query output shows as follows;

Message

2/25/2013,1,ARPA,AKR
2/26/2013,2,GMDSS,BAB
2/26/2013,3,MFA,BAB
2/25/2013,4,EFA,BARATH
2/26/2013,4,CTF,CBA

in the run mode i have one Button called Load and one datagridiview.

In datagridview as follows;

Name Message

when i click the Load Button, output i need as follows in datagridview;

In Datagridivew ouput i need as follows;

Name Message

AKR 2/25/2013,1,ARPA
BAB 2/26/2013,2,GMDSS
BAB 2/26/2013,3,MFA
BARATH 2/25/2013,4,EFA
CBA 2/26/2013,4,CTF

for that how can i do using csharp.

note it is windows application.

Please help me.

Posted 1-Mar-13 17:56pm

Member 8054539

Add a Solution

Comments

Karthik Harve 2-Mar-13 0:42am

Have you tried binding the datagridview ? if yes, show us how are you binding the data ?

Sergey Alexandrovich Kryukov 2-Mar-13 0:52am

What did you try? What's the problem?
—SA

Karthik Harve 2-Mar-13 0:56am

Its a repost . Display the data in datagridview for Faculty Code wise[^]

1 solution

Add a Solution

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

vpasuleti · Answer 1 · 2013-03-01T20:29:00

Solution 1

C#

private void Loadbutton_Click(object sender, EventArgs e)
        {
          var abc=select............;
            dataGridView1.DataSource = abc.Select(p=>new {p.FAculty_Code,p.Sch_Date,p.Session,p.Course});
        }

Posted 1-Mar-13 20:29pm

vpasuleti

Comments

[no name] 2-Mar-13 2:38am

private void Loadbutton_Click(object sender, EventArgs e)
{
var abc=select............;
dataGridView1.DataSource = abc.Select(p=>new {p.FAculty_Code,p.Sch_Date,p.Session,p.Course});
}

from your above why did not mention table name?

what does P stands for your above code?

Please help me.

Regards,
Narasiman P.

Please help me.

how to display data in datagridview

1 solution

Solution 1

Add your solution here

Preview 0

how to display data in datagridview

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us