세우세상 -> 이전 : http://doldolcoding.tistory.com/

안녕하세요. 박세우 입니다.

Class로 만들어서 가져오는 습관이 되다 보니 통으로 미처 기술해 주지 못한 부분을 파란색으로 표시하였습니다.

;; ㅠㅠ 제송합니다. 윈폼 요청하신 부분을 개발 중에 정신이 없어서 ;; 사소한 부분을 발견하지 못했네요;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.OracleClient;

namespace Login

{

    public partial class Form2 : Form

    {

        OracleConnection oConn;

        OracleCommand oComm;

        OracleParameter[] oPar;

        public Form2()

        {

            InitializeComponent();

        }

        private void Form2_Load(object sender, EventArgs e)

        {

            oConn = new OracleConnection("Data Source=mi;User ID=midas;Password=midas123");

        }

        private void button1_Click(object sender, EventArgs e)

        {

            StringBuilder sbSql = new StringBuilder();

            oConn.Open();

            try

            {

                sbSql.Append(" select userid,userpwd,username  ");

                sbSql.Append("  from midas_user ");

                sbSql.Append("  WHERE userid  = :userid ");

                sbSql.Append("  AND userpwd  = :userpwd ");

                oPar = new OracleParameter[2];

                oPar[0] = new OracleParameter(":userid", textBox1.Text);

                oPar[1] = new OracleParameter(":userpwd", textBox2.Text);

                oComm = new OracleCommand(sbSql.ToString(), oConn);

                oComm.Parameters.Add(oPar[0]);

               oComm.Parameters.Add(oPar[1]);

                OracleDataReader dr = oComm.ExecuteReader(CommandBehavior.CloseConnection);

                oComm.Parameters.Clear();

                dr.Read();

                MessageBox.Show(dr["USERNAME"].ToString());

                MessageBox.Show(dr["userid"].ToString());

            }

            catch (Exception ex) { string ok = ex.Message.ToString(); }

        }

    }

}

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
using System.IO;

namespace Hynix.Core
{
    /// <summary>
    /// Sql Command 실행을 도와주는 클래스
    /// </summary>
    public class SqlHelper
    {
        public static void ExcuteCommand(string strConn, string strCmd)
        {
            ExcuteCommand(strConn, strCmd, false, null);
        }

        public static void ExcuteCommand(SqlTransaction tran, string strCmd)
        {
            ExcuteCommand(tran, strCmd, false, null);
        }

        public static void ExcuteCommand(SqlTransaction tran, string strCmd, bool IsSP, SqlParameter[] oParams)
        {
            SqlCommand oCmd = new SqlCommand(strCmd, tran.Connection, tran);
            oCmd.CommandTimeout = int.Parse(Config.Instance.GetValue("TIMEOUT"));

            if (IsSP == true) { oCmd.CommandType = CommandType.StoredProcedure; }

            if (oParams != null)
            {
                for (int i = 0; i < oParams.Length; i++)
                {
                    oCmd.Parameters.Add(oParams[i]);
                }
            }

            oCmd.ExecuteNonQuery();
        }

        public static void ExcuteCommand(string strConn, string strCmd, bool IsSP, SqlParameter[] oParams)
        {
            if (strConn.IndexOf("Connect Timeout") < 0)
            {
                strConn += ";Connect Timeout=" + Config.Instance.GetValue("TIMEOUT") + ";";
            }

            SqlConnection oConn = new SqlConnection(strConn);
            SqlCommand oCmd = new SqlCommand(strCmd, oConn);
            oCmd.CommandTimeout = int.Parse(Config.Instance.GetValue("TIMEOUT"));

            if (IsSP==true)
            {
                oCmd.CommandType = CommandType.StoredProcedure;

                if (oParams != null)
                {
                    for (int i = 0; i < oParams.Length; i++)
                    {
                        oCmd.Parameters.Add(oParams[i]);
                    }
                }
            }

            oConn.Open();
            oCmd.ExecuteNonQuery();
            oConn.Close();
        }

        public static DataSet ExcuteDataSet(string strConn, string strCmd)
        {
            return ExcuteDataSet(strConn, strCmd, false, null);
        }

        public static DataSet ExcuteDataSet(string strConn, string strCmd, bool IsSP, SqlParameter[] oParams)
        {
            if (strConn.IndexOf("Connect Timeout") < 0)
            {
                strConn += ";Connect Timeout=" + Config.Instance.GetValue("TIMEOUT") + ";";
            }

            SqlConnection oConn = new SqlConnection(strConn);
            SqlCommand oCmd = new SqlCommand(strCmd, oConn);
            oCmd.CommandTimeout = int.Parse(Config.Instance.GetValue("TIMEOUT"));

            if (IsSP==true)
            {
                oCmd.CommandType = CommandType.StoredProcedure;

                if (oParams != null)
                {
                    for (int i = 0; i < oParams.Length; i++)
                    {
                        oCmd.Parameters.Add(oParams[i]);
                    }
                }
            }

            SqlDataAdapter da = new SqlDataAdapter(oCmd);

            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds;
        }
    }
}