본문 바로가기
C#

c# oracle에서 연동, listbox에 보여주기.

by improve 2024. 2. 8.

using Oracle.ManagedDataAccess.Client;

namespace WinFormsApp3
{
    public partial class Form1 : Form
    {
        String connectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xe)));User Id=hr;Password=1234;";

        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            listBox1.Items.Clear();
            OracleConnection conn = new OracleConnection(connectionString);
            conn.Open();
            OracleCommand cmd = new OracleCommand("select * from 학생", conn);
            OracleDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                listBox1.Items.Add(reader.GetString(0));

                listBox1.Items.Add(reader.GetString(0) + "\t" +
                                    reader.GetString(1) + "\t" +
                                    reader.GetString(2) + "\t" +
                                    reader.GetString(3) + "\t" +
                                    reader.GetString(4)
                );
                //                MessageBox.Show(reader["학번"].ToString());
            }
            reader.Close();
            conn.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            listBox1.Items.Add("문자열 입니다.");
        }

        private void button3_Click(object sender, EventArgs e)
        {
            listBox1.Items.Insert(0, "문자열 추가");
        }
    }
}

'C#' 카테고리의 다른 글

라벨 이용하기  (0) 2024.02.16
C# 콘솔  (0) 2024.02.13
계산기  (0) 2024.02.08
visual studio 2022 와 oracle 연동 해보기  (0) 2024.02.07
C#  (0) 2024.02.02