如何在C#/asp.net中比较数据表中的行并操作它以特定的格式显示

本文关键字：操作 显示 格式 数据表 asp 比较 net | 更新日期: 2023-09-27 18:25:32

我有一个数据表，有4列。在这10列中，第一列包含日期。表中的数据格式为：I/p

"15/12/2010",username,24,No
"16/12/2010",username,24,No
"17/12/2010",username,24,No
"18/12/2010",username,24,No
"19/12/2010",username,24,No
"20/12/2010",username,25,No
"21/12/2010",username,24,yes
"22/12/2010",username,24,No
"23/12/2010",username,24,No
"24/12/2010",username,24,No
"25/12/2010",username,24,No
"26/12/2010",Prakhar,24,No
"27/12/2010",username,24,No
"28/12/2010",username,24,No

我们必须将o/p与中继器绑定。对于上述i/p，输出应为：

O/P
"15/12/2010 - 20/12/2010",username,24,No
"21/12/2010 - 21/12/2010",username,24,Yes
"22/12/2010 - 25/12/2010",username,24,no
"26/12/2010 - 26/12/2010",username,24,no
"27/12/2010 - 28/12/2010",username,24,no

也就是说，我们正在对所有相应列值匹配的日期进行组合。我们必须为它编写一个c#代码。

如何在C#/asp.net中比较数据表中的行并操作它以特定的格式显示

First I have created a new Datatable for our final result:
DataTable dtInventoryTable = new dtInventoryTable();
dtInventoryTable.Columns.Add("RateDate", typeof(string));
dtInventoryTable.Columns.Add("RatePlanId", typeof(string));
dtInventoryTable.Columns.Add("RoomTypeId", typeof(string));    
private DataTable DisplayInventoryDetails(DataTable dtInventoryDetail)
{
for (int i = 0; i < dtInventoryDetail.Rows.Count; i++)
{
String[] row = new String[dtInventoryDetail.Columns.Count];
String[] row1 = new String[dtInventoryDetail.Columns.Count];
string str=string.Empty;
int h=0;
str = dtInventoryDetail.Rows[i][0].ToString() + " - " +dtInventoryDetail.Rows[i]0].ToString();                                                                                  
for (int j = i+1;j< dtInventoryDetail.Rows.Count; j++)
{                
for (int x = 1; x < dtInventoryDetail.Columns.Count; x++)
{
 row[x] = dtInventoryDetail.Rows[i][x].ToString();
 }
 for (int y = 1; y < dtInventoryDetail.Columns.Count; y++)
 {
 row1[y] = dtInventoryDetail.Rows[j][y].ToString();
 }
 bool result = ArraysEqual(row, row1);
 if (!result)
 {
 dtInventoryTable = GetRoomRateTable(row, str);
 i = j-1;
 h = j;
 break;
 }
 else
 str= dtInventoryDetail.Rows[i][0].ToString() + " - " + dtInventoryDetail.Rows[j][0].ToString();
 h = j;
 }
 }
 if (h >= dtInventoryDetail.Rows.Count-1)
 {
 dtInventoryTable = GetRoomRateTable(row, str);
  break;
  }
  }
  return dtInventoryTable;
  }  
   private DataTable GetRoomRateTable(String[] row,string str)
  {
    row[0] = str;
    dtInventoryTable.LoadDataRow(row, true);
    return dtInventoryTable;
  }
相关文章：