469,646 Members | 1,367 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,646 developers. It's quick & easy.

retrive data from foxpro 2.6 memo field in c#.

Hi
Does any one know how to retrive data from foxpro 2.6 memo field in c#. I
just manage to retrive the first row.

/Eric
Nov 16 '05 #1
2 3690
So is your problem somehow connected to the memo field, or to your inability
to retreive more than one row? You message seems contradictory.

No one can possibly help you without much more info.

For example, are you using the desktop dBase ODBC driver, the Fox ODBC
driver, or the Fox OLE DB driver?

Are you trying to retreive via a DataAdapter or a DataReader? Which
library?

Where is the code that demonstrates your problem?

--Bob

"eric" <bl*******@hotmail.com> wrote in message
news:uS**************@TK2MSFTNGP15.phx.gbl...
Hi
Does any one know how to retrive data from foxpro 2.6 memo field in c#. I
just manage to retrive the first row.

/Eric

Nov 16 '05 #2
Hi Eric,

How are you retrieving your data? You should be able to do it with the
Visual FoxPro OLE DB data provider, downloadable from
http://msdn.microsoft.com/vfoxpro/do...s/default.aspx.

Here's some VB code that worked for me:

Module Module1
Sub Main()
Dim ConnString As String = "Provider=VFPOLEDB.1;Data Source=C:\My
Documents\Visual FoxPro Projects\test.DBC;Password="";Collating
Sequence=MACHINE"""
Dim con As New System.Data.OleDb.OleDbConnection(ConnString)
Dim cmd As New System.Data.OleDb.OleDbCommand("Select * From
TestTable1", con)

Try
con.Open()
Dim dr As System.Data.OleDb.OleDbDataReader = _
cmd.ExecuteReader()

While dr.Read()
System.Windows.Forms.MessageBox.Show(dr.Item(2).To String)
End While
Catch e As Exception
System.Windows.Forms.MessageBox.Show(e.ToString)
End Try

End Sub
End Module
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
ci**************@mvps.org www.cindywinegarden.com
"eric" <bl*******@hotmail.com> wrote in message
news:uS**************@TK2MSFTNGP15.phx.gbl...
Hi
Does any one know how to retrive data from foxpro 2.6 memo field in c#. I
just manage to retrive the first row.

/Eric

Nov 16 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Helgardh | last post: by
10 posts views Thread by Johny | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.