compare SQL Command result to a string or variable

[EDN Admin]

Hi,
how can i compare the result of my sql command to a string/variable. Below is what ive got so far.

<span style="font-size:small
sqlConn = (System.Data.SqlClient.

<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlConnection<span style="font-size:small )cm.AcquireConnection(Dts.Transaction);
<span style="font-size:small
sqlComm =

<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small new<span style="font-size:small System.Data.SqlClient.<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCommand<span style="font-size:small (<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small "SELECT
Name FROM Couriers WHERE IsActive = true"<span style="font-size:small , sqlConn);
<span style="font-size:small
sqlComm.ExecuteNonQuery();
cm.ReleaseConnection(sqlConn);


<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small string<span style="font-size:small [] listOfCouriers =
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small new<span style="font-size:small
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small string<span style="font-size:small [];
<span style="font-size:small


<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlDataReader<span style="font-size:small dr = sqlComm.ExecuteReader();
<span style="font-size:small


<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small while<span style="font-size:small (dr.Read())
<span style="font-size:small
{
listOfCouriers.Add
}
dr.Close();


View the full article