合并datagridviwe中的数据列 [英] merge data columns in datagridviwe

问题描述

hi
我想要当我从数据库中进行选择时，数据在列中指示

hi
i want When i take a select from database,data indicate in a column

ALTER PROCEDURE dbo.StoredProcedure2

AS
    select   Table1.id+Table1.name 
    from Table1

    RETURN

我使用存储过程

i used stored procedure

推荐答案

如果需要LINQ 查询以合并DataTable 的DataColumns "Id" and "Name"以获取另一个DataTable DataColumn，则可以使用以下代码.

If a LINQ query is required to merge the DataColumns "Id" and "Name" of a DataTable to get another DataTable with single DataColumn, then the following code can be used.

void Main()
{
    DataTable table1 = new DataTable();
    table1.Columns.Add("Id",typeof(string),null);
    table1.Columns.Add("Name",typeof(string),null);
    table1.Rows.Add("1","Name one");
    table1.Rows.Add("2","Name two");
    table1.Rows.Add("3","Name three");
    
    DataTable table2 = new DataTable();
    table2.Columns.Add("IdName",typeof(string),null);
    
    table1.AsEnumerable().Select (
	row => {DataRow mRow = table2.NewRow();
	mRow["IdName"]= string.Format("{0}: {1}",
		row.Field<string>("Id"),
		row.Field<string>("Name"));
	return mRow;}).CopyToDataTable(table2,
		LoadOption.OverwriteChanges);
}

//table1
//Id Name 
//1 Name one 
//2 Name two 
//3 Name three 
//
//table2
//IdName 
//1: Name one 
//2: Name two 
//3: Name three 
//</string></string>

您遇到什么问题?

这篇关于合并datagridviwe中的数据列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！