ageSizeParameter);
SqlParameter recordCountParameter = new SqlParameter("@recordCount",
SqlDbType.Int);
recordCountParameter.Direction = ParameterDirection.ReturnValue;
sqlCommand.Parameters.Add(recordCountParameter);
connection.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
sqlDataAdapter.Fill(dataSet);
recordCount = Convert.ToInt32(recordCountParameter.Value);
}
}
catch (Exception)
{
dataSet = null;
recordCount = 0;
}
return dataSet;
}
总结：个人认为这个存储过程在小型项目中，还是比较实用的。发现问题请一定直言不讳，欢迎讨论交流。
|