怎样判断一个select语句得到的纪录为空？

[Maggiew]

string strJudge;
strJudge="SELECT * FROM record WHERE(SWWID=334)";

// objCommand = new OleDbCommand(strJudge, objConnection);
OleDbDataAdapter objAdapter0=new OleDbDataAdapter(strJudge,objConnection);
objAdapter0.Fill(DataSet0, "record");

[panyee]

if(DataSet0.Tables["record"].Rows.Count == 0)
{
//记录为空
}

[bjy_ly]

if(DataSet0.Tables[0].Rows.Count == 0)
{
Response.Write("记录为0");
}

[liq1979]

SqlDataReader dr = new SqlDataReader(strJudge,objConnection);
int rowcount = 0;
while(dr.Read())
{
rowcount++;
}
if(rowcount==0)
{
Response.Write("没有记录!");
}

[robin_xin_xin]

同意楼上