Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Friday, November 11, 2022

Oracle connection string , read, write query in ASP.NET

 using Oracle.ManagedDataAccess.Client;

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;


namespace cadre_mgmt_system.DataRepository

{

    public class OracleDAL

    {

        //public static readonly string connectionString = ConfigurationManager.ConnectionStrings["OracleConn"].ConnectionString;

        OracleConnection conn;

        public OracleDAL()

        {

            conn = new OracleConnection("user id=readonly;password=readonly;data source=192.168.101.29:1522/PROD");

        }

        //public DataSet Read(string StoredProcedure, SqlParameter[] param)

        //{

        //    OracleCommand cmd = new OracleCommand(StoredProcedure, conn);

        //    cmd.CommandType = CommandType.StoredProcedure;

        //    if (param != null)

        //        cmd.Parameters.AddRange(param.ToArray());

        //    OracleDataAdapter da = new OracleDataAdapter(cmd);

        //    DataSet ds = new DataSet();

        //    conn.Open();

        //    da.Fill(ds);

        //    conn.Close();

        //    return ds;

        //}

        public DataSet Read(string Query)

        {

            //Query = "select * from XXICAR_EMPLOYEE_BANK_DETAILS";

            OracleCommand cmd = new OracleCommand(Query, conn);

            OracleDataAdapter da = new OracleDataAdapter(cmd);

            DataSet ds = new DataSet();

            conn.Open();

            da.Fill(ds);

            conn.Close();

            return ds;

        }