Ms Access Data in DataGridView like.......

Question

1.00/5 (2 votes)

See more:

hi there,

i have a table with data in Ms Access like....

CountryName Medal

India        Gold
USA        Silver
China        Gold
India        Gold
India        Gold
USA        Bronze
India        Silver
USA        Gold
USA        Silver
India        Bronze

now my question is , i want this table data in gridview like......

country      Gold      Silver      Bronze
India               3         1            1
USA                1         2            1
China              1         0             0

thanks

Posted 20-Sep-12 1:26am

Aniruddh Bhatt

Updated 20-Sep-12 16:09pm

v2

Add a Solution

Comments

[no name] 20-Sep-12 7:33am

Okay good for you. Please come back when you have a question to ask.

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

Dave Kreskowiak · Answer 1 · 2012-09-20T01:40:00

Solution 1

Permission granted! Please, proceed.

Or did you have a question in there noboday can find?? What part of this are you having a problem with?

Nobody is just going to give you code. This little assignment reeks of being homework and we're not here to do your homework for you so you can pass a class that you don't deserve to pass.

Posted 20-Sep-12 1:40am

Dave Kreskowiak

Comments

Aniruddh Bhatt 20-Sep-12 7:53am

i am only able to do this code i want only idea not full code.how can i count medals state wise and only print one state one time.

ss = "Select * from winner"
com = New OleDbCommand(ss, con)
con.Open()
dr = com.ExecuteReader
While dr.Read()
i = DataGridView1.Rows.Add(+1)
If dr(1) = "Gold" Then
g = g + 1
ElseIf dr(1) = "Silver" Then
s = s + 1
ElseIf dr(1) = "Bronze" Then
b = b + 1
End If

DataGridView1.Rows(i).Cells(1).Value = dr(0)
DataGridView1.Rows(i).Cells(2).Value = g
DataGridView1.Rows(i).Cells(3).Value = s
DataGridView1.Rows(i).Cells(4).Value = b
End While
con.Close()

Dave Kreskowiak 20-Sep-12 12:51pm

Doesn't the layout of your result table above suggest that you would need a two dimensional array to hold this data?? Or at least a collection of objects that holds a country name and 3 values??

No, I'm not going to write your code for you.

Dave Kreskowiak 24-Sep-12 0:51am

I know that. But I'm also not going to give him the answer to his homework assignment.

BheemG · Answer 2 · 2012-09-20T19:49:00

Hi
I just generated the sql query which yeilds the required result.

SQL

SELECT Name,
       (SELECT COUNT(medal)
          FROM  [TantraCAD].[dbo].[Sample] as Sample_1  Where Medal = 'Gold' and Sample_1.Name = Simplu.Name) AS "Gold",
          (SELECT COUNT(medal)
          FROM  [TantraCAD].[dbo].[Sample] as Sample_1 Where Medal = 'Silver' and Sample_1.Name = Simplu.Name) AS "Silver",
          (SELECT COUNT(medal)
          FROM  [TantraCAD].[dbo].[Sample] as Sample_1 Where Medal = 'Bronze' and Sample_1.Name = Simplu.Name) AS "Bronze"
  FROM [TantraCAD].[dbo].[Sample]
GROUP BY
  Name

Where sample is the table name try this and let me know.

Happy coding...

xErvender · Answer 3 · 2012-09-23T18:04:00

Solution 3

use sql query

select count(Columnname) from table group by (columnname)

Posted 23-Sep-12 18:04pm

xErvender

Comments

Aniruddh Bhatt 25-Sep-12 1:02am

not working

xErvender 25-Sep-12 1:22am

select count(*),Medal from table group by medal

Ms Access Data in DataGridView like.......

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us