SqlReader : -------------------- while( myReader.Read()) { // getting records statements... }------------in addition if you want move records up and down ,you'd better use datatable Cache Data,not SqlDataReader;in your code above, you not release the SqlConnection object after finish retrieve data!//like this : try{}catch{}finally{mySqlConnection.Close();}
--------------------
while( myReader.Read())
{
// getting records statements...
}------------in addition
if you want move records up and down ,you'd better use datatable Cache Data,not SqlDataReader;in your code above, you not release the SqlConnection object after finish retrieve data!//like this :
try{}catch{}finally{mySqlConnection.Close();}
实际上用reader来作这个事不太好,你可以明确的从数据库里找到一个你要的记录,而不用reaer来移动记录.