private void backup_zapisanie(Controler.Controler controler) { List <string> lines = new List <string>(); string[] param; param = controler.parametre_tabulka().Split(','); sql_cmd.CommandText = $"Select * From {controler.ToString()}"; using (DbDataReader dataReader = sql_cmd.ExecuteReader()) { while (dataReader.Read()) { string line = " "; for (int i = 0; i < param.Length; i++) { line += dataReader[param[i]].ToString(); if (i + 1 != param.Length) { line += ";"; } } lines.Add(line); } using (System.IO.StreamWriter file = new System.IO.StreamWriter($"../../Backup/Backup_{controler.ToString()}.csv")) { foreach (string line in lines) { file.WriteLine(line); } } lines.Clear(); } }
private void backup_citanie(Controler.Controler controler) { List <string> riadky = File.ReadAllLines($"../../Backup/Backup_{controler.ToString()}.csv").ToList(); int index = 1; string text = ""; foreach (var line in riadky) { string[] riadok = line.Split(';'); text = $"INSERT INTO {controler.ToString()} VALUES ( "; //'{index}', for (int i = 0; i < riadok.Length; i++) { text += $"'{riadok[i]}'"; if (i + 1 != riadok.Length) { text += ","; } else { text += ")"; } } sql_cmd.CommandText = text; sql_cmd.ExecuteNonQuery(); index++; } }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); string provider = ConfigurationManager.AppSettings["provider"]; string connectionString = ConfigurationManager.AppSettings["connectionString"]; DbProviderFactory factory = DbProviderFactories.GetFactory(provider); Controler.Controler controler = new Controler.Controler(); using (DbConnection connection = factory.CreateConnection()) { if (connection == null) { Console.WriteLine("Connection Error"); Console.ReadLine(); return; } connection.ConnectionString = connectionString; connection.Open(); DbCommand command = factory.CreateCommand(); if (command == null) { Console.WriteLine("Command Error"); Console.ReadLine(); return; } command.Connection = connection; Application.Run(new Prihlasenie(command)); } }