IDbCommand cmd = conn.CreateCommand(); cmd.CommandText = query; dataAdapter.SelectCommand = cmd;
will work better than
dataAdapter.SelectCommand = query;