retrive data from foxpro 2.6 memo field in c#.

[eric]

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

[Bob Grommes]

Re: retrive data from foxpro 2.6 memo field in c#.

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" <blablabla@hotm ail.com> wrote in message
news:uSxgRtyjEH A.1348@TK2MSFTN GP15.phx.gbl...[color=blue]
> 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[/color]

[Cindy Winegarden]

Re: retrive data from foxpro 2.6 memo field in c#.

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=VFPOL EDB.1;Data Source=C:\My
Documents\Visua l FoxPro Projects\test.D BC;Password=""; Collating
Sequence=MACHIN E"""
Dim con As New System.Data.Ole Db.OleDbConnect ion(ConnString)
Dim cmd As New System.Data.Ole Db.OleDbCommand ("Select * From
TestTable1", con)

Try
con.Open()
Dim dr As System.Data.Ole Db.OleDbDataRea der = _
cmd.ExecuteRead er()

While dr.Read()
System.Windows. Forms.MessageBo x.Show(dr.Item( 2).ToString)
End While
Catch e As Exception
System.Windows. Forms.MessageBo x.Show(e.ToStri ng)
End Try

End Sub
End Module


--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarde n@mvps.org www.cindywinegarden.com


"eric" <blablabla@hotm ail.com> wrote in message
news:uSxgRtyjEH A.1348@TK2MSFTN GP15.phx.gbl...[color=blue]
> 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
>
>[/color]