Hi Sam,

Both Michel and Mike showed you VB syntax. The way to access DataSet information has a slightly different syntax in C#.

string MyVariable = MyDataSet.Tables[0].Rows[0]["MyColumn"].ToString();

or

string MyVariable = MyDataSet.Tables["MyTable"].Rows[0]["MyColumn"].ToString();

As Mike also mentioned, the use of a strongly typed DataSet will help ... you get Intellisense and the syntax is far more readable:

string MyVariable = MyDataSet.MyTable[0].MyColumn;

You can generate Typed DataSets in the IDE by using an .xsd for your DataSets.

~~Bonnie



>Hello.
>
>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?
>
>TIA