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
Home | TechNet | ADO.Net | DOS | ASP.NET | IIS | VB.NET | VIM (vi) | Windows | XHtml
MS-SQL | T-SQL | SSIS | Oracle