如何将数据表列添加到列表行？ [英] How to add datatable columns to list rows?

问题描述

示例数据............ 
 
 Data_Table 
 [
 Col1 
 Col2 
 Col3 
] 
 _objSumList 
 [
 100 
 1.78189086914 
 2.07949829101599 
] 

数据显示如下

 Col1 Col2 Col3 
 
 100 
 1.78189086914 
 2.07949829101599 

但我需要以下数据格式



< pre lang =text> Col1 Col2 Col3

100 1.78189086914 2.07949829101599

请建议我，



谢谢。



我尝试过：



使用

  for （ int  k =  0 ; k <  _objSumList.Count; k ++）
 { 
 Data_Table.Rows.Add（_objSumList [k] .ToString（））; 
} 

解决方案

试试这个：

 namespace ConsoleApplication2 
 {
公共类DT 
 {
 public double Col1; 
 public double Col2; 
 public double Col3; 
} 
 class Program 
 {
 static void Main（string [] args）
 {
 
 DT dt = new DT（）; 
 DataTable dtb = new DataTable（）; 
 
 dtb.Columns.Add（col1）; 
 dtb.Columns.Add（col2）; 
 dtb.Columns.Add（col3）; 
 
 DataRow dr1 = dtb.NewRow（）; 
 
 dr1 [col1] = 100; 
 dr1 [col2] = 1.78189086914; 
 dr1 [col3] = 2.07949829101599; 
 dtb.Rows.Add（dr1）; 
 foreach（dtb.Rows中的DataRow dr）
 {
 dt.Col1 = Convert.ToDouble（dr [col1]）; 
 dt.Col2 = Convert.ToDouble（dr [col2]）; 
 dt.Col3 = Convert.ToDouble（dr [col3]）; 
} 
} 
} 
} 

Sample data ............

Data_Table
[
Col1
Col2
Col3
]
_objSumList
[
 100		    
 1.78189086914		
 2.07949829101599
]

Data Displaying like this

Col1                   Col2              Col3

 100		    
 1.78189086914		
 2.07949829101599

But i need data below format

Col1                   Col2              Col3

 100		    1.78189086914       2.07949829101599

Please Suggest me,

Thank you.

What I have tried:

By using

for (int k = 0; k < _objSumList.Count; k++)
{
 Data_Table.Rows.Add(_objSumList[k].ToString());
}

解决方案

try this :

namespace ConsoleApplication2
{
    public class DT
    {
        public double Col1;
        public double Col2;
        public double Col3;
    }
    class Program
    {
        static void Main(string[] args)
        {

            DT dt = new DT();
            DataTable dtb = new DataTable();

            dtb.Columns.Add("col1");
            dtb.Columns.Add("col2");
            dtb.Columns.Add("col3");

            DataRow dr1 = dtb.NewRow();

            dr1["col1"] = 100;
            dr1["col2"] = 1.78189086914;
            dr1["col3"] = 2.07949829101599;
            dtb.Rows.Add(dr1);
            foreach (DataRow dr in dtb.Rows)
            {
                dt.Col1 = Convert.ToDouble(dr["col1"]);
                dt.Col2 = Convert.ToDouble(dr["col2"]);
                dt.Col3 = Convert.ToDouble(dr["col3"]);
            }
		}
	}
}

这篇关于如何将数据表列添加到列表行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！