Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ASP.NET Dynamic Linq Search
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Data;
- namespace Test1
- {
- class Program
- {
- static void Main(string[] args)
- {
- DataTable table = new DataTable();
- table.Columns.Add("ID", typeof(int));
- table.Columns.Add("FIRSTNAME", typeof(string));
- table.Columns.Add("LASTNAME", typeof(string));
- table.Columns.Add("EMAIL", typeof(string));
- // Here we add five DataRows.
- table.Rows.Add(1, "Chris", "Foo", "chris.foo@mail.com");
- table.Rows.Add(2, "Christoph", "Bar", "christoph.bar@mail.com");
- table.Rows.Add(3, "Michael", "FooBar", "michael.foobar@mail.com");
- table.Rows.Add(4, "Andreas", "BarFoo", "andreas.barfoo@mail.com");
- table.Rows.Add(5, "Carl", "Bar", "carl.bar@mail.com");
- Console.WriteLine("//Query ID");
- var query1 = (from dr in table.AsEnumerable() where dr.Field<int>("ID") == 1 select dr).FirstOrDefault();
- Console.WriteLine(query1.Field<int>("ID"));
- Console.WriteLine("//Query Firstname");
- var query2 = (from dr in table.AsEnumerable() where dr.Field<string>("FIRSTNAME").StartsWith("C") select dr).ToList<System.Data.DataRow>();
- foreach (var q in query2)
- {
- Console.WriteLine(q.Field<int>("ID"));
- }
- Console.ReadLine();
- }
- }
- }
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Data;
- namespace Test1
- {
- class Program
- {
- static void Main(string[] args)
- {
- DataTable table = new DataTable();
- table.Columns.Add("ID", typeof(int));
- table.Columns.Add("FIRSTNAME", typeof(string));
- table.Columns.Add("LASTNAME", typeof(string));
- table.Columns.Add("EMAIL", typeof(string));
- // Here we add five DataRows.
- table.Rows.Add(1, "Chris", "Foo", "chris.foo@mail.com");
- table.Rows.Add(2, "Christoph", "Bar", "christoph.bar@mail.com");
- table.Rows.Add(3, "Michael", "FooBar", "michael.foobar@mail.com");
- table.Rows.Add(4, "Andreas", "BarFoo", "andreas.barfoo@mail.com");
- table.Rows.Add(5, "Carl", "Bar", "carl.bar@mail.com");
- Console.WriteLine("//Query ID");
- var query1 = (from dr in table.AsEnumerable() where dr.Field<int>("ID") == 1 select dr).FirstOrDefault();
- Console.WriteLine(query1.Field<int>("ID"));
- Console.WriteLine("//Query Firstname");
- var query2 = (from dr in table.AsEnumerable() where dr.Field<string>("FIRSTNAME").StartsWith("C") select dr).ToList<System.Data.DataRow>();
- foreach (var q in query2)
- {
- Console.WriteLine(q.Field<int>("ID"));
- }
- Console.ReadLine();
- }
- }
- }
- //Query ID
- 1
- //Query Firstname
- 1
- 2
- 5
- var query = (from u in results select u);
- if (!string.IsNullOrEmpty(userRequest.searchData))
- {
- if (userRequest.searchBy == "LastName")
- {
- var likestr = userRequest.searchData.Trim();
- query = (from n in query where n.LastName.StartsWith(likestr) select n);
- }
- if (userRequest.searchBy == "UserId")
- {
- var userId = Convert.ToInt32(userRequest.searchData);
- query = (from n in query where n.UserId == userId select n);
- }
Add Comment
Please, Sign In to add comment