WebGrid Community Server

Welcome to WebGrid Community Server Sign in | Join | Help
in Search

How to handle column names with spaces

Last post 06-20-2009, 22:25 by fkkendrick. 1 replies.
Sort Posts: Previous Next
  •  06-10-2009, 23:45 1042

    How to handle column names with spaces

    I have inherited a database that has column names with spaces (I know, I know).  I cannot change the column names, but I really would like to use WebGrid.  The update functionality appears to work just fine.  However the add/insert generates a SQL error due to the space.  Does anyone know the syntax in the ColoumnId parameter or how to catch it in the VB code?
  •  06-20-2009, 22:25 1043 in reply to 1042

    Re: How to handle column names with spaces

    In case you haven't figured this out yet, the solution is to put the column name in brackets (i.e. [Employee Name])
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems