blocks|key|1832929|text|要添加行，请执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1832930|DataRow+row+=+dt.NewRow();
row["Name"]+=+"Ravi";
row["Marks"]+=+500;
dt.Rows.Add(row);|code-block|syntax|javascript|1832931|要查看结构，请执行以下操作：|1832932|Table.Columns|1832933|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

To add a row:

<pre><code>DataRow row = dt.NewRow();
row["Name"] = "Ravi";
row["Marks"] = 500;
dt.Rows.Add(row);
</code></pre>

To see the structure:

<pre><code>Table.Columns
</code></pre>

blocks|key|2047179|text|为此，您必须将数据行添加到datatable中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2047180|//+Creates+a+new+DataRow+with+the+same+schema+as+the+table.
DataRow+dr+=+dt.NewRow();

//+Fill+the+values
dr["Name"]+=+"Name";
dr["Marks"]+=+"Marks";

//+Add+the+row+to+the+rows+collection
dt.Rows.Add+(+dr+);|code-block|syntax|javascript|2047181|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You have to add datarows to your datatable for this.

<pre><code>// Creates a new DataRow with the same schema as the table.
DataRow dr = dt.NewRow();

// Fill the values
dr["Name"] = "Name";
dr["Marks"] = "Marks";

// Add the row to the rows collection
dt.Rows.Add ( dr );
</code></pre>

blocks|key|1833023|text|代码如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1833024|DataTable+dt+=+new+DataTable();+
dt.Clear();
dt.Columns.Add("Name");
dt.Columns.Add("Marks");
DataRow+_ravi+=+dt.NewRow();
_ravi["Name"]+=+"ravi";
_ravi["Marks"]+=+"500";
dt.Rows.Add(_ravi);|code-block|syntax|javascript|1833025|要查看结构，或者我将其重新表述为模式，可以通过执行以下操作将其导出为XML文件。|1833026|要仅导出架构/结构，请执行以下操作：|1833027|dt.WriteXMLSchema("dtSchemaOrStructure.xml");|1833028|此外，您还可以导出数据：|1833029|dt.WriteXML("dtDataxml");|1833030|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Here's the code:

<pre><code>DataTable dt = new DataTable(); 
dt.Clear();
dt.Columns.Add("Name");
dt.Columns.Add("Marks");
DataRow _ravi = dt.NewRow();
_ravi["Name"] = "ravi";
_ravi["Marks"] = "500";
dt.Rows.Add(_ravi);
</code></pre>

To see the structure, or rather I'd rephrase it as schema, you can export it to an XML file by doing the following.

To export only the schema/structure, do:

<pre><code>dt.WriteXMLSchema("dtSchemaOrStructure.xml");
</code></pre>

Additionally, you can also export your data:

<pre><code>dt.WriteXML("dtDataxml");
</code></pre>

blocks|key|2047340|text|除了其他答案之外。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2047341|如果您控制DataTable的结构，则可以使用快捷方式添加行：|2047342|//假设您有一个示例中定义的数据表，名为dt+dt.Rows.Add("Name"，"Marks")；|2047343|DataRowCollection.Add()方法有一个接受对象参数数组的重载。此方法允许您根据需要传递任意多个值，但它们的顺序必须与表中定义的列的顺序相同。|2047344|因此，虽然这是一种方便的添加行数据的方法，但使用它可能会有风险。如果表结构发生变化，您的代码将失败。|2047345|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

In addition to the other answers.

If you control the structure of the DataTable there is a shortcut for adding rows:

// Assume you have a data table defined as in your example named dt
dt.Rows.Add("Name", "Marks");

The DataRowCollection.Add() method has an overload that takes a param array of objects. This method lets you pass as many values as needed, but they must be in the same order as the columns are defined in the table. 

So while this is a convenient way to add row data, it can be risky to use. If the table structure changes your code will fail.

blocks|key|1833228|text|您也可以传入一个对象数组，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1833229|DataTable+dt+=+new+DataTable();
dt.Clear();
dt.Columns.Add("Name");
dt.Columns.Add("Marks");
object[]+o+=+{+"Ravi",+500+};
dt.Rows.Add(o);|code-block|syntax|javascript|1833230|或者甚至是：|1833231|dt.Rows.Add(new+object[]+{+"Ravi",+500+});|1833232|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can also pass in an object array as well, like so:

