Advertisement
Guest User

ParkingChange1

a guest
Mar 31st, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. //SettingsWindow.xaml.cs
  2. private void connectBtn_Click(object sender, RoutedEventArgs e)
  3. {
  4. string dbInstance = dbInstBox.Text;
  5. string dbName = dbNameBox.Text;
  6. string username = userBox.Text;
  7. string password = passBox.Text;
  8.  
  9. DB = dbInstance;
  10.  
  11. using (
  12. SqlConnection myConn =
  13. new SqlConnection(String.Format("Data Source={0};Integrated security=SSPI;database=master",
  14. dbInstance)))
  15. {
  16. try
  17. {
  18. myConn.Open();
  19. System.Windows.Forms.MessageBox.Show("Logged To DataBase Successfully", "MyProgram",
  20. MessageBoxButtons.OK, MessageBoxIcon.Information);
  21.  
  22. Server db = new Server(new ServerConnection(myConn));
  23.  
  24. //str = SQLQueryGenerator.SQLQueryGenerator.GenerateCreateDBWithUserAndPass(dbName, username, password);
  25.  
  26. }
  27. catch (System.Exception ex)
  28. {
  29. System.Windows.Forms.MessageBox.Show(ex.ToString(), "MyProgram", MessageBoxButtons.OK,
  30. MessageBoxIcon.Information);
  31. }
  32. finally
  33. {
  34. if (myConn.State == ConnectionState.Open)
  35. {
  36. myConn.Close();
  37. }
  38.  
  39. var mW = new MainWindow(DB, dbName);
  40. mW.ShowDialog();
  41. }
  42. }
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement