如何在datagridview中显示数据 [英] how to display data in datagridview

问题描述

请注意它是Windows应用程序。



SELECT [Sch_Date]&，&[Session]&，&[Course]&，& [FAculty_Code] AS消息

来自Tb_SCh_TIme_Table;



当我运行上述查询输出时显示如下;



留言



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





在运行模式下，我有一个名为Load的按钮和一个datagridiview 。



在datagridview中如下;



姓名消息



当我点击加载按钮时，输出我需要在datagridview中如下;



在Datagridivew输出中我需要如下;



姓名信息



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





我怎样才能使用csharp。



请注意它是Windows应用程序。



请帮助我。

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.

推荐答案

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});
        }

这篇关于如何在datagridview中显示数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！