How can I change these VB.net to C# codes?

[ATC]

I have the following VB.net codes: da = New OleDbDataAdapter(strSQL, dbConn) dt = New DataTable da.Fill(dt) Dim rows As DataRow cnt = dt.Rows.Count() If cnt > 0 Then For Each rows In dt.Rows Total += rows.Item("Total") Next End If I changed to these C#: da = new OleDbDataAdapter(strSQL, CGlobal.dbConn); dt = new DataTable(); da.Fill(dt); cnt = dt.Rows.Count; DataRow rows = default(DataRow); if (cnt > 0) { foreach (rows in dt.Rows) Total += rows.Item("Total"); } And I have the error in in above, can anyone help to correct my C#? Thank :doh:

[Pete OHanlon]

When you use a foreach, you need to say what the type is; hence foreach (DataRow rows in dt.Rows).

Deja View - the feeling that you've seen this post before.

My blog | My articles | MoXAML PowerToys

[ATC]

I did try before & had 2 errors: cnt = dt.Rows.Count; DataRow rows = default(DataRow); foreach (DataRow rows in dt.Rows) Total += rows.Item("Total"); By any chance you know how to fix them? What I need to get values from column 'Total' of those selected row Thanks :doh:

[DaveyM69]

rows is already defined in the line above the foreach. Why not use row seing as it will represent just one row.

foreach (DataRow row in dt.Rows)
Total += row.Item("Total");

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

[ATC]

I did try & have small error from Item, but I think I can fix it by using array for the column. Thanks,

[Paul Conrad]

ATC wrote:

have the error in in above

Be more descriptive :|

"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

[Dave Doknjas]

da = new OleDbDataAdapter(strSQL, dbConn); dt = new DataTable(); da.Fill(dt); DataRow rows = null; cnt = dt.Rows.Count(); if (cnt > 0) { foreach (DataRow rowsWithinLoop in dt.Rows) { rows = rowsWithinLoop; Total += rowsWithinLoop["Total"]; } } David Anton http://www.tangiblesoftwaresolutions.com C++ to C# Converter C++ to VB Converter C++ to Java Converter VB & C# to Java Converter Java to VB & C# Converter Instant C#: VB to C# converter Instant VB: C# to VB converter Instant C++: convert VB, C#, or Java to C++/CLI

[Pete OHanlon]

Item is an indexed property, so you use

Total += rows.Item["Total"];

C# uses square brackets [ and ] for indexers.

Deja View - the feeling that you've seen this post before.

My blog | My articles | MoXAML PowerToys