Linq select

Question

Select sample ---Posted from iPhone App---

Datta Kharad · Answer

Hi Ex 1) var obj= from n in Tablname or Collection Select n where colid=12 order by colname; -------------------------------------------------------------- Ex 2) public void SimpleQuery() { DataClasses1DataContext dc = new DataClasses1DataContext (); var q = from a in dc.GetTable Order >() select a; dataGridView1.DataSource = q; } ----------------------------------------------------------- Ex 3) Understanding from..where..select The from..where..select syntax in LINQ is similar to SELECT..FROM..WHERE clause of SQL. Here is a simple from..select. from day in daysArray select day; In the above statement, I select day in daysArray. It returns an object of "var" type, which is a generic type and can store any type. For example, daysArray can be an array of numbers, strings, or even objects. Here is an example of daysArray. string [] daysArray = { "Mon" , "Tue" , "Wed" , "Thur" , "Fri" , "Sat" , "Sun" }; This is how return value is stored from a from..select statement. var days = from day in daysArray select day; Now where clause is used to filter the results. For example, the following syntax gets retuslts from daysArray where value of day is "Wed" only. var days = from day in daysArray where day == "Wed" select day; Filtering using where The following code selects items from an array that have value below 20. int [] IntArray = { 12, 5, 24, 10, 9, 8, 4, 87, 23, 7, 11, 43 }; var under20 = from u20 in IntArray where u20 select u20; foreach ( var numU20 in under20) { Console .WriteLine(numU20); } Please mark as Accepted answer if your query resolved.