VB.NET & System.Data.SqlClient - ExecuteReader() - How to learn Connector/NET ADO.NET component System.Data.SqlClient namespace is the .NET Framework Data Provider for SQL Server data source, Using the ExecuteReader method Sends the CommandText to the Connection and builds a DataReader (SQL Server 2000,2005,2008 Database)
ShotDev Focus:
- VB.NET & System.Data.SqlClient - ExecuteReader()
Example
ExecuteReader.aspx
- <%@ Import Namespace="System.Data"%>
- <%@ Import Namespace="System.Data.SqlClient"%>
- <%@ Page Language="VB" %>
- <script runat="server">
- Dim objConn As System.Data.SqlClient.SqlConnection
- Dim objCmd As System.Data.SqlClient.SqlCommand
- Sub Page_Load(sender As Object, e As EventArgs)
- Dim strConnString As String
- strConnString = "Server=localhost;UID=sa;PASSWORD=;database=mydatabase;Max Pool Size=400;Connect Timeout=600;"
- objConn = New System.Data.SqlClient.SqlConnection(strConnString)
- objConn.Open()
- BindData()
- End Sub
- Sub BindData()
- Dim strSQL As String
- strSQL = "SELECT * FROM customer"
- Dim dtReader As System.Data.SqlClient.SqlDataReader
- objCmd = New System.Data.SqlClient.SqlCommand(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