private void button1_Click(object sender, EventArgs e) { if (SqlConnect.GetConnectionState() == ConnectionState.Closed) { try { if (SQLSrvNameTBox.Text != "" && SQLPasswdTBox.Text != "" && DBSelectCombo.Text != "") { Cursor = Cursors.WaitCursor; SqlConnect.OpenConnection(SQLSrvNameTBox.Text, DBSelectCombo.Text, SQLPasswdTBox.Text); Cursor = Cursors.Default; if (SqlConnect.GetConnectionState() == ConnectionState.Open) { StateLabel.Text = "Połączono z bazą danych\n" + SQLSrvNameTBox.Text; EnableWork(); } if (!Directory.Exists(Environment.GetEnvironmentVariable("TEMP") + "\\SQLChanger")) { Directory.CreateDirectory(Environment.GetEnvironmentVariable("TEMP") + "\\SQLChanger"); } StreamWriter writer = File.CreateText(Environment.GetEnvironmentVariable("TEMP") + "\\SQLChanger\\data"); writer.Write(SQLSrvNameTBox.Text); writer.Close(); writer.Dispose(); PowiatSelectCombo.Items.Clear(); PowiatSelectCombo.Text = ""; JEwidencyjnaSelectCombo.Items.Clear(); JEwidencyjnaSelectCombo.Text = ""; ObrebSelectCombo.Items.Clear(); ObrebSelectCombo.Text = ""; DataManip.DataManip.FillPowiatSelectCombo(PowiatSelectCombo); OdbcDataReader rd = SqlConnect.ExecuteDataReader("c_ID", "ClassTbl", "c_name LIKE 'GOSZZG'"); rd.Read(); cCodeID = int.Parse(rd["c_ID"].ToString()); rd.Close(); DataManip.DataManip.initDictionaryIDs(); } else { MessageBox.Show("Wpisz nazwę serwera, nazwę bazy i hasło do konta (sa)", "Połączenie SQL", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception exept) { MessageBox.Show(exept.Message, "Wystąpił błąd"); } } else { SqlConnect.CloseConnection(); DisableWork(); StateLabel.Text = "Rozłączono"; SQLPasswdTBox.Text = ""; } Cursor = Cursors.Arrow; }
private void button1_Click_1(object sender, EventArgs e) { SqlConnect.CloseConnection(); Close(); }