all groups > dotnet distributed apps > november 2003 >
You're in the

dotnet distributed apps

group:

.NET handling space between database field name


.NET handling space between database field name ecwhite
11/26/2003 12:43:00 PM
dotnet distributed apps:
Hello,

I have field names coming in from a database with spaces
that I did not create and I can't change. I have tried
evrything I know and .NET does not like it e.g File Number
as a field name and when I do

File Number.DataTextField , it has it underlined. How do I
Re: .NET handling space between database field name Joe Fallon
11/30/2003 10:29:35 PM
Try putting it in square brackets.
[File Number].DataTextField
--
Joe Fallon




[quoted text, click to view]

Re: .NET handling space between database field name will
12/16/2003 6:00:53 PM
It was unclear from your post whether you are restricted
from renaming only on the RDBMS or also on the dataset.

If you are allowed to rename columns at the dataset level try this:

Create a Dataset schema, and assign an alias
to a column to get around this.

[quoted text, click to view]

AddThis Social Bookmark Button