Re: How can I connect a dbf file in .net ?
From: Joel Eisenhandler (Eisenhandler_at_discussions.microsoft.com)
Date: 08/25/04
- Next message: CopynPaste: "Open an existing Word file?"
- Previous message: Agnes: "Re: menuitem is an object ??"
- In reply to: Paul Clement: "Re: How can I connect a dbf file in .net ?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Aug 2004 19:19:02 -0700
I have had very good success with ODBC. Set up the database directory under
System DSN. All your connection string has to say is "DSN=XXX"
"Paul Clement" wrote:
> On Mon, 23 Aug 2004 16:10:12 +1200, "Chuen" <cnchuen@hotmail.com> wrote:
>
> ¤ I want to open a dbf file in vb.net,how can I do it?
> ¤
> ¤ Regards
> ¤ Chuen
> ¤
>
> See if the following helps:
>
> Dim ConnectionString As String
>
> ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=e:\My Documents\dBase;Extended Properties=dBase IV"
> Dim dBaseConnection As New System.Data.OleDb.OleDbConnection(ConnectionString)
> dBaseConnection.Open()
>
> Dim dBaseCommand As New System.Data.OleDb.OleDbCommand("SELECT * FROM MyDBase",
> dBaseConnection)
> Dim dBaseDataReader As System.Data.OleDb.OleDbDataReader =
> dBaseCommand.ExecuteReader(CommandBehavior.SequentialAccess)
>
> While dBaseDataReader.Read
> Console.WriteLine(dBaseDataReader("Column1").ToString)
> Console.WriteLine(dBaseDataReader("Column2").ToString)
> Console.WriteLine(dBaseDataReader("Column3").ToString)
> End While
>
> dBaseConnection.Close()
>
>
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)
>
- Next message: CopynPaste: "Open an existing Word file?"
- Previous message: Agnes: "Re: menuitem is an object ??"
- In reply to: Paul Clement: "Re: How can I connect a dbf file in .net ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
