访问oracle数据库

来源：互联网发布：字幕软件aegisub 编辑：程序博客网时间：2024/05/16 05:32

1。web.config ----appSettings--<add key="LimsConnection" value="data source=yzlims;user id=lims;password = lims"/>

2. c#代码中

using System.Data.OracleClient;
public DataTable GetLimsTimeInSpace(string S_SAMPLE_NAME, string S_SAMPLING_P_N,DateTime startTime, DateTime endTime)
        {
            DataTable dt = new DataTable();

            OracleConnection conn = new System.Data.OracleClient.OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["LimsConnection"]);
            try
            {
                if (conn.State != ConnectionState.Open)
               conn.Open ();
                string strSql = string.Format(@"select distinct( s_sampled_date)
                                      from (select row_number() over(order by s_sampled_date desc) rn, t.*
                                              from yzlims.xt_table t
                                             where s_sampled_date <=
                                                   to_date('{0}', 'yyyy-mm-dd hh24:mi:ss')
                                               and s_sampled_date >=
                                                   to_date('{1}', 'yyyy-mm-dd hh24:mi:ss')
                                               and S_SAMPLING_P_NAME LIKE '%{2}%')
                                      ", endTime.AddHours(23).AddMinutes(59).AddSeconds(59), startTime, S_SAMPLING_P_N.Trim() + "/" + S_SAMPLE_NAME.Trim());

OracleCommand cmd = new OracleCommand();

                    cmd.Connection = conn;
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = strSql;
                    DataSet ds = new DataSet();
                    OracleDataAdapter da = new OracleDataAdapter(cmd);
                    da.Fill(ds);
                    dt = ds.Tables[0];
                    cmd.Dispose();
                    da.Dispose();

                IComparer Compare = new myReverserClass();
            }
            finally
            {
                conn.Close();
            }

return dt;