<pre><code>DataTable dt = new DataTable();
dt.Clear();
dt.Columns.Add("Name");
dt.Columns.Add("Marks");
object[] o = { "Ravi", 500 };
dt.Rows.Add(o);
</code></pre>

Or even:

<pre><code>dt.Rows.Add(new object[] { "Ravi", 500 });
</code></pre>

blocks|key|2047452|text|//+Create+a+DataTable+and+add+two+Columns+to+it
DataTable+dt=new+DataTable();
dt.Columns.Add("Name",typeof(string));
dt.Columns.Add("Age",typeof(int));

//+Create+a+DataRow,+add+Name+and+Age+data,+and+add+to+the+DataTable
DataRow+dr=dt.NewRow();
dr["Name"]="Mohammad";+//+or+dr[0]="Mohammad";
dr["Age"]=24;+//+or+dr[1]=24;
dt.Rows.Add(dr);

//+Create+another+DataRow,+add+Name+and+Age+data,+and+add+to+the+DataTable
dr=dt.NewRow();
dr["Name"]="Shahnawaz";+//+or+dr[0]="Shahnawaz";
dr["Age"]=24;+//+or+dr[1]=24;
dt.Rows.Add(dr);

//+DataBind+to+your+UI+control,+if+necessary+(a+GridView,+in+this+example)
GridView1.DataSource=dt;
GridView1.DataBind();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2047453|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>// Create a DataTable and add two Columns to it
DataTable dt=new DataTable();
dt.Columns.Add("Name",typeof(string));
dt.Columns.Add("Age",typeof(int));

// Create a DataRow, add Name and Age data, and add to the DataTable
DataRow dr=dt.NewRow();
dr["Name"]="Mohammad"; // or dr[0]="Mohammad";
dr["Age"]=24; // or dr[1]=24;
dt.Rows.Add(dr);

// Create another DataRow, add Name and Age data, and add to the DataTable
dr=dt.NewRow();
dr["Name"]="Shahnawaz"; // or dr[0]="Shahnawaz";
dr["Age"]=24; // or dr[1]=24;
dt.Rows.Add(dr);

// DataBind to your UI control, if necessary (a GridView, in this example)
GridView1.DataSource=dt;
GridView1.DataBind();
</code></pre>

blocks|key|1833295|text|DataTable+dt=new+DataTable();
Datacolumn+Name+=+new+DataColumn("Name");
Name.DataType=+typeoff(string);
Name.AllowDBNull=false;+//set+as+null+or+not+the+default+is+true+i.e+null
Name.MaxLength=20;+//sets+the+length+the+default+is+-1+which+is+max(no+limit)
dt.Columns.Add(Name);
Datacolumn+Age+=+new+DataColumn("Age",+typeoff(int));`

dt.Columns.Add(Age);

DataRow+dr=dt.NewRow();

dr["Name"]="Mohammad+Adem";+//+or+dr[0]="Mohammad+Adem";
dr["Age"]=33;+//+or+dr[1]=33;
dt.add.rows(dr);
dr=dt.NewRow();

dr["Name"]="Zahara";+//+or+dr[0]="Zahara";
dr["Age"]=22;+//+or+dr[1]=22;
dt.rows.add(dr);
Gv.DataSource=dt;
Gv.DataBind();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1833296|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>DataTable dt=new DataTable();
Datacolumn Name = new DataColumn("Name");
Name.DataType= typeoff(string);
Name.AllowDBNull=false; //set as null or not the default is true i.e null
Name.MaxLength=20; //sets the length the default is -1 which is max(no limit)
dt.Columns.Add(Name);
Datacolumn Age = new DataColumn("Age", typeoff(int));`

dt.Columns.Add(Age);

DataRow dr=dt.NewRow();

dr["Name"]="Mohammad Adem"; // or dr[0]="Mohammad Adem";
dr["Age"]=33; // or dr[1]=33;
dt.add.rows(dr);
dr=dt.NewRow();

dr["Name"]="Zahara"; // or dr[0]="Zahara";
dr["Age"]=22; // or dr[1]=22;
dt.rows.add(dr);
Gv.DataSource=dt;
Gv.DataBind();
</code></pre>

