ASP. NET Oracle Database Connection

1. Method 1
Using system. Data. oracleclient;

Public partial class _ default: system. Web. UI. Page
{
Protected void page_load (Object sender, eventargs E)
{
Oracleconnection conn = new oracleconnection ("Data Source = orcl; user id = base; Password = base ");
Oracledataadapter ad = new oracledataadapter ("select * From time_frame", Conn );

Dataset DS = new dataset ();
Ad. Fill (DS, "T ");

Foreach (datarow DR in DS. Tables ["T"]. Rows ){

Response. Write (Dr ["year"]. tostring () + "<br> ");
}

}
}
2. Method 2

<Connectionstrings>
<Add name = "oracleconn" connectionstring = "Data Source = orcl; user id = base; Password = base"/>
</Connectionstrings>

Using system. Data. oracleclient;

/// <Summary>
/// Summary of data
/// </Summary>
Public class data
{
Private string connstring;

/// <Summary>
///
/// </Summary>
/// <Param name = "strconnname"> "oracleconn" </param>
Public Data (string strconnname)
{
//
// Todo: add the constructor logic here
//
This. connstring = system. Web. configuration. webconfigurationmanager. connectionstrings [strconnname]. connectionstring;
}

/// <Summary>
///
/// </Summary>
/// <Returns> </returns>
Public dataset querytimeframe (){

String strsql = "select * From time_frame ";
Dataset DS = new dataset ();
DS = This. querydata (strsql );
Return Ds;

}

/// <Summary>
///
/// </Summary>
/// <Param name = "struser"> </param>
/// <Returns> </returns>
Public dataset queryorganizationid (string struser)
{

String strsql = "select * From sysuser where useraccount = '" + struser + "'";
Dataset DS = new dataset ();
DS = This. querydata (strsql );
Return Ds;

}

/// <Summary>
///
/// </Summary>
/// <Param name = "strsql"> </param>
/// <Returns> </returns>
Private dataset querydata (string strsql ){

Oracleconnection conn = new oracleconnection (this. connstring );
Oracledataadapter dapt = new oracledataadapter (strsql, Conn );
Dataset DS = new dataset ();
Dapt. Fill (DS, "tab ");
Return Ds;

}
}