ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/AnywhereTS-MSSQL/trunk/TSControlPanel/frmConfigureControlPanel.cs
Revision: 17
Committed: Wed Jul 11 16:48:23 2012 UTC (10 years, 10 months ago) by william
File size: 1477 byte(s)
Log Message:
+ fix more references to SQLEXPRESS

File Contents

# Content
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Text;
7 using System.Windows.Forms;
8 using System.Data.SqlClient;
9
10 namespace AnywhereTS
11 {
12 public partial class frmConfigureControlPanel : Form
13 {
14 public frmConfigureControlPanel()
15 {
16 InitializeComponent();
17 }
18
19 private void btnOk_Click(object sender, EventArgs e)
20 {
21 // Validate database server
22 string dataServer;
23 dataServer = textInput.Text.Trim();
24 //Create a connection to SQL Server
25 SqlConnection sqlCon = new SqlConnection();
26 try
27 {
28 sqlCon.ConnectionString = Properties.Settings.Default.atsConnectionString;
29 sqlCon.Open();
30 }
31 catch (SqlException sql_ex)
32 {
33 MessageBox.Show("Could not connect to the datbase server. Please check your spelling and your connections. SQL Server error:\n" + sql_ex.Number.ToString() + " " + sql_ex.Message.ToString());
34 return;
35 }
36
37
38 // Save database server to variable and registry
39 ProSupport.strDatabaseServer = textInput.Text;
40 ATSGlobals.SetATSRegValue(ProSupport.strRegDatabaseServer, ProSupport.strDatabaseServer);
41
42 DialogResult = DialogResult.OK; //return
43 }
44 }
45 }