how to get max value

Thank you,
Govind

var con = ConfigurationManager.ConnectionStrings["Yourconnection"].ToString();

using (SqlConnection myConnection = new SqlConnection(con))
{
     string oString = "Select max(id) as id from your_table_name";
     SqlCommand oCmd = new SqlCommand(oString, myConnection);
     myConnection.Open();
     using (SqlDataReader oReader = oCmd.ExecuteReader())
     {
         while (oReader.Read())
         {
             string max = dr["id"].ToString()
         }

         myConnection.Close();
     }               
}