C# Read Data From Database

Posted by tech on

January 15, 2009

This code lets you read data from the database. By default, MS SQL is mainly used in tutorials regarding .NET. This code connects to a MySQL database. If you are using MS SQL, just rename the classes that starts with MySQL to SQL. This code assumes that you already have a connection object in hand.

MySqlConnection con = ...;
try {
  MySqlCommand cmd = con.createCommand();
  cmd.CommandText = "select username from users where username = 'me'";
  con.Open();
 
  MySqlDataReader dr = cmd.executeReader();
  if (dr.Read()) {
    Console.WriteLine("username = " + dr["username"]);
  }
} catch (Exception e) {
} finally {
  if (con != null) {
    con.Close();
    con.Dispose();
  }
}