private static My_Stuct Find(DataTable table, List <string> tableList)
{
List <List <string> > tableRows;
List <string> oneRow = new List <string>();
string text = null;
tableRows = new List <List <string> >();
string convetedStringToPostgre = "";
string curentTableName = null;
List <string> answer = new List <string>();
string lastTableName = "";
My_Stuct ans = new My_Stuct();
int k = 0;
for (int i = 0; i < table.Rows.Count; i++)
{
curentTableName = table.Rows[i][table.Columns[2]].ToString();
if (curentTableName != lastTableName && convetedStringToPostgre != "" && lastTableName[0] == 'T')
{
k++;
Console.WriteLine(k);
answer.Add(convetedStringToPostgre);
tableRows.Add(new List <string>(oneRow));
oneRow.Clear();
Console.WriteLine(lastTableName);
Console.WriteLine(convetedStringToPostgre);
Console.WriteLine();
Console.WriteLine();
convetedStringToPostgre = "";
}
if (tableList.Contains(curentTableName))
{
oneRow.Add(table.Rows[i][table.Columns[3]].ToString());
// datatim
convetedStringToPostgre += table.Rows[i][table.Columns[3]].ToString() + ' ' + Converter(table.Rows[i][table.Columns[11]].ToString()) + ',';
// foreach (DataColumn col in table.Columns)
// Console.WriteLine("{0} = {1}", col.ColumnName, table.Rows[i][col]);
// Console.WriteLine(table.Rows[i][table.Columns[11]].ToString());
}
else
{
continue;
}
lastTableName = curentTableName;
}
ans.First = answer;
ans.Second = tableRows;
return(ans);
}
public static void AccessConnect()
{
List <List <string> > tableRows = new List <List <string> >();
// Microsoft Access provider factory
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
DbConnection connection = factory.CreateConnection();
DataTable userTables = null;
DataTable table = null;
List <string> oneRow = new List <string>();
using (connection) // ???
{
connection.ConnectionString = connectionString; // Строка подключения
string[] restrictions = new string[4]; // параметры ограничения
restrictions[3] = "Table"; // Только таблицы пользователя
connection.Open(); // открыть подключение
// Get list of user tables
userTables = connection.GetSchema("Tables", restrictions); // названия пользовательских таблиц
table = connection.GetSchema("Columns"); // Получение название колонок
Console.WriteLine("Press any key to continue.");
Console.ReadKey();
}
List <string> tableNames = new List <string>();
for (int i = 0; i < userTables.Rows.Count; i++)
{
if (userTables.Rows[i][2].ToString()[0] == 'T')
{
tableNames.Add(userTables.Rows[i][2].ToString()); // получение название таблиц
}
}
My_Stuct returnAnswer = new My_Stuct();
for (int i = 0; i < userTables.Rows.Count; i++)
{
Console.WriteLine(userTables.Rows[i][2].ToString()); // вывод названий таблиц
}
returnAnswer = Find(table, tableNames); // получение строки запроса в access
List <string> answer = returnAnswer.First;
tableRows = returnAnswer.Second;
for (int i = 0; i < tableNames.Count; i++)
{
Postgres.TableCreate(answer[i].Remove(answer[i].Length - 1), tableNames[i]); // создание
}
OleDbConnection myConnection;
double buf = 0;
List <List <string> > querysTable;
List <string> column;
for (int i = 0; i < tableNames.Count; i++)
{
querysTable = new List <List <string> >();
myConnection = new OleDbConnection(connectionString);
myConnection.Open();
for (int j = 0; j < tableRows[i].Count; j++)
{
column = new List <string>();
string query = "SELECT " + tableRows[i][j] + " FROM " + tableNames[i];
OleDbCommand command = new OleDbCommand(query, myConnection);
OleDbDataReader reader = command.ExecuteReader();
// создаем объект OleDbCommand для выполнения запроса к БД MS Access
while (reader.Read())
{
if (reader[0] is DateTime)
{
column.Add((((DateTime)reader[0]).ToString("yyyy.MM.dd hh:mm:ss")));
}
else
if (double.TryParse(reader[0].ToString(), out buf))
{
column.Add((reader[0].ToString()).Replace(',', '.'));
}
else
{
column.Add(reader[0].ToString());
}
}
querysTable.Add(column);
}
Postgres.AddRecord(querysTable, tableRows[i], tableNames[i]);
Console.WriteLine(tableNames[i]);
}
}
