/[AnywhereTS-MSSQL]/branches/anywherets.r2.sourceforge/TSControlPanel/frmConfigureControlPanel.cs
ViewVC logotype

Contents of /branches/anywherets.r2.sourceforge/TSControlPanel/frmConfigureControlPanel.cs

Parent Directory Parent Directory | Revision Log Revision Log


Revision 5 - (show annotations) (download)
Wed Jul 11 15:09:09 2012 UTC (9 years, 10 months ago) by william
File size: 1569 byte(s)
Created branch: anywherets.r2.sourceforge
Snapshot of: https://anywherets.svn.sourceforge.net/svnroot/anywherets/trunk/
at Revision 2
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 = @"Data Source=" + dataServer + @"\SQLEXPRESS;Database='AnywhereTS';Integrated Security=True;Connect Timeout=30;User Instance=False";
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 Express 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 }

  ViewVC Help
Powered by ViewVC 1.1.22