>I've been trying to set a variable to a data brought back from a foxpro table.
>
>In VFP it would look something like this:
>

>lcMyVariable = ALLTRIM(customer.firstname)
>

>
>What would be C# version of this statement?

Assuming you have a dataview created, you can do something like this to get the row:

loRow = loDataProvider.oDataView(0).Row

and, then, from any field in that row such as:

lcMyVariable = loRow("FirstName")

If your dataset contains multiple rows, you can scroll to each row like this:

        For lnCounter = 0 To loDataProvider.nCount - 1
            loRow = loDataProvider.oDataSet.Tables("Temp").Rows(lnCounter)
            lcMyVariable = loRow("FirstName")
            ...
        Next

I am using a nCount provider of a data provider class. You may adjust to use the current count of your dataset.

This is VB.NET code but can easily be adapted to C#.