473,569 Members | 2,762 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3903
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*******@hotm ail.com> wrote in message
news:uS******** ******@TK2MSFTN GP15.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=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
ci************* *@mvps.org www.cindywinegarden.com
"eric" <bl*******@hotm ail.com> wrote in message
news:uS******** ******@TK2MSFTN GP15.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2905
by: me | last post by:
I've posted this in the microsoft news group but just noticed the comp newsgroups. What's the difference anyways? This one is a tricky one so I'm interested in seeing what all you gurus have to say. I'm trying to put a resume into a database. There are only three reports (see below). I suspect that the best structure for a resume...
1
2422
by: ivan | last post by:
Access 97 I have a memo field in a footer on a subform. When I print the form, all data is printed except the data that was entered into the memo field. The memo field itself is printed (the border), but the data is missing. The following properties are set for the memo field: Visible: Yes Display when: always
3
5209
by: Helgardh | last post by:
I have a linked table (Access 2003) to an Outlook inbox. The body of the e-mail messages are in a memo field. My problem is that I need to "read" the memo and find data on certain lines. The memo will look something like this: Order: J123451 Placed By: Joe.systems,daily Order: J123452
5
8616
by: kotowskil | last post by:
A report has a subform. The subform is set to datasheet view and its RecordSource is a select query that includes a memo field from the source table. The memo field's Can Grow property is Yes, and the subform Detail section's Can Grow property is Yes. The report Detail section's Can Grow property is also Yes. When run, the select query's...
3
1996
by: MLH | last post by:
Precise determinations are not the objective. I would lke a single button click approach to creating a report/table/dynaset - whatever - to display each table name and an approx- imation of the number of bytes of storage spaced occupied by the data in each table. I don't remember seeing any discussion on this topic over the years since...
9
5723
by: RMC | last post by:
Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo field is printed within the detailed area. The problem is, the apllication is not setup properly, thus the users are entering data within the memo...
0
14405
by: Grip | last post by:
Hi, I have gone throught the group and Microsoft's online help and have seen many suggestions but I am still seeking clarity: 1. I have an excel spreadsheet. Column A contains text that may be greater than 255 characters. 2. I have an access database. I link (not import) to the contents of the excel spreadsheet. In the design view in...
10
4756
by: Johny | last post by:
Is there a module for reading/modifing db files from Python? Thanks for help B.
3
9374
by: Kunal Desale | last post by:
Hi, How to insert/update data in foxpro table field having datatype MEMO using Linked Server? I have written sql insert queries in which i have used linked server to insert data into foxpro tables. Some fields have datatype Memo and in these fields my data is not getting inserted/updated. My queries contains local tables & dbf tables...
0
7694
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7609
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8118
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7666
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6278
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5504
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2107
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1208
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.