how to show multiple column in one column?

hi,

try following code
var st = from s in db.specSheets
            select new
                {
                    AccList = s.AccList,
                    descrip = s.descrip1 + "_" + s.descrip2,
                    Quantity = s.Quantity
                };

hope this will help you.

hi,

your syntax looks correct.
please share your error description.