检查它是否是sqldatareader最后一个记录
技术问答
262 人阅读
|
0 人回复
|
2023-09-14
|
|
有没有办法检查我是否在最后一个记录中？
+ t; L! q2 J$ y& _$ B- \0 \
6 y, o" Y. F) U, U) a6 @7 ~- X 解决方案:
) L" U [) I* s, [$ h+ ~! O 使用此模式来识别和处理结果的最后一行：
! o; x+ i" ]: [if (reader.Read(){ var loop = true; while (loop) . Here retrive values you need e.g. var myvar = reader.GetBoolean(0)； loop = reader.Read()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；if (!loop) You are on the last record. Use values read in 1. Do some exceptions else { You are not on the last record. Process values read in 1.,e.g. myvar |
|
|
|
|
|
|
|
|
|
