private void button8_Click(object sender, EventArgs e) { OraDbHelper a = new OraDbHelper(null); a.ConnectionString = "Data Source=KS_QAS_AY;User Id=FWASSY;Password=FWASSY;Connection Lifetime=120;"; string sSql = ""; sSql = " SELECT 'a' from dual "; DataTable dtStrip = a.ExecuteDataTable(sSql); a = new OraDbHelper(null); return; }
private void btnClick_Click(object sender, EventArgs e) { try { txtShow.Text = ""; ConfigurationManager.RefreshSection("appSettings"); txtShow.Text = ConfigurationManager.AppSettings["Test"]; txtShow.Text = Guid.NewGuid().ToString(); //timer1.Interval = 60000; //timer1.Start(); OraDbHelper _OraHelper = new OraDbHelper(null); _OraHelper.ConnectionString = "Data Source=KS_QAS_AY;Persist Security Info=True;User ID=FA;Password=FA;Unicode=True"; string sSql = ""; sSql = " SELECT STRIPID FROM FA.MARKOUT WHERE LOT= 'ENEB08N001.031' AND STEPNAME ='STD_CuMold_Step' ORDER BY CDT "; DataTable SSS = _OraHelper.ExecuteDataTable(sSql); string a = ConvertDataTableToXML(SSS); DataTable aaa = ConvertXMLToDataTable(a); if (aaa.Rows.Count > 0) { txtShow.Text = aaa.Rows[0][0].ToString(); } else { MessageBox.Show("没有资料"); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }