ASP.net equivalent for @mysql_query($query);

$query = "SELECT DISTINCT * FROM itl WHERE city='$city2' AND
state='$state2'";
$temp = @mysql_query($query);
$result = $mysql_fetch_row($temp);
if (!$result) {
   do something
}
else {
    do something else
}

Sorry , this is correct :
$query = "SELECT DISTINCT * FROM itl WHERE city='$city2' AND
state='$state2'";
$temp = @mysql_query($query);
$result = @mysql_fetch_row($temp);
if (!$result) {
do something
}
else {
do something else

I meant to say that I need the asp.net "C#" equivalent to the posted PHP code

This is all you need :)
http://www.codeproject.com/KB/aspnet/DataAccessLayerForMySQL.aspx
 ex :

using MySql.Data.MySqlClient;
using MySql.Data.Types;
using System.Data;
namespace Website.Data
{
    class Class1
    {
        private void abc()
        {
            MySqlDataReader dr = DataAccess.ExecuteReader(CommandType.Text, "SELECT DISTINCT * FROM itl");
            if (dr.Read())
            {
                //do something
            }
            else
            {
                //do something
            }
            
        }
    }
}
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:

we are almost there HoangTuDauMat:... forgot to mentioned that I am actually using SQL Server 2005, "NOT" mysql.

change your sql query to :
SELECT DISTINCT count(*) FROM  itl WHERE ...

I tried using something like the following and got the error message

SqlDataReader  dr = DataAccess.ExecuteReader(CommandType.Text, "SELECT DISTINCT count(*) FROM itl itl WHERE city='$city2' AND state='$state2'");
        if (dr.Read())
        {
            //do something
        }
        else
        {
            //do something
        }


Compiler Error Message: CS0103: The name 'DataAccess' does not exist in the current context

using System;
using System.Data;
using System.Data.SqlClient;
namespace DataLayer
{
    /// <summary>
    /// Summary description.
    /// </summary>
    public class DataAccess
    {
        #region Variables
        private static string m_sOleDbConnectionString = "Data Source=servername;Initial Catalog=databasename;User Id=username;Password=password;";
        public static SqlConnection CurrentOleDbConnection;
        #endregion
        #region constructor
        public DataAccess()
        {
            //
            // TODO: Add constructor logic here
            //
        }
        #endregion
        #region Properties
        /// <summary>
        ///
        /// </summary>
        public static string OleDbConnectionString
        {
            get { return m_sOleDbConnectionString; }
            set { m_sOleDbConnectionString = value; }
        }
        #endregion
        #region Method
        /// <summary>
        ///
        /// </summary>
        public void OpenConnection()
        {
            try
            {
                if (CurrentOleDbConnection == null || CurrentOleDbConnection.State != ConnectionState.Open)
                {
                    CurrentOleDbConnection = new SqlConnection(m_sOleDbConnectionString);
                    // SMAPGlobal.WriteLog("Connection String: " + CurrentOleDbConnection.ConnectionString);
                    CurrentOleDbConnection.Open();
                    //SMAPGlobal.WriteLog("Connect to OleDb Database successfully");
                }
            }
            catch (Exception ex)
            {
                //SMAPGlobal.WriteLog("Can not connect to database. Result = [" + ex.Message + "]");
                throw ex;
            }
        }
        /// <summary>
        ///
        /// </summary>
        public void CloseConnection()
        {
            try
            {
                if (CurrentOleDbConnection != null)
                {
                    if (CurrentOleDbConnection.State == ConnectionState.Open)
                        CurrentOleDbConnection.Close();
                    CurrentOleDbConnection.Dispose();
                    CurrentOleDbConnection = null;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="sSQL"></param>
        /// <returns></returns>
        public SqlDataReader ExecuteReader(string sSQL)
        {
            try
            {
                OpenConnection();
                SqlCommand cmd = new SqlCommand(sSQL, CurrentOleDbConnection);
                SqlDataReader reader = cmd.ExecuteReader();
                cmd.Dispose();
                return reader;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        ///
        /// </summary>
        /// <param name="sSQL"></param>
        /// <returns></returns>
        public int ExecuteNonQuery(string sSQL)
        {
            try
            {
                int iResult = -1;
                OpenConnection();
                SqlCommand cmd = new SqlCommand(sSQL, CurrentOleDbConnection);
                iResult = cmd.ExecuteNonQuery();
                cmd.Dispose();
                return iResult;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                CloseConnection();
            }
        }
        #endregion

    }
}

sorry my I still can't seem to this the about to work for what I need to do.... in a nut shell this is all I need to do... but I keeping getting a error on the "da.Read()" part on line 7

        SqlConnection con2 = new SqlConnection();
        con2.ConnectionString = "Data Source=myConnectionstring...blah blah";

        string str = "SELECT DISTINCT count(*) FROM itl itl WHERE city='$city2' AND state='$state2'";
        con2.Open();
        SqlDataAdapter da = new SqlDataAdapter(str, con2);

        if (da.Read()) // i just want to test if a matching value was returned that I all.... very short and simply no need for looong lines of code
        {
            //do something
        }
        else
        {
            //do something
        }