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"); } }
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 btnOk_Click(object sender, EventArgs e) { //Save Jobs try { using (myQualityClass _qualityClass = new myQualityClass(Program._cnnString)) { StringBuilder jobId = new StringBuilder(txtJobId.Text); StringBuilder jobName = new StringBuilder(txtJobName.Text.Trim()); _qualityClass.addNewJob(jobId,jobName); jobId.Clear(); jobName.Clear(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }