CODEWITHSUNDEEP
c#encodingparadox
Kirill
Kirill

Reputation: 13

Wrong characters with OdbcDataAdapter

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?

Upvotes: 0

Views: 120

Answers (0)

Related Questions