C# Get Info From Database

SqlConnection conn = new SqlConnection(
    "Data Source=(local);Initial Catalog=dbname;Integrated Security=true"); 
conn.open();

//This assumes you have a PK named "id"

SQLCommand command = new SQLCommand("SELECT TOP 1 * FROM table_Name ORDER BY id DESC", conn);

SQLDataReader reader = command.ExecuteReader();
reader.read();

//Reader has an indexer. So you can just use reader[0] for column 0. Or reader["columnname"];

  MySqlConnection conn = new MySqlConnection(
    "SERVER=localhost;" +
				"DATABASE=forumlogin;" +
				"UID=user;" +
				"PASSWORD=password;");
            conn.Open();
            MySqlCommand command = conn.CreateCommand();
            MySqlDataReader Reader;
            //This assumes you have a PK named "id"
            command.CommandText = "select * from info";
            Reader = command.ExecuteReader();
            while (Reader.Read())
            {
                string thisrow = "";
                for (int i = 0; i < Reader.FieldCount; i++)
                    thisrow += Reader.GetValue(i).ToString() + ",";
                listBox1.Items.Add(thisrow);
            }
            conn.Close();

//Code up here calling the DB. 

//Ok. what this does is each time it loops. It moves the reader object one place down. 
//The function returns true if there was more rows and it could move down
//false if it is out of rows. 
while(reader.read())
{
   int number = int.parse(reader["columnname"]);

//This will read the column "columnname" and stick it in the variable. my memory is foggy, I haven't done raw ADO.net in a while, but taking a column from the reader object will always return an object. And then you can parse it or tostring it from there. 

//Ok end of loop. Now it will increase the reader object row by one. 
}

MySqlConnection conn = new MySqlConnection(
    "SERVER=localhost;" +
                "DATABASE=forumlogin;" +
                "UID=user;" +
                "PASSWORD=password;");
            try
            {
                conn.Open();
                MySqlCommand command = conn.CreateCommand();
                MySqlDataReader Reader;
                //This assumes you have a PK named "id"
                command.CommandText = "select * from info";
                Reader = command.ExecuteReader();
                while (Reader.Read())
                {
                    string thisrow = "";
                    for (int i = 0; i < Reader.FieldCount; i++)
                        thisrow += Reader.GetValue(i).ToString() + ",";
                    listBox1.Items.Add(thisrow);
                }
            }
            catch(Exception ex)
            {
                #if DUBUG
                Console.WriteLine(ex.Message);
                #endif
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }