I need help please in reading a single records from SQL

[gollnick]

I have this code :
Static ConnectionString As String = SQL_CONNECTION_STRING
Dim WarehouseConnection As New SqlConnection(ConnectionString)
Dim strSQL As String = "SELECT * " & _
"FROM Orders " & _
"WHERE OrderID = '" & (CType(DataGrid1(currentrow, 0), String)) & "'"
Dim ProductAdapter As New SqlDataAdapter(strSQL, WarehouseConnection )

I get the order number from a double click on datagrid. Now .. I just want to "chain" out to my file .. Orders .. and bring back that single records data. I have the sqlcmd statement but my connection string keeps erroring out. I keep on getting errors ..

Thanks