1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
|
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Oracle.DataAccess.Client;
namespace ExternalSupplier
{
public partial class Study_Group : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection();
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ExternalSupplier"].ConnectionString;
conn.ConnectionString = connectionString;
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "PARAMETER_TABLES.Sp_GetStudy_Information";
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter emp_cur = new OracleParameter();
emp_cur.OracleDbType = OracleDbType.RefCursor;
emp_cur.Direction = ParameterDirection.Output;
cmd.Parameters.Add(emp_cur);
OracleDataReader reader = cmd.ExecuteReader();
OracleDataAdapter dataAdapter = new OracleDataAdapter();
DataSet oracleDataSet = new DataSet();
dataAdapter.Fill(oracleDataSet, (Oracle.DataAccess.Types.OracleRefCursor)emp_cur.Value);
gvStudyGroup.DataSource = oracleDataSet;
}
}
} |
Partager