SqlCommand cmd = new SqlCommand("select * from progressive where mem_id= '" + v_mem_id + "' and dist_code='" + v_dist_code + "'", con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
}
else
{
}
And i believe you have some values in v_mem_id and v_dist_code. As i said in comment, you dont need to pass any param as your commandstring contains the values already.