private void SystematicsSelectButton_Click(object sender, EventArgs e) { OdbcDataReader rd; string IDs = DataManip.DataManip.GenerateSearchIDs(); if (ObrebSelectCombo.Text != "") { rd = SqlConnect.ExecuteDataReader("SELECT Count(*) AS c_liczba FROM ObjectTbl, RemarkTbl WHERE ObjectTbl.c_ID = RemarkTbl.c_object_ID AND ObjectTbl.c_code_ID=" + cCodeID + " AND ObjectTbl.c_syst_ID IN (" + IDs + ") AND RemarkTbl.c_value LIKE '#%'"); } else { MessageBox.Show("Wybierz obręb do dodania plików"); rd = null; } if (rd != null && rd.HasRows) { ObjectCountTBox.Text = rd["c_liczba"].ToString(); progressBar1.Maximum = int.Parse(rd["c_liczba"].ToString()); rd.Close(); GoButton.Enabled = progressBar1.Maximum != 0; } else { MessageBox.Show("rd.HasRows == 0 "); } }
public static DataTable FillDataTable(int ObrebID, int cCodeID) { string IDs = GenerateSearchIDs(); OdbcDataReader rd = SqlConnect.ExecuteDataReader("ObjectTbl.c_ID, RemarkTbl.c_value", "ObjectTbl, RemarkTbl", "ObjectTbl.c_ID = RemarkTbl.c_object_ID AND ObjectTbl.c_code_ID = " + cCodeID + " AND ObjectTbl.c_syst_ID IN (" + IDs + ") AND RemarkTbl.c_value LIKE '#%'"); DataTable dt = new DataTable(); dt.Load(rd); return(dt); }
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; }
public static void initDictionaryIDs() { OdbcDataReader data = SqlConnect.ExecuteDataReader("c_ordering_number, c_ID", "DictionaryEntryTbl", "c_dictionary_def_ID = 1 ORDER BY c_ordering_number"); while (data.Read()) { SłownikIDTypow.Add(int.Parse(data["c_ordering_number"].ToString()), int.Parse(data["c_ID"].ToString())); } data.Close(); }
public static void WyszukajArkusze() { ListaIDArkuszy.Clear(); OdbcDataReader rd = SqlConnect.ExecuteDataReader("c_ID", "SystematicsTbl", "c_parent_ID = " + Obreb.id); while (rd.Read()) { ListaIDArkuszy.Add(int.Parse(rd["c_ID"].ToString())); } rd.Close(); }
private void button1_Click(object sender, EventArgs e) { OdbcDataReader dr = SqlConnect.ExecuteDataReader("*", "ObjectTbl, G_SZKICE", "ObjectTbl.c_ID = G_SZKICE.c_object_ID AND ObjectTbl.c_ID = " + c_ID); DataTable table = new DataTable(); table.Load(dr); ObjectDetail objectDetail = new ObjectDetail(table.Rows[0], new System.Drawing.Point(this.Location.X - 352, this.Location.Y)); objectDetail.Show(this); dr.Close(); }
private void ObrebSelectCombo_SelectedIndexChanged(object sender, EventArgs e) { GoButton.Enabled = false; string temp = ObrebSelectCombo.Text.Remove(0, ObrebSelectCombo.Text.IndexOf(' ')); temp = temp.Remove(0, 3); OdbcDataReader rd = SqlConnect.ExecuteDataReader("c_ID,c_name,c_description,c_parent_ID", "SystematicsTbl", "c_description LIKE '" + temp + "'"); rd.Read(); Obreb.Fill(int.Parse(rd["c_ID"].ToString()), int.Parse(rd["c_parent_ID"].ToString()), rd["c_name"].ToString(), rd["c_description"].ToString()); rd.Close(); DataManip.DataManip.WyszukajArkusze(); }
public ObjectDetail(DataRow row, Point location) { InitializeComponent(); label5.Text = row["c_ID"].ToString(); label6.Text = row["c_Identifier"].ToString(); OdbcDataReader read = SqlConnect.ExecuteDataReader("*", "DictionaryEntryTbl", "c_ID = " + row["OPT"].ToString()); read.Read(); label7.Text = read["c_value"].ToString(); read.Close(); read = SqlConnect.ExecuteDataReader("*", "DictionaryEntryTbl", "c_ID = " + row["KRG"].ToString()); read.Read(); label8.Text = read["c_value"].ToString(); read.Close(); this.Location = location; }
public static void FillObrebSelectCombo(string JEwidencyjnaText, ComboBox ObrebSelectCombo) { if (ObrebSelectCombo.Items.Count < 1) { OdbcDataReader rd = SqlConnect.ExecuteDataReader("SystematicsTbl.c_ID,c_parent_ID,c_name,c_description", "SystematicsTbl, (SELECT c_ID FROM SystematicsTbl WHERE c_name LIKE '" + JEwidencyjnaText + "') AS querry", "SystematicsTbl.c_parent_ID = querry.c_ID ORDER BY c_name;"); if (rd.HasRows) { string name; while (rd.Read()) { name = rd["c_name"].ToString() + " - " + rd["c_description"].ToString(); ObrebSelectCombo.Items.Add(name); } } rd.Close(); } }
public static void FillPowiatSelectCombo(ComboBox PowiatSelectCombo) { if (PowiatSelectCombo.Items.Count < 1) { OdbcDataReader rd1 = SqlConnect.ExecuteDataReader("c_ID", "SystematicsTbl", "c_name LIKE '30'"); rd1.Read(); string test = rd1["c_ID"].ToString(); rd1.Close(); OdbcDataReader rd = SqlConnect.ExecuteDataReader("c_ID,c_name,c_description", "SystematicsTbl", "c_parent_ID = " + test); if (rd.HasRows) { string name; while (rd.Read()) { name = rd["c_name"].ToString() + " - " + rd["c_description"].ToString(); PowiatSelectCombo.Items.Add(name); } } rd.Close(); PowiatSelectCombo.SelectedIndex = 0; } }