ASP.NET(vb.net) & CSV and ODBC - System.Data.Odbc - In this article we will example scripts ASP.NET how to read CSV using ODBC (System.Data.Odbc)
ShotDev Focus:
- ASP.NET(vb.net) & CSV and ODBC - System.Data.Odbc
Example
AspNetReadCSVDSNless.aspx
- <%@ Import Namespace="System.Data"%>
- <%@ Import Namespace="System.Data.Odbc"%>
- <%@ Page Language="VB" %>
- <script runat="server">
- Sub Page_Load(sender As Object, e As EventArgs)
- Dim dt As DataTable
- '*** Csv to DataTable ***'
- dt = CsvCreateDataTable()
- '*** BindData to Repeater ***'
- myRepeater.DataSource = dt
- myRepeater.DataBind()
- End Sub
- '*** DataTable ***'
- Function CsvCreateDataTable() As DataTable
- Dim objConn As New OdbcConnection
- Dim dtAdapter As OdbcDataAdapter
- Dim dt As New DataTable
- Dim strConnString As String
- strConnString = "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
- "Dbq=" & Server.MapPath("csv/") & ";Extensions=asc,csv,tab,txt;Persist Security Info=False"
- objConn = New OdbcConnection(strConnString)
- objConn.Open()
- Dim strSQL As String
- strSQL = "SELECT * FROM customer.csv"
- dtAdapter = New OdbcDataAdapter(strSQL, objConn)
- dtAdapter.Fill(dt)
- dtAdapter = Nothing
- objConn.Close()
- objConn = Nothing
- Return dt '*** Return DataTable ***'
- End Function
- </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(0) %></td> <!--or <Container.DataItem("CustomerID") -->
- <td><%#Container.DataItem(1) %></td> <!--or <Container.DataItem("Name") -->
- <td><%#Container.DataItem(2) %></td> <!--or <Container.DataItem("Email") -->
- <td align="center"><%#Container.DataItem(3) %></td> <!--or <Container.DataItem("CountryCode") -->
- <td align="right"><%#Container.DataItem(4) %></td> <!--or <Container.DataItem("Budget") -->
- <td align="right"><%#Container.DataItem(5) %></td> <!--or <Container.DataItem("Used") -->
- </tr>
- </ItemTemplate>
- </asp:Repeater>
- </form>
- </body>
- </html>
Screenshot