var dt = new DataTable (); dt.Columns.Add ("Name", typeof (string)); dt.Rows.Add ("Joe"); dt.Rows.Add ("Mary"); var query = from row in dt.AsEnumerable() where row.Field<string>("Name").StartsWith ("J") select row; query.Dump();
Comments
http://msdn.microsoft.com/en-us/library/bb386977.aspx
The following example will get you started in LINQPad:
http://share.linqpad.net/h7tahh.linq