private void btnGetDataBases_Click(object sender, EventArgs e) { try { using (myQualityClass _myClass = new myQualityClass(Program._cnnStringMaster) ) { DataTable T= _myClass.getSqlData("SELECT name from sys.databases where name like 'db%'"); this.cmbSqlDataBases.Items.Clear(); lsbSqlFild.Items.Clear(); foreach (DataRow R in T.Rows) { this.cmbSqlDataBases.Items.Add(R[0].ToString()); } T.Dispose(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void frmNewJob_Load(object sender, EventArgs e) { using (myQualityClass _myClass = new myQualityClass(Program._cnnString)) { DataTable T = _myClass.getSqlData("select max(jobid) from jobs"); int i = 0; try { i = int.Parse(T.Rows[0].ToString()); } catch { i++; } txtJobId.Text = i.ToString("###,###,000"); } }