VB.NET & System.Data.OracleClient - ExecuteReader() - How to learn Connector/NET ADO.NET component System.Data.OracleClient namespace is the .NET Framework Data Provider for Oracle data source, Using the ExecuteReader method Sends the CommandText to the Connection and builds a DataReader (Oracle Server Database)
ShotDev Focus:
- VB.NET & System.Data.OracleClient - ExecuteReader()
Example
ExecuteReader.aspx
- <%@ Import Namespace="System.Data"%>
- <%@ Import Namespace="System.Data.OracleClient"%>
- <%@ Page Language="VB" %>
- <script runat="server">
- Dim objConn As System.Data.OracleClient.OracleConnection
- Dim objCmd As System.Data.OracleClient.OracleCommand
- Sub Page_Load(sender As Object, e As EventArgs)
- Dim strConnString As String
- strConnString = "Data Source=TCDB;User Id=myuser;Password=mypassword;"
- objConn = New System.Data.OracleClient.OracleConnection(strConnString)
- objConn.Open()
- BindData()
- End Sub
- Sub BindData()
- Dim strSQL As String
- strSQL = "SELECT * FROM customer"
- Dim dtReader As System.Data.OracleClient.OracleDataReader
- objCmd = New System.Data.OracleClient.OracleCommand(strSQL, objConn)
- dtReader = objCmd.ExecuteReader()
- '*** BindData to Repeater ***'
- myRepeater.DataSource = dtReader
- myRepeater.DataBind()
- dtReader.Close()
- dtReader = Nothing
- End Sub
- Sub Page_UnLoad()
- objConn.Close()
- objConn = Nothing
- End Sub
- </script>
- <html>
- <head>
- <title>ShotDev.Com Tutorial</title>
- </head>
- <body>
- <form id="form1" runat="server">
- <asp:Repeater id="myRepeater" runat="server">
- <HeaderTemplate>
- <table border="1">
- <tr>
- <th>CustomerID</th>
- <th>Name</th>
- <th>Email</th>
- <th>CountryCode</th>
- <th>Budget</th>
- <th>Used</th>
- </tr>
- </HeaderTemplate>
- <ItemTemplate>
- <tr>
- <td align="center"><%#Container.DataItem("CustomerID") %></td>
- <td><%#Container.DataItem("Name") %></td>
- <td><%#Container.DataItem("Email") %></td>
- <td align="center"><%#Container.DataItem("CountryCode") %></td>
- <td align="right"><%#Container.DataItem("Budget") %></td>
- <td align="right"><%#Container.DataItem("Used") %></td>
- </tr>
- </ItemTemplate>
- </asp:Repeater>
- </form>
- </body>
- </html>
Screenshot