VB.NET

need help with select statement

•

Join Date: Aug 2009

Posts: 1

Reputation: diya26 is an unknown quantity at this point

Solved Threads: 0

diya26

Offline

Newbie Poster

need help with select statement

Aug 31st, 2009

Hi
I'm new to developping applications in VB.net
I need help with a simple select statement.
SQL statement: Select "LYC Code" from [General ledger Setup]

I don't how to write that particular select statement in vb.net when there are spaces in the names of the table and field . Can anyone please help me out.

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
 
Dim myODBCommand2 As Odbc.OdbcCommand = New Odbc.OdbcCommand
        myODBCommand2.Connection = myODBConnection
        myODBCommand2.CommandText = " SELECT "LYC Code" FROM [General ledger Setup] "
Dim myODBCommand2 As Odbc.OdbcCommand = New Odbc.OdbcCommand
        myODBCommand2.Connection = myODBConnection
        myODBCommand2.CommandText = " SELECT "LYC Code" FROM [General ledger Setup] "

thanks & regards
Diya

•

Join Date: Feb 2009

Posts: 3,793

Reputation: sknake has much to be proud of

Solved Threads: 698

sknake

Offline

.NET Enthusiast

Re: need help with select statement

Aug 31st, 2009

 Help with Code Tags 
 vb.net Syntax (Toggle Plain Text) 
Dim someStr As String = "Select ""GL Setup"" From [My Table]"
Dim someStr As String = "Select ""GL Setup"" From [My Table]"