private void btnLoadServers_Click(object sender, EventArgs e) { try { ClassCoreUtility.CaluculateAll(PBarSQLServer); // Create a instance of the SqlDataSourceEnumerator class servers = SqlDataSourceEnumerator.Instance; // Fetch all visible SQL server 2000 or SQL Server 2005 instances tableServers = new DataTable(); // Check if datatable is empty if (tableServers.Rows.Count == 0) { // Get a datatable with info about SQL Server 2000 and 2005 instances tableServers = servers.GetDataSources(); // List that will be combobox’s datasource List <string> listservers = new List <string>(); // For each element in the datatable add a new element in the list foreach (DataRow rowServer in tableServers.Rows) { // Server instance could have instace name or only server name, // check this for show the name if (String.IsNullOrEmpty(rowServer["InstanceName"].ToString())) { listservers.Add(rowServer["ServerName"].ToString()); } else { listservers.Add(rowServer["ServerName"] + "\\" + rowServer["InstanceName"]); } } // Set servers list to combobox’s datasource this.cmbSQLServer.DataSource = listservers; } } catch (Exception ex) { ex.ToString(); } }
private void btnGetDiscrepency_Click(object sender, EventArgs e) { try { richTxtDiscrepency.Text = ""; ClassCoreUtility.CaluculateAll(PBarDiscrepency); //ClassCoreUtility.CaluculateAll(pgrDiscrepency); if (string.IsNullOrEmpty(cmbDatabases.Text.ToString()) || string.IsNullOrEmpty(txtCoreAccountss.Text.ToString())) { MessageBox.Show("Please select Coredatabase and Account"); return; } string SQL; int count = 0; //Check whether Database exists on the SQL Server if (!(ClassCoreUtility.checkIfDatabaseExistsOnSQL(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString()))) { MessageBox.Show("Database does not exist on SQL Server"); return; } //Check whether database is Core Database if (!(ClassCoreUtility.checkIfCoreDatabase(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString()))) { MessageBox.Show("Selected Database not a Core Database!!"); return; } //Check whether Database exist in CORE if (!(ClassCoreUtility.checkIfDatabaseAlreadyAddedToCore(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString()))) { MessageBox.Show("Database does not exist Core"); return; } //Get discrepency in Core database Dictionary <string, string> dctDiscrepency = ClassCoreUtility.GetDiscrepency(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString()); foreach (var item in dctDiscrepency) { string comment = item.Key.ToString(); int lencomment = comment.Length; richTxtDiscrepency.Text += comment; //richTxtDiscrepency.Select(richTxtDiscrepency.Text.IndexOf("--"), lencomment); //richTxtDiscrepency.ForeColor = System.Drawing.Color.Green; //richTxtDiscrepency.SelectionColor = Color.Green; //richTxtDiscrepency.SelectedText = Environment.NewLine + item.Value; richTxtDiscrepency.AppendText(Environment.NewLine); int lenSQL = item.Value.Length; richTxtDiscrepency.Text += item.Value.ToString(); richTxtDiscrepency.AppendText(Environment.NewLine); richTxtDiscrepency.AppendText(Environment.NewLine); } if (richTxtDiscrepency.Text == "") { MessageBox.Show("No Discrepency found!!"); } else { MessageBox.Show("Copy the Discrepencies!!"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }