>>>var results = from r in ds.Tables[0].AsEnumerable() >>> select new {resource1 = r.Field<String>("resource1") }; >>>>>>
>>var newTable = new DataTable(); >>newTable.Columns.Add("resource1"); >>var results = (from r in ds.Tables[0].AsEnumerable() >> select newTable.Rows.Add(r.Field<String>("resource1"))) >> .ToList(); // Force immediate execution >>// newTable has the results as a DataTable, results has it as a List< DataRow> >>>>
>>var newTable = new DataTable(); >>newTable.Columns.Add("resource1"); >>var results = ds.Tables[0].AsEnumerable() >> .Select(r => >> { >> var newRow = newTable.NewRow(); >> newRow["resource1"] = r["resource1"]; // Or loop through ds.Tables[0].Columns >> return newRow; >> }) >> .CopyToDataTable(); >>// results is the new DataTable, newTable is only used for the structure >>>
> select resource1, booking_id, start_time, end_time, flex_tspan,; > layer, backcolor, forecolor, clip_sp, clip_loc,; > padr(space(iif(locked,2,0))+iif(empty(department+category+item),replicate('**'+alltrim(lsndescrip)+'** ',40),; > alltrim(modifiers)+' '+proper(alltrim(gst_name))+' '+; > alltrim(lsndescrip)+' '+alltrim(str(booking_id,16))),200) as display_msg, locked, ; > iif(nvl(notelength,0)>0, .t., .f.) as isnotes ; > from csrTemp; > into cursor csrRetCursor >>
>var results = from r in ds.Tables[0].AsEnumerable() > select new {resource1 = r.Field<String>("resource1"), > booking_id = r.Field<Int64>("booking_id"), > start_time = r.Field<DateTime>("start_time"), > end_time = r.Field<DateTime>("end_time"), > flex_tspan = r.Field<Boolean>("flex_tspan"), > layer = r.Field<Int16>("layer"), > backcolor = r.Field<Int32>("backcolor"), > forecolor = r.Field<Int32>("forecolor"), > clip_sp = r.Field<String>("clip_sp"), > clip_loc = r.Field<Int16>("clip_loc"), > display_msg = ("".PadRight((r.Field<Boolean>("locked"))?2:0)) > };>