>>Hi everybody,
>>
>>In VFP I have code that first gets data from SQL Server into a cursor and then does extra select from that cursor into another cursor applying some extra formatting.
>>
>>I am wondering what is the best way to simulate this in C#? I understand I can get dataset (or reader) and loop through every row and generate a new dataset.
>>
>>Is there another way using LINQ, for example? If yes, can you show a sample, please?
>>
>>Thanks in advance.
>
>I don't want to be "that" guy, but... is there a reason you're using datasets? With custom classes you have much more flexibility.
This is what I started to write
var results = from r in ds.Tables[0].AsEnumerable()
select new {resource1 = r.Field<String>("resource1") };
My problem is that I will need to pass that result as datatable to another method.
I am not sure how can I do that - transform this LINQ result as datatable?
If it's not broken, fix it until it is.
My Blog