本文介绍了DBF数据库与VB.NET连接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何连接到。使用VB 2008的DBF数据库和在dadagrid中的节目?谢谢。

how to connect to. DBF database with VB 2008 and that the show in dadagrid? thanks.

推荐答案


Dim ConnectionString As String

       ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\;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 dbase", dBaseConnection)
       Dim dBaseDataReader As System.Data.OleDb.OleDbDataReader = dBaseCommand.ExecuteReader(CommandBehavior.SequentialAccess)

       While dBaseDataReader.Read
           TextBox1.Text = (dBaseDataReader("Column1").ToString)
           TextBox2.Text = (dBaseDataReader("Column2").ToString)
           TextBox3.Text = (dBaseDataReader("Column3").ToString)
       End While

       dBaseConnection.Close()





但是我们只显示最后一行...如果有人知道怎么做才能回到第一行或下一行,最后一行...



but we show only the last line ... if anyone knows how I could do to get back to the first or next row, the last ...



这篇关于DBF数据库与VB.NET连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-22 21:02
查看更多