private void button3_Click(object sender, EventArgs e) { BwsHelper file = new BwsHelper(label3.Text); List <OleDbConnection> dbs = new List <OleDbConnection>(2); dbs.Add(new OleDbConnection(String.Format("Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source='{0}'", label1.Text))); dbs[0].Open(); dbs.Add(new OleDbConnection(String.Format("Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source='{0}'", label2.Text))); dbs[1].Open(); OleDbConnection Myconnection3 = new OleDbConnection(String.Format("Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source='{0}'", label3.Text)); Myconnection3.Open(); OleDbCommand ins = Myconnection3.CreateCommand(); for (int i = 0; i < 2; i++) { OleDbCommand read = dbs[i].CreateCommand(); read.CommandText = "SELECT * FROM PlayerNumbers"; OleDbDataReader dr = read.ExecuteReader(); while (dr.Read()) { ins.CommandText = String.Format("INSERT INTO PlayerNumbers ([Section], [Table], Direction, [Number]) VALUES ({0}, {1}, '{2}', {3})", i + 1, dr[1], dr[2], "NULL"); ins.ExecuteNonQuery(); } dr.Close(); read.CommandText = "SELECT * FROM [Section]"; dr = read.ExecuteReader(); while (dr.Read()) { ins.CommandText = String.Format("INSERT INTO [Section] ([ID], [Letter], [Tables], [MissingPair]) VALUES ({0}, '{1}', {2}, {3})", i + 1, i == 0 ? "A" : "B", dr[2], dr[4]); ins.ExecuteNonQuery(); } dr.Close(); read.CommandText = "SELECT * FROM RoundData"; dr = read.ExecuteReader(); while (dr.Read()) { ins.CommandText = String.Format("INSERT INTO RoundData ([Section], [Table], [Round], [NSPair], [EWPair], [LowBoard], [HighBoard]) VALUES ({0}, {1}, {2}, {3}, {4}, {5}, {6})", i + 1, dr[1], dr[2], dr[3], dr[4], dr[5], dr[6]); ins.ExecuteNonQuery(); } dr.Close(); read.CommandText = "SELECT * FROM [Tables]"; dr = read.ExecuteReader(); while (dr.Read()) { ins.CommandText = String.Format("INSERT INTO [Tables] ([Section], [Table], [ComputerID], [Status], [LogOnOff], [CurrentRound], [CurrentBoard], [UpdateFromRound]) VALUES ({0}, {1}, {2}, {3}, {4}, {5}, {6}, {7})", i + 1, dr[1], dr[2], dr[3], dr[4], dr[5], dr[6], dr[7]); ins.ExecuteNonQuery(); } dr.Close(); } dbs[0].Close(); dbs[1].Close(); Myconnection3.Close(); label4.Text = "Done"; fBMSettings form = new fBMSettings(false); if (form.ShowDialog() == DialogResult.OK) { for (int i = 1; i < 3; i++) { file.SetSettings(form.options); Myconnection3.Open(); ins.CommandText = String.Format("UPDATE [Settings] SET [Section]={0} WHERE [Section]=0", i); ins.ExecuteNonQuery(); Myconnection3.Close(); } } }
private void button3_Click(object sender, EventArgs e) { BwsHelper file = new BwsHelper(label3.Text); List<OleDbConnection> dbs = new List<OleDbConnection>(2); dbs.Add(new OleDbConnection(String.Format("Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source='{0}'", label1.Text))); dbs[0].Open(); dbs.Add(new OleDbConnection(String.Format("Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source='{0}'", label2.Text))); dbs[1].Open(); OleDbConnection Myconnection3 = new OleDbConnection(String.Format("Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source='{0}'", label3.Text)); Myconnection3.Open(); OleDbCommand ins = Myconnection3.CreateCommand(); for (int i = 0; i < 2; i++) { OleDbCommand read = dbs[i].CreateCommand(); read.CommandText = "SELECT * FROM PlayerNumbers"; OleDbDataReader dr = read.ExecuteReader(); while (dr.Read()) { ins.CommandText = String.Format("INSERT INTO PlayerNumbers ([Section], [Table], Direction, [Number]) VALUES ({0}, {1}, '{2}', {3})", i + 1, dr[1], dr[2], "NULL"); ins.ExecuteNonQuery(); } dr.Close(); read.CommandText = "SELECT * FROM [Section]"; dr = read.ExecuteReader(); while (dr.Read()) { ins.CommandText = String.Format("INSERT INTO [Section] ([ID], [Letter], [Tables], [MissingPair]) VALUES ({0}, '{1}', {2}, {3})", i + 1, i == 0 ? "A" : "B", dr[2], dr[4]); ins.ExecuteNonQuery(); } dr.Close(); read.CommandText = "SELECT * FROM RoundData"; dr = read.ExecuteReader(); while (dr.Read()) { ins.CommandText = String.Format("INSERT INTO RoundData ([Section], [Table], [Round], [NSPair], [EWPair], [LowBoard], [HighBoard]) VALUES ({0}, {1}, {2}, {3}, {4}, {5}, {6})", i + 1, dr[1], dr[2], dr[3], dr[4], dr[5], dr[6]); ins.ExecuteNonQuery(); } dr.Close(); read.CommandText = "SELECT * FROM [Tables]"; dr = read.ExecuteReader(); while (dr.Read()) { ins.CommandText = String.Format("INSERT INTO [Tables] ([Section], [Table], [ComputerID], [Status], [LogOnOff], [CurrentRound], [CurrentBoard], [UpdateFromRound]) VALUES ({0}, {1}, {2}, {3}, {4}, {5}, {6}, {7})", i + 1, dr[1], dr[2], dr[3], dr[4], dr[5], dr[6], dr[7]); ins.ExecuteNonQuery(); } dr.Close(); } dbs[0].Close(); dbs[1].Close(); Myconnection3.Close(); label4.Text = "Done"; fBMSettings form = new fBMSettings(false); if (form.ShowDialog() == DialogResult.OK) { for (int i = 1; i < 3; i++) { file.SetSettings(form.options); Myconnection3.Open(); ins.CommandText = String.Format("UPDATE [Settings] SET [Section]={0} WHERE [Section]=0", i); ins.ExecuteNonQuery(); Myconnection3.Close(); } } }