Help needed-Code Check-Education

[Aaron]

The following code is fired on a (webform) datagrid select event. I am
filling textboxes (that are NOT part of the datagrid) with the cell
contents of the selected row. All text boxes are being populated
correctly, except for the last two; txtNotes and txtConfNotes, which do
not get populated at all. Moving the order around does not help.

If e.Item.Cells(6).Text.Equals(" ") Then
txtBPhone.Text = ""
Else
txtBPhone.Text = e.Item.Cells(6).Text
End If
If e.Item.Cells(7).Text.Equals(" ") Then
txtWorkExt.Text = ""
Else
txtWorkExt.Text = e.Item.Cells(7).Text
End If
If e.Item.Cells(8).Text.Equals(" ") Then
txtClientCell.Text = ""
Else
txtClientCell.Text = e.Item.Cells(8).Text
End If
If e.Item.Cells(9).Text.Equals(" ") Then
txtNotes.Text = ""
Else
txtNotes.Text = e.Item.Cells(9).Text
End If
If e.Item.Cells(10).Text.Equals(" ") Then
txtConfNotes.Text = ""
Else
txtConfNotes.Text = e.Item.Cells(10).Text

There is data in the datagrid cell for the selected row, and when I step
through, it passes the if statements fine and executes the else portion
of the statement.
The only other thing that I can add is that the datatype is TEXT in the
SQL table this data is being pulled from. All other fields are of type
char. I remember something from an earlier ASP project that I worked on
where I had to open a connection with rs.Open SQL, oconn,1,3 in order to
read text datatype fields. Could this be the same thing?

I am using the following for the connection
Dim sqlcmd0 As New SqlClient.SqlCommand()
Dim sqlcon As New SqlClient.SqlConnection()
Dim ds As New DataSet()
Dim da As New SqlClient.SqlDataAdapter()
sqlcon.ConnectionString =
"Server=SERVER;UserID=USER;password=PASSWORD;Datab ase=DATABASE"
sqlcmd0.Connection = sqlcon
sqlcon.Open()

Any ideas?

Aaron