DataSet
来源:互联网 发布:淘宝封号多久解封 编辑:程序博客网 时间:2024/06/06 15:38
public DataSet GetDataSetFromCSV(string filePath, string fileName)
{
string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=";
strConn += filePath; //filePath, For example: C:\
strConn += ";Extensions=asc,csv,tab,txt;";
OdbcConnection objConn = new OdbcConnection(strConn);
DataSet dsCSV = new DataSet();
try
{
string strSql = "select * from " + fileName; //fileName, For example: 1.csv
OdbcDataAdapter odbcCSVDataAdapter = new OdbcDataAdapter(strSql, objConn);
odbcCSVDataAdapter.Fill(dsCSV);
return dsCSV;
}
catch (Exception ex)
{
throw ex;
}
}
{
string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=";
strConn += filePath; //filePath, For example: C:\
strConn += ";Extensions=asc,csv,tab,txt;";
OdbcConnection objConn = new OdbcConnection(strConn);
DataSet dsCSV = new DataSet();
try
{
string strSql = "select * from " + fileName; //fileName, For example: 1.csv
OdbcDataAdapter odbcCSVDataAdapter = new OdbcDataAdapter(strSql, objConn);
odbcCSVDataAdapter.Fill(dsCSV);
return dsCSV;
}
catch (Exception ex)
{
throw ex;
}
}
- DataSet
- DataSet
- DataSet
- DataSet
- DataSet
- dataset
- DataSet
- DataSet
- DataSet
- dataSet
- DataSet
- DataSet
- dataset
- DataSet
- DataSet
- dataset
- DataSet
- DataSet
- ALSM_EXCEL_TO_INTERNAL_TABLE 上传EXCEL示例
- GIS地图放大镜
- s2-Convention Plugin笔记
- IPC进程间通信
- 漏洞标题: 中国移动mas2.0平台系统漏洞
- DataSet
- java 设计模式之四-代理模式 java静态代理和动态代理
- UT6410 linux led程序
- Message-Box Styles
- learn english (studio classroom ) 2012-5-10
- 访问任何数据库,都是这么简单,只需三句话
- [inno setup]如何把安装的卸载程序放到其他目录
- 单向链表反转
- Facebook生态效应:养活了一大批创业公司