0

I use OdbcDataAdapter to get data from Paradox DB.

public static DataSet GetDataSetFromAdapter(DataSet dataSet, DataTable dataTable, string connectionString, string queryString)
    {
        using (OdbcConnection connection = new OdbcConnection(connectionString))
        {
            OdbcDataAdapter adapter = new OdbcDataAdapter(queryString, connection);
            connection.Open();
            adapter.Fill(dataSet);
            adapter.FillSchema(dataTable, SchemaType.Source);
            connection.Close();
        }
        return dataSet;
    }

I use FillSchema() method to get schema. But "." replaces to "#" in column name and a few symbols (e.g. "ä") replaces to another symbols too. How can I fix it?

Kirill
  • 13
  • 2
  • whats in your connection string and querystring? – Jake Steffen Jun 05 '19 at 15:17
  • @JakeSteffen "Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 7.X;DefaultDir=" + path + ";Dbq=" + path + ";CollatingSequence=ASCII;" – Kirill Jun 05 '19 at 15:27
  • And the querystring? Are you escaping column names in the query? – stephen.vakil Jun 05 '19 at 15:39
  • Query = "select * from HOUSE" (I have HOUSE.DB file with columns, but a few characters in column names are wrong - "#" instead of ".", "Д" instead of "a",... ) – Kirill Jun 05 '19 at 15:46

0 Answers0