public EN1993_1_1(string combo1, string combo2,bool item3,bool item4, bool item5, bool item6) { string sql1; string sql2; sql1 = "Select mat_num, mat_name, mat_prod_code_num, mat_prod_code_name1, mat_prod_code_name2, steel_grade_num, fy1, fu1, fy2, fu2, gamaM0, gamaM1, gamaM2, betaw, eta_shear, E, G, nu_pois, alpha_temp from Steel where mat_name like '" + combo1 + "'"; #region Database DATA-STEEL variables reader dat_conn = DatabaseConnection.getInstance(); dat_reader = dat_conn.getDBReader(sql1); try { while (dat_reader.Read()) { // STEEL DATABASE DATA #region Data list try { mat_num = Convert.ToInt16(dat_reader.GetValue(0).ToString()); } catch (FormatException) { } try { mat_name = dat_reader.GetValue(1).ToString(); } catch (FormatException) { } try { mat_prod_code_num = Convert.ToInt16(dat_reader.GetValue(2).ToString()); } catch (FormatException) { } try { mat_prod_code_name1 = dat_reader.GetValue(3).ToString(); } catch (FormatException) { } try { mat_prod_code_name2 = dat_reader.GetValue(4).ToString(); } catch (FormatException) { } try { steel_grade_num = Convert.ToInt32(dat_reader.GetValue(5).ToString()); } catch (FormatException) { } try { fy1 = Convert.ToDouble(dat_reader.GetValue(6).ToString()); } catch (FormatException) { } try { fu1 = Convert.ToDouble(dat_reader.GetValue(7).ToString()); } catch (FormatException) { } try { fy2 = Convert.ToDouble(dat_reader.GetValue(8).ToString()); } catch (FormatException) { } try { fu2 = Convert.ToDouble(dat_reader.GetValue(9).ToString()); } catch (FormatException) { } try { gamaM0 = Convert.ToDouble(dat_reader.GetValue(10).ToString()); } catch (FormatException) { } try { gamaM1 = Convert.ToDouble(dat_reader.GetValue(11).ToString()); } catch (FormatException) { } try { gamaM2 = Convert.ToDouble(dat_reader.GetValue(12).ToString()); } catch (FormatException) { } try { betaw = Convert.ToDouble(dat_reader.GetValue(13).ToString()); } catch (FormatException) { } try { eta_shear = Convert.ToDouble(dat_reader.GetValue(14).ToString()); } catch (FormatException) { } try { _E = Convert.ToDouble(dat_reader.GetValue(15).ToString()); } catch (FormatException) { } try { _G = Convert.ToDouble(dat_reader.GetValue(16).ToString()); } catch (FormatException) { } try { nu_pois = Convert.ToDouble(dat_reader.GetValue(17).ToString()); } catch (FormatException) { } try { alpha_temp = Convert.ToDouble(dat_reader.GetValue(18).ToString()); } catch (FormatException) { } #endregion } } catch (FormatException) { } #endregion sql2 = "Select csprof_namenum, csprof_name, csprofshape, csprof_production, csprodcode1_name1, csprodcode1_name2, csprodcode2_name1, csprodcode2_name2, csproducer1, csproducer2, csprof_weight,h, b, bh, bd, tw, tf, r, r1, r2, r3, hi, d, d1, e, e_apostrof, ez, ey, w, w1, v, v1, v2, eel, epl, D_tube, t_tube, A, A_su, Af, Aw, Ay_v, Az_v, Av, Iy, Wy_el, Wy1, Wy2, Wy_pl, iy_r, Sy, Iz, Wz_el, Wz1, Wz2, Wz_pl, iz_r, Sz, IT, Wt, Iw, ss, ys, ym, Id, Ieta, Weta, ieta_r, Ixi, Wxi2, Wxi13,ixi_r, Iyz, omega_w, izf, iz1, ipc, ay, aeta, ip, ia, Ww1, Ww2, Sw3, iw1, k, a1, tg_fi, cy1, ty1, cz1, tz1, cy2, ty2, cz2, tz2 from sections where csprof_name like '" + combo2 + "'"; #region Database DATA-SECTIONS variables reader dat_conn = DatabaseConnection.getInstance(); dat_reader = dat_conn.getDBReader(sql2); try { while (dat_reader.Read()) { // CROSS-SECTION DATABASE DATA #region Data list // 0 - 9 try { csprof_namenum = Convert.ToInt16(dat_reader.GetValue(0).ToString()); } catch (FormatException) { } try { csprof_name = dat_reader.GetValue(1).ToString(); } catch (FormatException) { } try { csprofshape = Convert.ToInt16(dat_reader.GetValue(2).ToString()); } catch (FormatException) { } try { csprof_production = Convert.ToInt16(dat_reader.GetValue(3).ToString()); } catch (FormatException) { } try { csprodcode1_name1 = dat_reader.GetValue(4).ToString(); } catch (FormatException) { } try { csprodcode1_name2 = dat_reader.GetValue(5).ToString(); } catch (FormatException) { } try { csprodcode2_name1 = dat_reader.GetValue(6).ToString(); } catch (FormatException) { } try { csprodcode2_name2 = dat_reader.GetValue(7).ToString(); } catch (FormatException) { } try { csproducer1 = dat_reader.GetValue(8).ToString(); } catch (FormatException) { } try { csproducer2 = dat_reader.GetValue(9).ToString(); } catch (FormatException) { } // 10-19 csprof_weight = Convert.ToDouble(dat_reader.GetValue(10).ToString()); try { h = Convert.ToDouble(dat_reader.GetValue(11).ToString()); } catch (FormatException) { } try { b = Convert.ToDouble(dat_reader.GetValue(12).ToString()); } catch (FormatException) { } try { bh = Convert.ToDouble(dat_reader.GetValue(13).ToString()); } catch (FormatException) { } try { bd = Convert.ToDouble(dat_reader.GetValue(14).ToString()); } catch (FormatException) { } try { tw = Convert.ToDouble(dat_reader.GetValue(15).ToString()); } catch (FormatException) { } try { tf = Convert.ToDouble(dat_reader.GetValue(16).ToString()); } catch (FormatException) { } try { r = Convert.ToDouble(dat_reader.GetValue(17).ToString()); } catch (FormatException) { } try { r1 = Convert.ToDouble(dat_reader.GetValue(18).ToString()); } catch (FormatException) { } try { r2 = Convert.ToDouble(dat_reader.GetValue(19).ToString()); } catch (FormatException) { } // 20-29 try { r3 = Convert.ToDouble(dat_reader.GetValue(20).ToString()); } catch (FormatException) { } try { hi = Convert.ToDouble(dat_reader.GetValue(21).ToString()); } catch (FormatException) { } try { d = Convert.ToDouble(dat_reader.GetValue(22).ToString()); } catch (FormatException) { } try { d1 = Convert.ToDouble(dat_reader.GetValue(23).ToString()); } catch (FormatException) { } try { e = Convert.ToDouble(dat_reader.GetValue(24).ToString()); } catch (FormatException) { } try { e_apostrof = Convert.ToDouble(dat_reader.GetValue(25).ToString()); } catch (FormatException) { } try { ez = Convert.ToDouble(dat_reader.GetValue(26).ToString()); } catch (FormatException) { } try { ey = Convert.ToDouble(dat_reader.GetValue(27).ToString()); } catch (FormatException) { } try { w = Convert.ToDouble(dat_reader.GetValue(28).ToString()); } catch (FormatException) { } try { w1 = Convert.ToDouble(dat_reader.GetValue(29).ToString()); } catch (FormatException) { } // 30-39 try { v = Convert.ToDouble(dat_reader.GetValue(30).ToString()); } catch (FormatException) { } try { v1 = Convert.ToDouble(dat_reader.GetValue(31).ToString()); } catch (FormatException) { } try { v2 = Convert.ToDouble(dat_reader.GetValue(32).ToString()); } catch (FormatException) { } try { eel = Convert.ToDouble(dat_reader.GetValue(33).ToString()); } catch (FormatException) { } try { epl = Convert.ToDouble(dat_reader.GetValue(34).ToString()); } catch (FormatException) { } try { _D_tube = Convert.ToDouble(dat_reader.GetValue(35).ToString()); } catch (FormatException) { } try { t_tube = Convert.ToDouble(dat_reader.GetValue(36).ToString()); } catch (FormatException) { } try { _A = Convert.ToDouble(dat_reader.GetValue(37).ToString()); } catch (FormatException) { } try { _A_su = Convert.ToDouble(dat_reader.GetValue(38).ToString()); } catch (FormatException) { } try { _Af = Convert.ToDouble(dat_reader.GetValue(39).ToString()); } catch (FormatException) { } // 40-49 try { _Aw = Convert.ToDouble(dat_reader.GetValue(40).ToString()); } catch (FormatException) { } try { _Ay_v = Convert.ToDouble(dat_reader.GetValue(41).ToString()); } catch (FormatException) { } try { _Az_v = Convert.ToDouble(dat_reader.GetValue(42).ToString()); } catch (FormatException) { } try { _Av = Convert.ToDouble(dat_reader.GetValue(43).ToString()); } catch (FormatException) { } try { _Iy = Convert.ToDouble(dat_reader.GetValue(44).ToString()); } catch (FormatException) { } try { _Wy_el = Convert.ToDouble(dat_reader.GetValue(45).ToString()); } catch (FormatException) { } try { _Wy1 = Convert.ToDouble(dat_reader.GetValue(46).ToString()); } catch (FormatException) { } try { _Wy2 = Convert.ToDouble(dat_reader.GetValue(47).ToString()); } catch (FormatException) { } try { _Wy_pl = Convert.ToDouble(dat_reader.GetValue(48).ToString()); } catch (FormatException) { } try { iy_r = Convert.ToDouble(dat_reader.GetValue(49).ToString()); } catch (FormatException) { } // 50-59 try { _Sy = Convert.ToDouble(dat_reader.GetValue(50).ToString()); } catch (FormatException) { } try { _Iz = Convert.ToDouble(dat_reader.GetValue(51).ToString()); } catch (FormatException) { } try { _Wz_el = Convert.ToDouble(dat_reader.GetValue(52).ToString()); } catch (FormatException) { } try { _Wz1 = Convert.ToDouble(dat_reader.GetValue(53).ToString()); } catch (FormatException) { } try { _Wz2 = Convert.ToDouble(dat_reader.GetValue(54).ToString()); } catch (FormatException) { } try { _Wz_pl = Convert.ToDouble(dat_reader.GetValue(55).ToString()); } catch (FormatException) { } try { iz_r = Convert.ToDouble(dat_reader.GetValue(56).ToString()); } catch (FormatException) { } try { _Sz = Convert.ToDouble(dat_reader.GetValue(57).ToString()); } catch (FormatException) { } try { _IT = Convert.ToDouble(dat_reader.GetValue(58).ToString()); } catch (FormatException) { } try { _Wt = Convert.ToDouble(dat_reader.GetValue(59).ToString()); } catch (FormatException) { } // 60-69 try { _Iw = Convert.ToDouble(dat_reader.GetValue(60).ToString()); } catch (FormatException) { } try { ss = Convert.ToDouble(dat_reader.GetValue(61).ToString()); } catch (FormatException) { } try { ys = Convert.ToDouble(dat_reader.GetValue(62).ToString()); } catch (FormatException) { } try { ym = Convert.ToDouble(dat_reader.GetValue(63).ToString()); } catch (FormatException) { } try { _Id = Convert.ToDouble(dat_reader.GetValue(64).ToString()); } catch (FormatException) { } try { _Ieta = Convert.ToDouble(dat_reader.GetValue(65).ToString()); } catch (FormatException) { } try { _Weta = Convert.ToDouble(dat_reader.GetValue(66).ToString()); } catch (FormatException) { } try { ieta_r = Convert.ToDouble(dat_reader.GetValue(67).ToString()); } catch (FormatException) { } try { _Ixi = Convert.ToDouble(dat_reader.GetValue(68).ToString()); } catch (FormatException) { } try { _Wxi2 = Convert.ToDouble(dat_reader.GetValue(69).ToString()); } catch (FormatException) { } // 70-79 try { _Wxi13 = Convert.ToDouble(dat_reader.GetValue(70).ToString()); } catch (FormatException) { } try { ixi_r = Convert.ToDouble(dat_reader.GetValue(71).ToString()); } catch (FormatException) { } try { _Iyz = Convert.ToDouble(dat_reader.GetValue(72).ToString()); } catch (FormatException) { } try { omega_w = Convert.ToDouble(dat_reader.GetValue(73).ToString()); } catch (FormatException) { } try { izf = Convert.ToDouble(dat_reader.GetValue(74).ToString()); } catch (FormatException) { } try { iz1 = Convert.ToDouble(dat_reader.GetValue(75).ToString()); } catch (FormatException) { } try { ipc = Convert.ToDouble(dat_reader.GetValue(76).ToString()); } catch (FormatException) { } try { ay = Convert.ToDouble(dat_reader.GetValue(77).ToString()); } catch (FormatException) { } try { aeta = Convert.ToDouble(dat_reader.GetValue(78).ToString()); } catch (FormatException) { } try { ip = Convert.ToDouble(dat_reader.GetValue(79).ToString()); } catch (FormatException) { } // 80-89 try { ia = Convert.ToDouble(dat_reader.GetValue(80).ToString()); } catch (FormatException) { } try { _Ww1 = Convert.ToDouble(dat_reader.GetValue(81).ToString()); } catch (FormatException) { } try { _Ww2 = Convert.ToDouble(dat_reader.GetValue(82).ToString()); } catch (FormatException) { } try { _Sw3 = Convert.ToDouble(dat_reader.GetValue(83).ToString()); } catch (FormatException) { } try { iw1 = Convert.ToDouble(dat_reader.GetValue(84).ToString()); } catch (FormatException) { } try { k = Convert.ToDouble(dat_reader.GetValue(85).ToString()); } catch (FormatException) { } try { a1 = Convert.ToDouble(dat_reader.GetValue(86).ToString()); } catch (FormatException) { } try { tg_fi = Convert.ToDouble(dat_reader.GetValue(87).ToString()); } catch (FormatException) { } try { cy1 = Convert.ToDouble(dat_reader.GetValue(88).ToString()); } catch (FormatException) { } try { ty1 = Convert.ToDouble(dat_reader.GetValue(89).ToString()); } catch (FormatException) { } // 90-99 try { cz1 = Convert.ToDouble(dat_reader.GetValue(90).ToString()); } catch (FormatException) { } try { tz1 = Convert.ToDouble(dat_reader.GetValue(91).ToString()); } catch (FormatException) { } try { cy2 = Convert.ToDouble(dat_reader.GetValue(92).ToString()); } catch (FormatException) { } try { ty2 = Convert.ToDouble(dat_reader.GetValue(93).ToString()); } catch (FormatException) { } try { cz2 = Convert.ToDouble(dat_reader.GetValue(94).ToString()); } catch (FormatException) { } try { tz2 = Convert.ToDouble(dat_reader.GetValue(95).ToString()); } catch (FormatException) { } #endregion } } catch (FormatException) { } #endregion // Data from Form: EN1993-1-1MessageBoxes.cs this.item3_check = item3; this.item4_check = item4; this.item5_check = item5; this.item6_check = item6; }