如何根据条件显示gridview行数？ [英] How to display gridview number of rows based on condition?

问题描述

大家好，



我想根据从和到日历持续时间天数显示网格视图总行数。



ex：

选自：2014年11月20日至2014年11月22日日期。



我正在计算日历选择之间的总天数。总计数是3天。

所以我想显示3行gridview。



i我计算总天数如下：

 DateTime Fromdate = Convert.ToDateTime（txtfromDate.Text）; 
 DateTime Todate = Convert.ToDateTime（txtToDate.Text）; 
 TimeSpan diff = Todate  -  Fromdate; 
  double  Nodays = diff.TotalDays +  1 ; 
 
 List< DateTime> days =  new 列表< DateTime>（）; 
  for （ int  i =  1 ; i <  = Nodays; i ++）
 {
 days.Add（Fromdate.AddDays（i））; 
} 

如何显示gridview行？



谢谢和问候，

Krishna。

解决方案

在sql查询中提及（行数）。



示例：从TOP tablename中选择TOP 3 *

大家好，



我得到了解决方案。请参阅下面的内容。谢谢大家..

 DataTable dt =  new  DataTable（ ）; 
 
 
 dt.Columns.Add（ new  DataColumn（  RowNumber， typeof （ string ）） ）; 
 dt.Columns.Add（ new  DataColumn（ 日， typeof （ string ）））; 
 dt.Columns.Add（ new  DataColumn（ 日期， typeof （ string ）））; 
 dt.Columns.Add（ new  DataColumn（ 分配， typeof （ string ）））; 
 dt.Columns.Add（ new  DataColumn（ 单人房价， typeof （ string ）））; 
 dt.Columns.Add（ new  DataColumn（ 双人房价， typeof （ string ）））; 
 dt.Columns.Add（ new  DataColumn（ 停止销售， typeof （ string ）））; 
 
 DateTime Fromdate = Convert.ToDateTime（txtfromDate.Text）; 
 DateTime Todate = Convert.ToDateTime（txtToDate.Text）; 
 TimeSpan diff = Todate  -  Fromdate; 
  double  Nodays = diff.TotalDays +  1 ; 
  int  Noday = Convert.ToInt32（Nodays）; 
列表< datetime> days =  new 列表< datetime>（）; 
  for （ int  i =  1 ; i <  = Noday; i ++）
 {
 days.Add（Fromdate.AddDays（i））; 
 
 DataRow dr =  null ; 
 
 dr = dt.NewRow（）; 
 dr [  RowNumber] = i; 
 dr [  Day] =  string  .Empty; 
 dr [ 日期] =  string  .Empty; 
 dr [ 分配] =  string  .Empty; 
 dr [ 单人房价] = 字符串 .Empty; 
 dr [ 双人间价格] = 字符串 .Empty; 
 dr [ 停止销售] = 串 .Empty; 
 dt.Rows.Add（dr）; 
 
  //  将DataTable存储在ViewState中 
 ViewState [< span class =code-string>  CurrentTable] = dt; 
 Gridview1.DataSource = dt; 
 Gridview1.DataBind（）; 
 
 < /   datetime   >  < /   datetime  >  

Hi All,

I want to display grid view total rows based on the "From and To" calendar duration days count.

ex:
Selected From : 20-Nov-2014 and To 22-Nov-2014 dates.

I am calculating total days duration between calendar selection. Total count is 3 days.
So that i want to display gridview with 3 rows.

i am calculating number of days total like below:

DateTime Fromdate = Convert.ToDateTime(txtfromDate.Text);
DateTime Todate = Convert.ToDateTime(txtToDate.Text);
TimeSpan diff = Todate - Fromdate;
double Nodays = diff.TotalDays + 1;

List<DateTime> days = new List<DateTime>();
for (int i = 1; i <= Nodays; i++)
{
    days.Add(Fromdate.AddDays(i));
}

How to display gridview rows ?

Thanks and Regards,
Krishna.

解决方案

In sql query mention(number of rows).

Example: SELECT TOP 3 * from ur tablename

Hi All,

I got solution.Please refer below. Thank you for all..

  DataTable dt = new DataTable();
           

            dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
            dt.Columns.Add(new DataColumn("Day", typeof(string)));
            dt.Columns.Add(new DataColumn("Date", typeof(string)));
            dt.Columns.Add(new DataColumn("Allocation", typeof(string)));
            dt.Columns.Add(new DataColumn("Single Room Rate", typeof(string)));
            dt.Columns.Add(new DataColumn("Double Room Rate", typeof(string)));
            dt.Columns.Add(new DataColumn("Stop Sell", typeof(string)));

            DateTime Fromdate = Convert.ToDateTime(txtfromDate.Text);
            DateTime Todate = Convert.ToDateTime(txtToDate.Text);
            TimeSpan diff = Todate - Fromdate;
            double Nodays = diff.TotalDays + 1;
            int Noday = Convert.ToInt32(Nodays);
            List<datetime> days = new List<datetime>();
            for (int i = 1; i <= Noday; i++)
            {
                days.Add(Fromdate.AddDays(i));

                DataRow dr = null;

                dr = dt.NewRow();
                dr["RowNumber"] = i;
                dr["Day"] = string.Empty;
                dr["Date"] = string.Empty;
                dr["Allocation"] = string.Empty;
                dr["Single Room Rate"] = string.Empty;
                dr["Double Room Rate"] = string.Empty;
                dr["Stop Sell"] = string.Empty;
                dt.Rows.Add(dr);
               
                //Store the DataTable in ViewState
                ViewState["CurrentTable"] = dt;
                Gridview1.DataSource = dt;
                Gridview1.DataBind();               

</datetime></datetime>

这篇关于如何根据条件显示gridview行数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！