private void frmQuery_Load(object sender, EventArgs e) { string s_path = Application.StartupPath + "\\query\\"; string[] array_path = Directory.GetFiles(s_path); DataTable T = new DataTable(); DataColumn col = T.Columns.Add("SQL範本"); DataColumn col2 = T.Columns.Add("路徑"); col.DataType = System.Type.GetType("System.String"); col2.DataType = System.Type.GetType("System.String"); for (int j = 0; j < array_path.Length; j++) { DataRow row = T.NewRow(); row[0] = Path.GetFileNameWithoutExtension(array_path[j]); row[1] = array_path[j]; T.Rows.Add(row); } gridControl1.DataSource = T; Func.OracleDbConn(); OracleCommand cmd = new OracleCommand(); cmd.Connection = Func.MyOraSqlConn; cmd.CommandText = "alter session set current_schema=" + Func.t100_current_user; cmd.ExecuteNonQuery(); string sql = "select max(psos002) c from psos_t where 1=1 and psosent=" + Func.t100_ent + " and psossite=" + Func.AA(Func.t100_site) + " and psos001=" + Func.AA(Func.t100_aps); cmd.CommandText = sql; txt_max_ver.Text = cmd.ExecuteScalar().ToString(); }