Форум программистов [Powered by Invision Power Board]

Код

public DataSet GetDataSetFromAdapter(DataSet dataSet, string connectionString, string queryString)
        {
            using (OdbcConnection connection = new OdbcConnection(connectionString))
            {
                OdbcDataAdapter adapter = new OdbcDataAdapter(queryString, connection);
                // Open the connection and fill the DataSet.
                try
                {
                    connection.Open();
                    adapter.Fill(dataSet);
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
                // The connection is automatically closed when the
                // code exits the using block.
            }
            return dataSet;
        }

        private void menustripitem1_Click(object sender, EventArgs e)
        {
            dataset = GetDataSetFromAdapter(dataset,
               "Driver={Microsoft Paradox Driver (*.db )};DBQ=e:\\temp\\1\\",
               "Select * from doing.db");

            for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
            {
                string Temp = (string)dataset.Tables[0].Rows[i].Field<string>(6);
                byte[] sourceBytes = Encoding.GetEncoding(1252).GetBytes(Temp);
                string convertedString = Encoding.GetEncoding(1251).GetString(sourceBytes);
                dataset.Tables[0].Rows[i].SetField<string>(6, convertedString);
            }

            Table.DataSource = dataset.Tables[0];

            dataset.WriteXml("C:\\Data\\xml.xml");      
        }