csharp_to_oracle.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;

namespace CSharp_to_Oracle
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        string connection_string = "user id=uni;password=oracle;" + 
            "data source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)" +
            "(HOST=localhost)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=orcl)) )";

        private void button1_Click(object sender, EventArgs e)
        {
            //Get Mobile by ID
            try
            {
                OracleConnection myConnection = new OracleConnection(connection_string);
                OracleCommand cmd = new OracleCommand("GET_STUDENT_MOBILE_BY_ID", myConnection);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add("STD_ID", OracleDbType.Int32).Value = textBox1.Text;
                cmd.Parameters.Add("STD_MOBILE", OracleDbType.Int32).Direction = ParameterDirection.Output;

                myConnection.Open();
                cmd.ExecuteNonQuery();

                textBox2.Text = cmd.Parameters["STD_MOBILE"].Value.ToString();

                myConnection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //Get Name by ID
            try
            {
                OracleConnection myConnection = new OracleConnection(connection_string);
                OracleCommand cmd = new OracleCommand("GET_STUDENT_NAME_BY_ID", myConnection);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add("STD_ID", OracleDbType.Int32).Value = textBox4.Text;
                cmd.Parameters.Add("STD_NAME", OracleDbType.Varchar2).Direction = ParameterDirection.Output;
                cmd.Parameters["STD_NAME"].Size = 20;

                myConnection.Open();
                cmd.ExecuteNonQuery();

                textBox3.Text = cmd.Parameters["STD_NAME"].Value.ToString();

                myConnection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                //Get Students by Courses Count
                OracleConnection myConnection = new OracleConnection(connection_string);
                OracleCommand cmd = new OracleCommand("GET_STUDENT_BY_Course_num", myConnection);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add("Course_num", OracleDbType.Int32).Value = textBox5.Text;
                cmd.Parameters.Add("students", OracleDbType.RefCursor).Direction = ParameterDirection.Output;


                myConnection.Open();
                cmd.ExecuteNonQuery();

                OracleDataReader reader1 = ((OracleRefCursor)cmd.Parameters["students"].Value).GetDataReader();
                dataGridView1.Columns.Clear();
                dataGridView1.Rows.Clear();
                for (int i = 0; i < reader1.FieldCount; i++)
                {
                    dataGridView1.Columns.Add(reader1.GetName(i), reader1.GetName(i));
                }
                while(reader1.Read())
                {
                    string[] row = new string[reader1.FieldCount];
                    for (int i = 0; i < reader1.FieldCount; i++)
                    {
                        row[i] = reader1.GetValue(i).ToString();
                    }
                    dataGridView1.Rows.Add(row);
                }
                reader1.Close();
                myConnection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}