ProjectSMM.com
Gonzo TechNet
ADO.NET
How to use ADO.NET to read a text file.
How to open a text file using ADO.NET.
How to open/read a CSV/text file with an ADO.NET DataReader or DataAdapter.
What is the connection string/ConnectionString used to open/read a CSV/text file with an ADO.NET DataReader or DataAdapter
You receive "Can't update. Database or object is read-only" error message when you import or export files using OleDB ExecuteReader
What are the "Extended Properties" for a connection string to open a text/.csv file?
How to prompt the user for connection info in ADO.NET and VB.NET 2008
Private Sub cmdConnect_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdConnect.Click
'==============================================================================
'On the Project menu, set references for
'(COM) Microsoft ActiveX Data Objects 2.x Library
'(COM) Microsoft OLE DB Service Component 1.0 Type Library.
'==============================================================================
Dim cn As New ADODB.Connection
Dim dl As New MSDASC.DataLinks
Dim sMSG As String = vbNullString
'
'Two ways to prompt the user for connection info
'
dl.PromptEdit(cn)
' - OR --
cn = dl.PromptNew()
sMSG = cn.ConnectionString
MsgBox(sMSG)
End Sub