如何在C#中将逗号分隔的字符串添加到数据表中? [英] How to add comma separated string into datatable in c#?

问题描述

让我们考虑一下下面有两个逗号分隔的字符串.

Let's consider I have two comma separated strings as written below.

string name = "A,B,C,D";
string value = "100,200,300,400";

所以我想拆分这两个字符串，并想插入到DataTable中，如下所示.

So I want to split these two strings and want to insert into DataTable which is as shown below.

名称值

A 100

B 200

C 300

D 400

推荐答案

尝试如下操作:

DataTable table = new DataTable();
table.Columns.Add("name", typeof(string));
table.Columns.Add("value", typeof(string));

string name = "A,B,C,D";
string value = "100,200,300,400";

string[] names = name.Split(',');
string[] values = value.Split(',');

for(int i=0; i<names.Length; i++)
    table.Rows.Add(new object[]{ names[i], values[i] });

但是您应该实现一些验证代码以使其更加实用合适的.

But you should implement some validation code to make it more appropriate.

这篇关于如何在C#中将逗号分隔的字符串添加到数据表中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！