c# lotus dbase ODBC charset
本文关键字:charset ODBC dbase lotus | 更新日期: 2023-09-27 18:26:53
我正在尝试读取 lotus dbase 文件以导出数据。我正在使用此代码:
enter code here
private void odbc()
{
DataTable YourResultSet = new DataTable();
string strAccessConn = @"Driver={Microsoft dBase Driver (*.dbf)};SourceType=DBF;SourceDB=C:'shares'lotus;Exclusive=No;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;CHARSET=928";
OdbcConnection connection = new OdbcConnection(strAccessConn);
// Open the connection, and if open successfully, you can try to query it
connection.Open();
if (connection.State == ConnectionState.Open)
{
string mySQL = @"select * from C:'shares'lotus'techtime.DBF"; // dbf table name
OdbcCommand MyQuery = new OdbcCommand(mySQL, connection);
OdbcDataAdapter DA = new OdbcDataAdapter(MyQuery);
DA.Fill(YourResultSet);
connection.Close();
}
string myString = YourResultSet.Rows[0][4].ToString();
}
但希腊语的莱特斯是这样的"╠┴═╧╙ ═╔╩╧╦╧╒─╟╙"我不知道使用了字符集。我能做什么?提前致谢
应在连接字符串中使用 737 代码页:
;CHARSET=737