62,046
社区成员
发帖
与我相关
我的任务
分享
protected void Button1_Click(object sender, EventArgs e)
{
gv1.DataSource = GetDataset(@"D:\d_contacts.txt");
gv1.DataBind();
}
private DataSet GetDataset(string strFilePath)
{
if (!File.Exists(strFilePath))
{
return null;
}
string strFolderPath = Path.GetDirectoryName(strFilePath);
string strCSVFile = Path.GetFileName(strFilePath);
DataSet ds = null;
string strConnection = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq='" + strFilePath + "';Extensions=asc,csv,tab,txt;Persist Security Info=False";
try
{
using (OdbcConnection conn = new OdbcConnection(strConnection.Trim()))
{
conn.Open();
string strSql = "select * from [" + strCSVFile + "]";
OdbcDataAdapter odbcDAdapter = new OdbcDataAdapter(strSql, conn);
ds = new DataSet();
odbcDAdapter.Fill(ds, "table");
conn.Close();
}
return ds;
}
catch (Exception e)
{
throw e;
}
}
//链接字符串的信息
strConnection=Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq='D:\d_contacts.txt';Extensions=asc,csv,tab,txt;Persist Security Info=False
//错误信息
ERROR [HY024] [Microsoft][ODBC Text Driver] '(未知的)'不是一个有效的路径。 确定路径名称拼写是否正确,以及是否连接到文件存放的服务器。
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [IM006] [Microsoft][ODBC 驱动程序管理器] 驱动程序的 SQLSetConnectAttr 失败
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [01S00] [Microsoft][ODBC Text Driver]非法的连接串属性 Persist Security Inf
ERROR [HY024] [Microsoft][ODBC Text Driver] '(未知的)'不是一个有效的路径。 确定路径名称拼写是否正确,以及是否连接到文件存放的服务器。
protected void Button1_Click(object sender, EventArgs e)
{
gv1.DataSource = GetDataset("C:/33s.txt");
gv1.DataBind();
}
private DataSet GetDataset(string strFilePath)
{
if (!File.Exists(strFilePath))
{
return null;
}
string strFolderPath = Path.GetDirectoryName(strFilePath);
string strCSVFile = Path.GetFileName(strFilePath);
DataSet ds = null;
string strConnection = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\\;Extensions=asc,csv,tab,txt;";
// string strConnection = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq='" + strFolderPath + "';Extensions=asc,csv,tab,txt;";
try
{
using (OdbcConnection conn = new OdbcConnection(strConnection.Trim()))
{
conn.Open();
string strSql = "select * from [" + strCSVFile + "]";
OdbcDataAdapter odbcDAdapter = new OdbcDataAdapter(strSql, conn);
ds = new DataSet();
odbcDAdapter.Fill(ds, "table");
conn.Close();
}
return ds;
}
catch (Exception e)
{
throw e;
}
}