web 2.0

VB.NET & DataReader()

VB.NET & DataAdapter() The DataReader provides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited.

ShotDev Focus:
- VB.NET & DataReader()

Example

DataReader.aspx

  1.  <%@ Import Namespace="System.Data"%>  
  2. <%@ Import Namespace="System.Data.OleDb"%>  
  3. <%@ Page Language="VB" %>  
  4. <script runat="server">  
  5.   
  6. Dim objConn As System.Data.OleDb.OleDbConnection  
  7. Dim objCmd As System.Data.OleDb.OleDbCommand  
  8. Dim strConnString As String  
  9. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("database/mydatabase.mdb")&";Jet OLEDB:Database Password=;"  
  10. objConn = New System.Data.OleDb.OleDbConnection(strConnString)  
  11. objConn.Open()  
  12.   
  13. Dim strSQL As String  
  14. strSQL = "SELECT * FROM customer"  
  15.   
  16. Dim dtReader As System.Data.OleDb.OleDbDataReader  
  17. objCmd = New System.Data.OleDb.OleDbCommand(strSQL, objConn)  
  18. dtReader = objCmd.ExecuteReader()  
  19.   
  20. '*** DataReader ***'  
  21.   
  22. dtReader.Close()  
  23. dtReader = Nothing  
  24. objConn.Close()  
  25. objConn = Nothing  
  26.   
  27. </script>  

.
.
.
Download this script.
Download

1 Star2 Stars3 Stars4 Stars5 Stars6 Stars7 Stars8 Stars9 Stars10 Stars (1 votes, average: 1.00 out of 10)
Loading ... Loading ...

Leave a Reply

You must be logged in to post a comment.