[已解决]如何显示我的循环计数错误？ [英] [Solved]How to show my loop count wrong?

问题描述

您好我在这里使用一个循环。

实际上数据库在表中有3条记录。我试图在此表中获取TO_date字段，但当我使用调试器3记录时，它只显示2条记录，我希望它不会被提取。我没有得到错误的地方？

我的代码在这里：

Hi here i am using one loop.
actually database having 3 records in table. I am trying to fetch TO_date field in this table, but it shows only 2 record when i using a debugger 3 record which i want that won't fetch. I did not get where is an error?
My code is here:

public bool countdays()
   {
       if (checkDate())
       {
           double totaldays, final = 0;

           try
           {

  countworklocation();
                DateTime dtmStart = DateTime.Parse(txtFromDate.Text);
                DateTime dtmEnd = DateTime.Parse(txtToDate.Text);
                int count = 0;
                dt.OpenCon();
               string qrydate1 = "SELECT To_Date FROM Applicant_LeaveDetails WHERE  App_Code ='" + Session["U_Emp_Code"].ToString() + "' AND Status_ID='1' AND MONTH(To_Date) = MONTH(GETDATE())";
                SqlDataReader dr1 = dt.ExecuteReader(qrydate1);
                DataTable datetable1 = new DataTable();
                datetable1.Load(dr1);

                for (int i = 0; i < datetable1.Rows.Count; i++)
                {
                    To_date = DateTime.Parse(datetable1.Rows[i]["To_Date"].ToString());
                }
                //add next day in TO_Date
                DateTime newdate = To_date.AddDays(1);
                //Substract one day from new from date
                DateTime prevnewdate = dtmStart.AddDays(-1);

推荐答案

仅回答从未答复的队列中删除：由OP解决

Answered only to remove from unanswered queue: solved by OP

这篇关于[已解决]如何显示我的循环计数错误？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！