using System;
using System.Data;
using System.Data.SqlClient;
namespace App{
class MyClass{
public static void Main(string[] args){
//DataTable dt = new DataTable();
int[] id = { 4, 5, 1, 3, 2, 7, 6 };
string[] name = {"Tom","Jack","HelloWorld","Visual Studio","Gril","Timmy","Geo" };
DataTable dt = new DataTable("Table_New");
//DataColumn dc = new DataColumn();
dt.Columns.Add("id",typeof(int));
dt.Columns.Add("name",typeof(string));
for(int i=0;i<id.Length;i++){
dt.Rows.Add(new object[]{id[i],name[i]});//添加一个数组
} //遍历dataTables;
for(int i=0;i<id.Length;i++){
Console.WriteLine(dt.Rows[i]["name"]);
}
}
}
}
把 dataDable 比作一个excel或数据表
先添加列,在添加行
读取DataTable行列数:
dt.Rows.Count
dt.Columns.Count
练习:
using System;
using System.Data;
namespace App{
class MyClass{
public static void Main(string[] args){
DataTable dt = new DataTable("table");
dt.Columns.Add("id");
dt.Columns.Add("name");
int[] idArr={,,};
string[] nameArr ={"mlh","","ghh"};
for(int i=;i<idArr.Length;i++){
dt.Rows.Add(idArr[i],nameArr[i]);
}
for(int i=;i<idArr.Length;i++){
Console.WriteLine(dt.Rows[i]["id"]);
}
}
}
}