Guest User

Untitled

a guest
May 23rd, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.49 KB | None | 0 0
  1. private void OnClicked_RefreshDataSources(object sender, EventArgs e) {
  2. Cursor = Cursors.WaitCursor;
  3.  
  4. DataTable dt = SmoApplication.EnumAvailableSqlServers(false);
  5. uxDataSource.Items.Clear();
  6.  
  7. foreach (DataRow row in dt.Rows) {
  8. uxDataSource.Items.Add(row["Name"]);
  9. }
  10.  
  11. if (dt.Rows.Count > 0) {
  12. uxDataSource.SelectedIndex = 0;
  13. }
  14.  
  15. Cursor = Cursors.Default;
  16. }
  17.  
  18. private void OnSelectedIndexChanged_PopulateDatabases(object sender, EventArgs e) {
  19. ConnectionString.DataSource = uxDataSource.SelectedItem.ToString();
  20.  
  21. Server server = new Server(uxDataSource.SelectedItem.ToString());
  22. server.ConnectionContext.LoginSecure = false;
  23. server.ConnectionContext.Login = Program.DesktopService.AccountName;
  24.  
  25. uxInitialCatalog.Items.Clear();
  26.  
  27. try {
  28. foreach (Database db in server.Databases) {
  29. uxInitialCatalog.Items.Add(db.Name);
  30. }
  31.  
  32. if (server.Databases.Count > 0) {
  33. uxInitialCatalog.SelectedIndex = 0;
  34. }
  35. }
  36. catch {
  37. MessageBox.Show("You do not have access to this server.", "Sql Connection", MessageBoxButtons.OK,
  38. MessageBoxIcon.Warning);
  39. uxInitialCatalog.Items.Clear();
  40. }
  41. }
  42.  
  43. var results = SqlDataSourceEnumerator.Instance.GetDataSources();
  44.  
  45. foreach (var row in results.Rows)
  46. {
  47. Console.WriteLine("{0}{1}", row["ServerName"], row["InstanceName"]);
  48. }
Add Comment
Please, Sign In to add comment