CSV到DATATABLE(3)
来源:互联网 发布:java汉字转拼音 编辑:程序博客网 时间:2024/06/06 01:01
/// <summary>
/// 把一个CSV文件读到一个DataTable中
/// </summary>
/// <param name="strpath">文件完整路径</param>
/// <returns>DataTable</returns>
public static DataTable GetTable(string strpath)
{
Regex reg = new Regex("/",/"");
int intColCount = 0;
DataTable mydt = new DataTable("myTableName");
//DataColumn mydc;
//DataRow mydr;
//string strpath = "";
string strline;
string[] aryline;
StreamReader mysr = new StreamReader(strpath,System.Text.Encoding.Default);
strline = mysr.ReadLine();
aryline = reg.Split(strline);
intColCount = aryline.Length;
for (int i = 0; i < aryline.Length; i++)
{
DataColumn mydc = new DataColumn(aryline[i].Replace("/"", ""), typeof(string));
mydt.Columns.Add(mydc);
}
while ((strline = mysr.ReadLine()) != null)
{
aryline = reg.Split(strline);
DataRow mydr = mydt.NewRow();
for (int i = 0; i < intColCount; i++)
{
mydr[i] = aryline[i].Replace("/"","");
}
mydt.Rows.Add(mydr);
}
return mydt;
}
/// 把一个CSV文件读到一个DataTable中
/// </summary>
/// <param name="strpath">文件完整路径</param>
/// <returns>DataTable</returns>
public static DataTable GetTable(string strpath)
{
Regex reg = new Regex("/",/"");
int intColCount = 0;
DataTable mydt = new DataTable("myTableName");
//DataColumn mydc;
//DataRow mydr;
//string strpath = "";
string strline;
string[] aryline;
StreamReader mysr = new StreamReader(strpath,System.Text.Encoding.Default);
strline = mysr.ReadLine();
aryline = reg.Split(strline);
intColCount = aryline.Length;
for (int i = 0; i < aryline.Length; i++)
{
DataColumn mydc = new DataColumn(aryline[i].Replace("/"", ""), typeof(string));
mydt.Columns.Add(mydc);
}
while ((strline = mysr.ReadLine()) != null)
{
aryline = reg.Split(strline);
DataRow mydr = mydt.NewRow();
for (int i = 0; i < intColCount; i++)
{
mydr[i] = aryline[i].Replace("/"","");
}
mydt.Rows.Add(mydr);
}
return mydt;
}
- CSV到DATATABLE(3)
- CSV到DATATABLE(1)
- CSV到DATATABLE(2)
- 读取CSV到DataTable
- CSV 导入到 Datatable
- csv导入到数据库前步骤(导入到DataTable)
- 读取CSV文件到DataTable
- 读取CSV文件到DataTable
- 读取csv文件到datatable
- C# 读写CSV文件到DataTable
- 读取csv文件内容到DataTable
- 如何读取CSV数据到DataTable中
- C#读取csv文件内容到DataTable
- C#读取CSV文件到DataTable
- C#_把dataTable数据导出到CSV,XLS文件
- DataTable导出到Excel的解决方案(.csv)文件
- C#中将DataTable中数据导出到csv文件中
- C#中将DataTable中数据导出到csv文件中
- cin、cout的问题
- fedora 8安装后配置(二)
- session与cookies
- 创业故事
- ssh 配置
- CSV到DATATABLE(3)
- 重叠模型--事件对象通知
- 用iframe做编辑器
- 怎样开始学习OpenGL
- PB通过OUTLOK发送邮件
- Rtl8019 for S3C44B0 驱动程序源码解析
- SQLite
- Linux下string操作的精彩源码欣赏
- 使用开源组件生成随机验证码