[RESOLVED] LInq question

[r0k3t]

Hi there,

I am just starting to use linq, I have created this little bit to pull information out of a datatable.

var brideFirstName = from r in eventContacts.Tables[0].AsEnumerable() where(r.Field<string>("ContactType") == "bride")
                                            select(r.Field<string>("FirstName"));
BrideFirstNameLabel.Text = brideFirstName.First();

first of all - is that the most efficient way to get a single piece of data from a datatable?

Second question - what if I wanted say three bits of data, like city state and postal code?

I have read several tutorials but am not that familiar with it yet so any human advice would be great!

Thanks...