DataRow - Spaces in Field Name - Problem!!

[lorena]

I am working on a windows form with a sql database that has several fields that have spaces in their names (NOT my idea or design but there it is). When the form loads, I want to bind the fields from the datarow to the controls on the form. I am running into problems because of the spaces.
Here is my code:

 guestDataRow = aGuestsDataSet.Guests.FindByPhone(phoneString)
    With Me
      .firstNameTextBox.Text = guestdatarow![first name].tostring
      .streetTextBox.Text = guestDataRow!street.ToString
      .cityTextBox.Text = guestDataRow!city.ToString
      .lastVisitTextBox.Text = guestDataRow!["last visit date"].ToString
    End With

None of the things I have tried worked and I would appreciate any help.
Thanks

 

[Nerseus]

Try using square brackets around column names. This works for table names as well.

.firstNameTextBox.Text = guestdatarow!["[first name]"].tostring

This may not be exactly right - Im not familiar with the "!" syntax of VB.NET. I was mostly pointing out the change to using [first name]

-ner

 

[MrPaul]

Suggestions

How about:

guestDataRow.Item("first name").ToString()

Or, as Nerseus suggested:

guestDataRow.Item("[first name]").ToString()

Im amazed they kept the ! syntax from VB6.

 

[lorena]

Thanks very much for your help. Here is the code that worked:

.firstNameTextBox.Text = guestDataRow.Item("first name").ToString

Thanks for your help!