我这样作是不是效果太低,一直访问数据库,但我不知道如何写好:while (1==1) { strSql="Select * From T_Message_Buffer where ServiceID='941031552'and status=0 order by id"; objAdapter=new SqlDataAdapter(strSql,objConnection); objAdapter.Fill(objDataSet,"T_Message_Buffer"); objTable=objDataSet.Tables["T_Message_Buffer"]; for (i=0;i<objTable.Rows.Count;i++) {
{
strSql="Select * From T_Message_Buffer where ServiceID='941031552'and status=0 order by id";
objAdapter=new SqlDataAdapter(strSql,objConnection);
objAdapter.Fill(objDataSet,"T_Message_Buffer");
objTable=objDataSet.Tables["T_Message_Buffer"];
for (i=0;i<objTable.Rows.Count;i++)
{
//处理 }
}