//Constructor public EN1999_1_1Form() { InitializeComponent(); dat_conn = DatabaseConnection.getInstance(); this.loadCombo1(); //loading data to combobox1 dtform = new DataTableForm(1); //for inicializing of object default value is 1 }
private void TableDataToolStripMenuItem_Click(object sender, EventArgs e) { dtform = new DataTableForm(typ_prierezu); if (dtform.ShowDialog() == DialogResult.Cancel) { naplnZoznamy(); updateDataGridView(); } }
private void naplnZoznamy() { string combo1 = comboBox1.Text; //actual text in combobox1 string combo2 = comboBox2.Text; //actual text in combobox2 string unit = "nedef"; CheckedListInfo chLInfo; this.deleteLists(); #region choosing typ_prierezu from database // checking type of cross-section from database for further processing string sql = "Select csprofshape from sections where csprof_name like '" + combo2 + "'"; dat_reader = dat_conn.getDBReader(sql); dat_reader.Read(); try { typ_prierezu = Convert.ToByte(dat_reader.GetValue(0).ToString()); } catch (InvalidOperationException) { /*MessageBox.Show("Set up cross-section in ComboBox Cross-section, please!");*/ //This type of exception appears mainly because text in combo2 is empty } catch (FormatException) { } #endregion dtform = new DataTableForm(typ_prierezu); try { #region filling lists with actual variables,their names in table and units chLInfo = dtform.ZozChLInfos[0, 0]; //for checkListbox 4. (STEEL) for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++) { //if the variable is checked in checkedlistbox4 then add this variable to list of variables if (chLInfo.ZoznamZasktPrem[i]) { zoznamNazvyPremeSTEEL.Add(chLInfo.ZoznamPremennych[i]); //variables for database zoznamMenuNazvySTEEL.Add(chLInfo.ZoznamZobrazPremennych[i]); //variables names for table zoznamMenuJednotkySTEEL.Add(chLInfo.ZoznamJednotiek[i]); //units of these variables } } chLInfo = dtform.ZozChLInfos[typ_prierezu, 0]; //pre checkListbox 1. for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++) { if (chLInfo.ZoznamZasktPrem[i]) { zoznamNazvyPremennych.Add(chLInfo.ZoznamPremennych[i]); //premenne do databazy zoznamMenuNazvy.Add(chLInfo.ZoznamZobrazPremennych[i]); //premenne zobrazene v tabulke zoznamMenuJednotky.Add(chLInfo.ZoznamJednotiek[i]); //MessageBox.Show(chLInfo.ZoznamPremennych[i] + "\n" + chLInfo.ZoznamZobrazPremennych[i] + "\n" // + chLInfo.ZoznamJednotiek[i]); } } chLInfo = dtform.ZozChLInfos[typ_prierezu, 1]; //pre checkListbox 2. for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++) { if (chLInfo.ZoznamZasktPrem[i]) { zoznamMenuNazvy.Add(chLInfo.ZoznamPremennych[i]); //premenne zadavane pouzivatelom zoznamNazvyPremennych.Add(chLInfo.ZoznamPremennych[i]); //MessageBox.Show(chLInfo.ZoznamPremennych[i]); } } #endregion #region loading values for variables from database //getting values of actual choosen variables of STEEL for (int i = 0; i < zoznamNazvyPremeSTEEL.Count; i++) { if (combo1 != "" && comboBox1.SelectedIndex != 0 && combo2 != "") { sql = "Select " + zoznamNazvyPremeSTEEL[i] + " from Steel where mat_name like '"+combo1+"'"; dat_reader = dat_conn.getDBReader(sql); dat_reader.Read(); try { zoznamMenuHodnotySTEEL.Add(dat_reader.GetValue(0).ToString()); } catch (InvalidOperationException) { } } } //getting values of actual choosen variables of cross sections //if variable is from user input - getting character from database that determines //that it is user input,adding unit for this variable ,other visual style for this //variable in datagrid is defined in method updateDataGridView() for (int i = 0; i < zoznamNazvyPremennych.Count; i++) { if (combo2 != "" && combo1 != "") { sql = "Select "; switch (zoznamNazvyPremennych[i]) { #region Table - user-data cells basic loading - database "user" column // Internal forces in section case "N": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break; case "Vy": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break; case "Vz": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break; case "Mx": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "My": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "Mz": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; // End bending moments case "My.a": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "My.b": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "Mz.a": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "Mz.b": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; // Midspan bending moments case "My.s": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; case "Mz.s": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break; // Annex A - Table A.2 input data case "My.Ed.x": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break; case "Mz.Ed.x": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break; case "Deflection.y.x": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break; case "Deflection.z.x": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break; // Lateral buckling Mcr variables case "C1y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break; case "C2y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break; case "C3y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break; case "kz_LT": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break; case "kw_LT": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break; // Beam properties - lenght case "L_teor": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; case "L_y_buck": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; case "L_z_buck": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; case "L_y_LT": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; case "L_z_LT": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; case "L_T": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break; // Cross-section data case "Anet": sql += "user"; unit = "mm2"; zoznamMenuJednotky.Add(unit); break; // Variables - Torsion NAD CZE case "MEd.T": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break; case "VEd.T": sql += "user"; unit = "[kN]"; zoznamMenuJednotky.Add(unit); break; case "e.T": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break; #endregion default: sql += zoznamNazvyPremennych[i]; break; } sql += " from SECTIONS where csprof_name like '" + combo2 + "'"; dat_reader = dat_conn.getDBReader(sql); dat_reader.Read(); try { zoznamMenuHodnoty.Add(dat_reader.GetValue(0).ToString());//zapise sa hodnota do zoznamu } catch (InvalidOperationException) { } } } #endregion } catch (NullReferenceException) { MessageBox.Show("There is nothing to display! Please choose some variables in Options -> Data table list."); } }