在读者登录图书馆网页以后,Gridview 进行绑定,如果发现有过期的书籍(当前时间>应还时间)就将数据插入"惩罚"表里
,这样的情况,如果只有一条数据那是很好处理的,但是如果有两条或者更多,就难办了,
尝试过用for(i=0;i<x;i++)这样的语句不行,希望大侠帮忙.        public void insertPunishment()
        {
            string ReaderNumber = Session["ReaderNumber"].ToString();           //获取读者条形码
            DateTime now = DateTime.Now.Date;            string _chaoqi = "select * from Lib_BookBorrow where  ReaderNumber='" + ReaderNumber + "'and (('" + now + "' > ShouldReturnTime and IsReturn='0' ) )";
            int i = DataOperate.seleSQL(_chaoqi);
            int j = 0;
            for (j = 0; j <= i; j++)
            {
                SQLiteDataReader chaoqi = DataOperate.getRow(_chaoqi);                if (chaoqi.Read())
                {
                    string _shouldReturnTime = chaoqi["ShouldReturnTime"].ToString();
                    shouldReturnTime = Convert.ToDateTime(_shouldReturnTime);
                    string _realReturnTime = chaoqi["RealReturnTime"].ToString();
                    realReturnTime = Convert.ToDateTime(_realReturnTime);
                    string bookBarCode = chaoqi["BookBarCode"].ToString();
                    DateTime today = DateTime.Now.Date;
                    TimeSpan _overdueDay = today - shouldReturnTime;
                    int shouldPayMoney = _overdueDay.Days;                    int isDispose = Convert.ToInt32(0);
                    int isReturn = Convert.ToInt32(chaoqi["IsReturn"]);
                    chaoqi.Close();
                    if (isReturn == 1)
                    {
                        TimeSpan _isCouldReturn = realReturnTime - shouldReturnTime;
                        shouldPayMoney = _isCouldReturn.Days;
                    }                    string sql = "select IsDispose from [Lib_Punishment] where BookBarCode='" + bookBarCode + "'and ReaderNumber='" + ReaderNumber + "'and  IsDispose='0'";
                    SQLiteDataReader dr = DataOperate.getRow(sql);
                    if (dr.Read())
                    {
                        dr.Close();                    }
                    else
                    {                        string sql2 = "insert into [Lib_Punishment] values(null,'" + bookBarCode + "','" + ReaderNumber + "','" + shouldPayMoney + "','" + isDispose + "')";
                        DataOperate.execSQL(sql2);
                    }                }                else
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<Script>alert('未找到!')</Script>");            }        }