Member Avatar for diya26

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.

Dim myODBCommand2 As Odbc.OdbcCommand = New Odbc.OdbcCommand
        myODBCommand2.Connection = myODBConnection
        myODBCommand2.CommandText = " SELECT "LYC Code" FROM [General ledger Setup] "

thanks & regards
Diya

  • 2 Contributors
  • 1 Reply
  • 66 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for sknake 
Dim someStr As String = "Select ""GL Setup"" From [My Table]"
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.