in gridview database value to be retrieved and display into gridview using C#

Question

0.00/5 (No votes)

See more:

select RoomNo,Minor_Code from room where active = 'A' and Dateofcrs = '1/7/2013' and Sess = 'PM';

Output as follows for the above query

Room Course

11 EFA
22 PST
23 PH2
31 AFF
32 PSCRB
34 TFC

My gridview as follows

Room Course Room Course Room Course

11 21 31

12 22 32

13 23 33

14 24 34

in the gridview, for the course that to be retrieved from the database and display in to the gridview according to Room.

I want output as follows in the gridview(course name is retrieved from the database)

Room Course Room Course Room Course

11 EFA 21 31 AFF

12 22 PST 32 PSCRB

13 23 PH2 33

14 24 34 TFC

for that how can i do using csharp.

Rgds,
Narasiman P.

Posted 5-Jul-13 0:43am

Member 8054539

Add a Solution

Comments

jaideepsinh 5-Jul-13 7:08am

You want this type of output from you table or from where you get this type of output.

2 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)

AlexCode · Answer 1 · 2013-07-05T01:02:00

Basically you have a table that represent class rooms and you want to show which courses are being given on each room... correct?

The easiest thing is to create a DataTable that will be the datasource of your grid and fill it properly matching the existing rooms and the result of the query.
Create 2 loops of 4 and build your table validation if each room number is on the query result, if so, add the course name.

Sadique KT · Answer 2 · 2013-07-05T01:18:00

Concider DT as ur grids DataSourse,

Add your select querie's result to a collection...

C#

DataTable DT = new DataTable();

            Dictionary<int, string> dic = new Dictionary<int, string>();
            string course = "";
            foreach (DataRow r in DT.Rows)
            {
                if (dic.TryGetValue(r[0], out course))
                {
                    r[1] = course;
                }
                if (dic.TryGetValue(r[2], out course))
                {
                    r[3] = course;
                }
                if (dic.TryGetValue(r[4], out course))
                {
                    r[5] = course;
                }
            }

Hope it works..

in gridview database value to be retrieved and display into gridview using C#

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0