在数据表中显示数据

问题描述:

我的数据表就像

----------
巴士
------------------
巴士1,巴士2,巴士3
------------------


我想显示像

-----------
巴士
-----------
巴士1
-----
巴士2
-----
巴士3
-----

My datatable is like

----------
BUS
------------------
bus-1,bus-2,bus-3
------------------


I want to display like

-----------
BUS
-----------
bus-1
-----
bus-2
-----
bus-3
-----

How to solve this?

玛纳斯,
可能在下面的解决方案中可让您对您的问题有所了解.
Hi Manas,
May be below solution give you some idea about your problem .
protected void Page_Load(object sender, EventArgs e)
   {
       DataTable table = new DataTable();
       table = GetTable(table);

       DataTable dtFinal = new DataTable();
       dtFinal.Columns.Add("BUS");

       foreach (var item in table.AsEnumerable())
       {
           if (item[0].ToString().Contains(","))
           {
               string[] arrTemp = item[0].ToString().Split(',');
               foreach (string itemFinal in arrTemp)
               {
                   dtFinal.Rows.Add(itemFinal);
               }
           }
       }
       GridView1.DataSource = dtFinal;
       GridView1.DataBind();
   }

   private DataTable GetTable(DataTable table)
   {
       table.Columns.Add("Header", typeof(string));

       table.Rows.Add("BUS");
       table.Rows.Add("Bus-1,Bus-2,Bus-3");
       return table;
   }



-JMD:-)



-JMD :-)


根据您的要求设计gridview并将数据表绑定到gridview.
Design gridview as per your requirement and bind datatable to gridview.


转到 datalist
并在表中添加数据...

重复列默认为零...不要更改
go for datalist
and add data are table''s in it...

repeat columns default it will be zero ...don''t change