narasiman rao

narasiman rao

  • NA
  • 519
  • 768.6k

Display the data in datagridview for Faculty Code wise

Mar 1 2013 11:11 PM
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.


Answers (1)