c#
using System.Data.OracleClient;
try
{string strconn = "Data Source=bb;Persist Security Info=True;" +
"User ID=SCOTT;Password=xxx;Unicode=True";
//bb是net manager中的【服务命名(サービス・ネーミング)】的名称
OracleConnection conn = new OracleConnection(strconn);//conn.Open();
string sql = "select * from emp";
OracleDataAdapter oda = new OracleDataAdapter(sql, conn);
DataSet ds = new DataSet();
oda.Fill(ds);
this.GridView1.DataSource = ds.Tables[0].DefaultView;
this.GridView1.DataBind();
//conn.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
VB.net
Dim strConn As String = "Data Source=bb;Persist Security Info=True;" +
"User ID=SCOTT;Password=xxx;Unicode=True"
Dim conn As OracleConnection = New OracleConnection(strConn)
Dim strSQL As String = "select * from emp"
Dim ds As DataSet = New DataSet()
Dim sda As OracleDataAdapter = New OracleDataAdapter(strSQL, strConn)
sda.Fill(ds, "Table")
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()