/// <summary> /// Linq for black cars and in the datagrid /// it will show only black 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.color == "Black" select car).ToList(); GridBlack.DataSource = query; GridBlack.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { try { CarModel carModel = new CarModel(); var Audis = from CarsTable in carModel.CarsTables where CarsTable.color.Contains("Black") select CarsTable; GridBlack.DataSource = Audis.ToList(); GridBlack.DataBind(); RecordLabel.Text = "Records found"; } catch { RecordLabel.Text = "Records not found"; } }