alias problem

[Nilish]

hi, i was using the following query to bing it with the data grid.

dim baseclass as baseclassdatacontext = nothing
baseclass=new baseclassdatacontext

dim query = from p in baseclass.gettable(of table1)() _
select p

now the problem is , if i want to use aliases i write in following way

dim query = from p in baseclass.gettable(of table1)() _
select name = p.name

if i have to use the alias by seperating the word like

dim query = from p in baseclass.gettable(of table1)() _
select first name = p.name

then i am getting error due to alias , please help , i want a column name of two words

[Howard Richards]

Youy can't do it: the .NET CLR does not support variable names containing spaces

'Howard

[K V Sekhar]

Linq will not support spaces in variable names. You can use _(underscore) instead of space. dim query = from p in baseclass.gettable(of table1)() _ select first_name = p.name Cheers, sekhar