c#.net中csv文件的连接字符串 [英] connection string for csv file in c#.net

问题描述

请在c#.net

推荐答案

在这里看看:
http://www.connectionstrings.com/textfile [

Hi,

have a look here:
http://www.connectionstrings.com/textfile[^]

字符串strFileName =" D://FXDEAL.csv;
OleDbConnection conn =新的OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0;数据源=" + System.IO.Path.GetDirectoryName(strFileName)+;扩展属性= \" Text; HDR = YES; FMT = Delimited \ ");
conn.Open();
OleDbDataAdapter适配器=新的OleDbDataAdapter("SELECT * FROM" + System.IO.Path.GetFileName(strFileName)，conn);
DataSet ds = new DataSet("Temp");
adapter.Fill(ds);
DataTable tb = ds.Tables [0];

string strFileName = "D://FXDEAL.csv";
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + System.IO.Path.GetDirectoryName(strFileName) +"; Extended Properties = \"Text;HDR=YES;FMT=Delimited\"");
conn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM " + System.IO.Path.GetFileName(strFileName), conn);
DataSet ds = new DataSet("Temp");
adapter.Fill(ds);
DataTable tb = ds.Tables[0];

毫不费力.有关连接st，请参阅

No effort from your side. For connection sting you can refer
this[^]

Hope this will help you :)

这篇关于c#.net中csv文件的连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！