本文介绍如何使用C#创建DataTable和DataSet。首先展示了多种创建DataTable的方法，包括直接实例化、添加列并设置属性，以及批量添加多列。接着演示了如何创建DataSet，并添加多个DataTable。
namespace CreateDataCloumnAddDataTable
{
class Program
{
static void Main(string[] args)
{
DataTable dt = new DataTable();
DataColumn col1 = dt.Columns.Add();
col1.ColumnName = "Column-1";
col1.DataType = typeof(int);
col1.DefaultValue = 0;
DataColumn col2 = new DataColumn();
dt.Columns.Add(col2);
col2.ColumnName = "Column-2";
col2.DataType = typeof(string );
col2.DefaultValue = 0;
col2.MaxLength = 50;
dt.Columns.Add("Column-3", typeof(string)).MaxLength = 50;
DataColumn col4 = new DataColumn("Column-4");
DataColumn col5 = new DataColumn("Cloumn5", typeof(string));
dt.Columns.AddRange(new DataColumn[] { col4, col5 });
Console.WriteLine("DataTable has{0} DataColumns named:",dt.Columns.Count );
foreach (DataColumn col in dt.Columns )
{
Console.WriteLine(col.ColumnName );
}
}
}
}
namespace CreateDataTableAddDataSet
{
class Program
{
static void Main(string[] args)
{
DataSet ds = new DataSet();
DataTable dt1 = ds.Tables.Add("Table-1");
DataTable dt2 = new DataTable("Table-2");
ds.Tables.Add(dt2);
DataTable dt3 = new DataTable("Table-3");
DataTable dt4 = new DataTable("Table-4");
ds.Tables.AddRange(new DataTable[] { dt3, dt4 });
Console.WriteLine("DataSet has {0} Table",ds.Tables.Count);
foreach (DataTable item in ds.Tables)
{
Console.WriteLine(item.TableName);
}
}
}
}
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
