一，读取Excel文件内容：1//根据excle的路径把第一个sheel中的内容放入datatable2publicstaticDataTableReadExcelToTable()//excel存放的路径3{4//连接字

usingSystem;usingSystem.Data;usingSystem.Text;usingSystem.Collections.Generic;usingSystem.Reflection;usingSystem.Data.Common;usingSystem.Co

将DataTable转换成list及数据分页:///<summary///酒店评论列表分页///</summary///<paramname"userId"</param///<paramname"pageIndex"当前页</param///<paramna

publicclassCSVFileHelper{///<summary///将DataTable中数据写入到CSV文件中///</summary///<paramname"dt"提供保存数据的DataTable</param/

DataGear(https://www.oschina.net/action/GoToLink?urlhttp%3A%2F%2Fdatagear.tech%2F)内置表格图表底层采用的是DataTable(https://www.oschina.net/action/GoToLink?urlhttps%3A%2F%2Fdatatables.n

protectedvoidPage_Load(objectsender,EventArgse){//①CreateaDataTableDataTabledtnewDataTable("Table_AX");//②Addc

using System.Data; //DataTabletry{    DataTable dt  new DataTable();    dt.Columns.Add("BusinessID",System.Type.GetType("System.Int32"));    dt.C