[C#][SQL] 是否有查詢到資料

測試SQL query 是否有查詢到資料

private bool hasValue(string eqID)
{
myConn.ConnectionString = "data source=localhost;Initial Catalog=DB;User ID=USER;Password=1234";
myConn.Open();
string preStrSQL = "SELECT * FROM table WHERE ID ='AAA'";
SqlCommand mytestcmd = new SqlCommand(preStrSQL, myConn);
SqlDataReader myReader = mytestcmd.ExecuteReader();

if (myReader.HasRows)
{
myConn.Close();
return true;
}
else
{
myConn.Close();
return false;
}
}