January 9, 2009 08:50pm pst

1. TheLearn... 9,225
2. Juan_Bar... 7,300
3. Dhaest 6,650
4. Fernando... 6,400
5. daveamour 6,150
6. psasik 6,000
7. emoreau 5,600
8. brawney 5,125
9. Idle_Mind 3,600
10. webtubbs 3,375
11. ororiole 3,200
12. Tiggerito 3,050
13. Rhino1272 2,800
14. PaulHews 2,500
14. mlmcc 2,500
16. MrClyfar 2,000
16. OBonio 2,000
16. planocz 2,000
16. Andornagy 2,000
16. vadimrapp1 2,000
16. Solar_Flare 2,000
16. Arlowin 2,000
16. JPJ78 2,000
16. QuintainT 2,000
16. C_Sharp... 2,000
16. tigin44 2,000
16. topdog770 2,000
16. scgstuff 2,000
16. AndyAins... 2,000
16. pivar 2,000
16. ozo 2,000

1. TheLearn... 674,059
2. jaime_oliv... 554,772
3. Fernando... 407,608
4. gregoryyo... 219,815
5. Dhaest 219,448
6. p_davis 213,900
7. Idle_Mind 197,607
8. angelIII 182,280
9. emoreau 174,984
10. ragi0017 139,083
11. graye 137,680
12. philipjonat... 137,045
13. gauthampj 127,805
14. GreenGho... 124,730
15. JimBrandley 117,431
16. ShazbotOK 110,072
17. ororiole 109,714
18. prairiedog 105,373
19. jcoehoorn 103,915
20. surajguptha 100,150
21. dstanley9 100,134
22. naspinski 92,990
23. jpaulino 89,789
24. Juan_Bar... 87,340
25. BondinASP 86,307

06.25.2008 at 04:20AM PDT, ID: 23514013

	[x] Attachment Details

Get value of ID Column in dataGridView ForEach?

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.3

Zones:

Microsoft Visual C#.Net, C# Programming Language, Visual Studio

Tags:

C#

I have some code that I would like to execute for each row in a dataGridView that I am populating from a database. Does anyone know how I can get the value of the ID Column for each row for this foreach? Any help is greatly appreciated.

Here is my code if you need it:

(You may notice that the Select Statement and columns in the dataGridView don't add up... I accidentally deleted part of the Select Statement, so I'll be fixing that today... In the meantime what is there is correct...

Thanks Again,

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:

           
           
             try
{
//Populate the Collection DataGridView
string conString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Environment.CurrentDirectory + @"\DB.accdb;Jet OLEDB:Database Password=xxxx;";
 
// create an open the connection
OleDbConnection conn = new OleDbConnection(conString);
OleDbCommand command = new OleDbCommand();
command = conn.CreateCommand();
 
// create the DataSet
DataSet ds = new DataSet();
 
// run the query
command.CommandText = "SELECT ID AS [#], CTitle AS [Title], CType AS [Type], CValue AS [Value] FROM Table1 WHERE Tab = 'Tab1';";
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter = new OleDbDataAdapter(command);
adapter.Fill(ds);
 
// close the connection
conn.Close();
 
bindingSource.DataSource = ds.Tables[0];
 
dataGridView1.DataSource = bindingSource;
 
//Set Value Column Format to Currency
dataGridView1.Columns["Value"].DefaultCellStyle.Format = "c";
 
//Count the number of rows
try
{
int CountString;
CountString = bindingSource.Count;
Label1.Text = CountString + "";
}
catch
{
}
 
//Total the value of results
try
{
String valueString = ds.Tables[0].Compute("Sum(Value)", String.Empty).ToString();
decimal valueString2 = Convert.ToDecimal(valueString);
String valueString3 = String.Format("{0:C}", valueString2);
if (valueString != "")
{
Label2.Text = valueString3;
}
}
catch
{
}
 
// set the size of the dataGridView Columns
this.dataGridView1.Columns[0].Width = 50;
this.dataGridView1.Columns[1].Visible = false;
this.dataGridView1.Columns[2].Width = 311;
this.dataGridView1.Columns[3].Width = 50;
this.dataGridView1.Columns[4].Width = 50;
this.dataGridView1.Columns[5].Width = 100;
this.dataGridView1.Columns[6].Width = 100;
this.dataGridView1.Columns[7].Width = 100;
this.dataGridView1.Columns[8].Width = 100;
this.dataGridView1.Columns[9].Width = 100;
 
//Sort on the Title Column
DataGridViewColumn sortColumn = dataGridView1.Columns[2];
ListSortDirection direction;
direction = ListSortDirection.Ascending;
dataGridView1.Sort(sortColumn, direction);
 
//Set the Selected Property of the First Row to False
dataGridView1.Rows[0].Selected = false;
 
//Clear selection in dataGridView
dataGridView1.ClearSelection();
dataGridView1.CurrentCell = null;
}
catch
{
}

           
         

#	Title
1	Problem with filtering a databound Data…
2	populate combobox in a datagridview i…
3	loading a datagridview loading from an…
4	DataGridView C# .NET Cell values fr…
5	How to reorder rows in datagridview
6	SSIS foreach loop