/// <summary> /// Linq for Audi cars and in the datagrid /// it will show only Audi cars /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { CarsDBEntities db = new CarsDBEntities(); var query = (from car in db.CarsTables where car.brand == "Audi" select car).ToList(); GridAudis.DataSource = query; GridAudis.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { try { CarModel carModel = new CarModel(); var Audis = from CarsTable in carModel.CarsTables where CarsTable.brand.Contains("Audi") select CarsTable; GridAudis.DataSource = Audis.ToList(); GridAudis.DataBind(); RecordLabel.Text = "Records found"; } catch { RecordLabel.Text = "Records not found"; } }