2008/C#2008. 10. 9. 16:18



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(); }


        }
    }
}

Posted by penguindori