customerdataset.cs

来自「串口发送短信」· CS 代码 · 共 39 行

namespace SMSTest
{
	using System;
	using System.Data;
	using System.Data.SqlClient;

	/// <summary>
	/// CustomerDataSet 的摘要说明。
	/// </summary>
	public class CustomerDataSet : DataSet
	{
		//表名
		public const string CUSTOMERS_TABLE = "Customers";
		//姓名字段
		public const string NAME_FIELD = "Name";
		//号码字段
		public const string PHONE_FIELD = "Phone";

		public CustomerDataSet()
		{
			this.BuildCustomersTables();
		}
		
		//建表
		private void BuildCustomersTables()
		{
			DataTable table = new DataTable(CUSTOMERS_TABLE);
			DataColumnCollection columns = table.Columns;

			columns.Add(NAME_FIELD);
			columns.Add(PHONE_FIELD);

			this.Tables.Add(table);
		}
	}
}