Colum naming conventions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Hope someon can help with this one. I have added column names with spaces
dynamically into SQLServer 2000, eg. Order Details. This appears as [Order
Details] on the server and everything looks fine. However when I go to
Insert or Update data using the data adapter, it doesn't find the column.
What is it doing.

Thanks
RitaK
 
RitaK,

I don't know what it is doning, however I would never give datafield names a
name seperated by a space. Is it not now I will become in trouble, than
probably tomorrow.

(And therefore I never had your problem)

OrderDetails is very nice in my opinion.

Just my thought,

Cor
 
¤ Hi,
¤
¤ Hope someon can help with this one. I have added column names with spaces
¤ dynamically into SQLServer 2000, eg. Order Details. This appears as [Order
¤ Details] on the server and everything looks fine. However when I go to
¤ Insert or Update data using the data adapter, it doesn't find the column.
¤ What is it doing.

If you have space embedded tables names they will have to be enclosed with brackets or single quote
characters (this will depend upon the database type).


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
While supported in SQL Server by putting [my column name] this instead
of my column name, if you try to do any sort of object mapping to your
ADO.NET code (as demonstrated in the source code generator for ADO below),
you'll run into all sorts of problems.

You are much better off in the long run naming your columns like so:

FirstName
LastName
SomeOtherColumnName

--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.mastervb.net/home/ng/forumvbcode/post10017013.aspx
http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp
 
Back
Top