blocks|key|2047494|text|DataTable+dt=new+DataTable();
DataColumn+Name+=+new+DataColumn("Name",typeof(string));+

dt.Columns.Add(Name);
DataColumn+Age+=+new+DataColumn("Age",+typeof(int));`

dt.Columns.Add(Age);

DataRow+dr=dt.NewRow();

dr["Name"]="Kavitha+Reddy";+
dr["Age"]=24;+
dt.add.Rows(dr);
dr=dt.NewRow();

dr["Name"]="Kiran+Reddy";
dr["Age"]=23;+
dt.Rows.add(dr);
Gv.DataSource=dt;
Gv.DataBind();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2047495|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>DataTable dt=new DataTable();
DataColumn Name = new DataColumn("Name",typeof(string)); 

dt.Columns.Add(Name);
DataColumn Age = new DataColumn("Age", typeof(int));`

dt.Columns.Add(Age);

DataRow dr=dt.NewRow();

dr["Name"]="Kavitha Reddy"; 
dr["Age"]=24; 
dt.add.Rows(dr);
dr=dt.NewRow();

dr["Name"]="Kiran Reddy";
dr["Age"]=23; 
dt.Rows.add(dr);
Gv.DataSource=dt;
Gv.DataBind();
</code></pre>

blocks|key|2047522|text|最简单的方法就是现在创建一个DtaTable|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2047523|DataTable+table+=+new+DataTable
{
++++Columns+=+{
++++++++"Name",+//+typeof(string)+is+implied
++++++++{"Marks",+typeof(int)}
++++},
++++TableName+=+"MarksTable"+//optional
};
table.Rows.Add("ravi",+500);|code-block|syntax|javascript|2047524|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The easiest way is to create a DtaTable as of now

<pre><code>DataTable table = new DataTable
{
 Columns = {
 "Name", // typeof(string) is implied
 {"Marks", typeof(int)}
 },
 TableName = "MarksTable" //optional
};
table.Rows.Add("ravi", 500);
</code></pre>

blocks|key|2047552|text|您可以在一行中添加行|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2047553|++++DataTable+table+=+new+DataTable();
++++table.Columns.Add("Dosage",+typeof(int));
++++table.Columns.Add("Drug",+typeof(string));
++++table.Columns.Add("Patient",+typeof(string));
++++table.Columns.Add("Date",+typeof(DateTime));

++++//+Here+we+add+five+DataRows.
++++table.Rows.Add(25,+"Indocin",+"David",+DateTime.Now);
++++table.Rows.Add(50,+"Enebrel",+"Sam",+DateTime.Now);
++++table.Rows.Add(10,+"Hydralazine",+"Christoff",+DateTime.Now);
++++table.Rows.Add(21,+"Combivent",+"Janet",+DateTime.Now);
++++table.Rows.Add(100,+"Dilantin",+"Melanie",+DateTime.Now);|code-block|syntax|javascript|2047554|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can add Row in a single line

<pre><code> DataTable table = new DataTable();
 table.Columns.Add("Dosage", typeof(int));
 table.Columns.Add("Drug", typeof(string));
 table.Columns.Add("Patient", typeof(string));
 table.Columns.Add("Date", typeof(DateTime));

 // Here we add five DataRows.
 table.Rows.Add(25, "Indocin", "David", DateTime.Now);
 table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);
 table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);
 table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);
 table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);
</code></pre>

How do create a DataTable in C#?

I did like this:

<pre><code> DataTable dt = new DataTable();
 dt.clear();
 dt.Columns.Add("Name");
 dt.Columns.Add("Marks");
</code></pre>

How do I see the structure of DataTable?

Now I want to add ravi for <code>Name</code> and 500 for <code>Marks</code>. How can I do this?

How to create a DataTable in C# and how to add rows?

如何在C#中创建DataTable？我喜欢这样： DataTable dt = new DataTable(); dt.clear(); dt.Columns.Add("Name"); dt.Columns.Add("Marks");如何看到DataTable的结构？现在我想为Name添加ravi，为Marks添加50...

问如何在C#中创建DataTable，如何添加行？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在C#中创建DataTable，如何添加行？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在C#中创建DataTable，如何添加行？
EN