sql执行后 返回值
DBUtility dbUtility = new DBUtility();
DataSet dsInfo = new DataSet();
dbUtility.AddParameter("@DocCode", DocCode);
dbUtility.AddParameter("@DocType", DocType);
dbUtility.AddParameter("@Version", Version);
dsInfo = dbUtility.ExecuteDataSet(strSelectHisByCodeASql);
for (int i = 0; i < dsInfo.Tables[0].Rows.Count; i++)
{
MChgHistoryInfo objMInfo = new MChgHistoryInfo();
objMInfo.Version =
Int16.Parse(dsInfo.Tables[0].Rows[i][0].ToString());
objMInfo.Tab =
dsInfo.Tables[0].Rows[i][1].ToString();
objMInfo.BigItem =
dsInfo.Tables[0].Rows[i][2].ToString();
objMInfo.Item =
dsInfo.Tables[0].Rows[i][3].ToString();
objMChgHistoryInfo.Add(objMInfo);
}
大家帮帮我看看这段函数,这段函数本身执行没有问题,但是就是效率比较低。有很多数据的时候,画面上总会有一会儿停顿。我能不能在dbUtility.ExecuteDataSet(strSelectHisByCodeASql);这句话执行后以后,取得结果结果就是这个objMChgHistoryInfo值。大家有么有什么好的意见。