问题描述
请注意它是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中显示数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!