public void Form1_Load(object sender, EventArgs e) { // SetCurPole("1", "2"); bool loaded = true; listBox1.Items.Clear(); listBox2.Items.Clear(); Connect_to_sql conn = new Connect_to_sql(); string connect_string = conn.Con_str(); if (connect_string != "error") { try { conn.TestConnectToDB(connect_string); } catch (Exception ex) { DoOff += 1; MessageBox.Show(ex.Message); if (DoOff >= 2) { Application.ExitThread(); } loaded = false; } if (loaded) { SqlConnection myConnection = new SqlConnection(connect_string); string myInsertQuery = "SELECT name FROM t_razrez ORDER BY kod_razrez"; SqlCommand myCommand = new SqlCommand(myInsertQuery); myCommand.Connection = myConnection; myConnection.Open(); SqlDataReader reader = myCommand.ExecuteReader(); while (reader.Read()) { listBox1.Items.Add(reader[0].ToString()); } myCommand.Connection.Close(); myInsertQuery = "SELECT name FROM t_stakan_gruppa ORDER BY kod_gr"; myCommand = new SqlCommand(myInsertQuery); myCommand.Connection = myConnection; myConnection.Open(); reader = myCommand.ExecuteReader(); while (reader.Read()) { listBox2.Items.Add(reader[0].ToString()); } myCommand.Connection.Close(); myreg = Registry.CurrentUser.OpenSubKey("SOFTWARE\\AgroMeteo\\ConnectionSetting", true); try { label57.BackColor = Color.FromArgb((int)myreg.GetValue("c1")); label56.BackColor = Color.FromArgb((int)myreg.GetValue("c2")); label55.BackColor = Color.FromArgb((int)myreg.GetValue("c3")); label54.BackColor = Color.FromArgb((int)myreg.GetValue("c4")); label53.BackColor = Color.FromArgb((int)myreg.GetValue("c5")); label52.BackColor = Color.FromArgb((int)myreg.GetValue("c6")); label51.BackColor = Color.FromArgb((int)myreg.GetValue("c7")); } catch (Exception ex) { MessageBox.Show("Внимание! Цветовая схема не настроена! Прежде чем приступать \nк работе с программой, настройте цветовую схему."); } } else { Form_Connect_Options f_conn = new Form_Connect_Options(); // f_conn.Owner = this; f_conn.ShowDialog(); } } else { Form_Connect_Options f_conn = new Form_Connect_Options(); // f_conn.Owner = this; f_conn.ShowDialog(); } }