I am a beginner in c# and would like to know how to loop through records in a db. It could be a recordset, etc. I need to be able to loop through items in a db table and update a filed in that row.
OdbcConnection con1 = new OdbcConnection(ConnStr);
OdbcCommand cmd1 = new OdbcCommand("SELECT * from testupdate", con8);