Esempio n. 1
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            string searchTerm = txtSearchTerm.Text;
            using (NorthwindDataContext context = new NorthwindDataContext())
            {
                string whereClause = "ProductName.Contains(\"" + searchTerm + "\")";
                var q = context.Products.Where(whereClause);

                this.ProductGridView.DataSource = q;
                this.ProductGridView.DataBind();
                this.ProductCount.Text = this.ProductGridView.Rows.Count.ToString("n0");
                this.SearchPanel.Visible = true;

            }
        }
Esempio n. 2
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            string searchTerm = txtSearchTerm.Text;
            using (NorthwindDataContext context = new NorthwindDataContext())
            {
                var q = from p in context.Products
                        where p.ProductName.Contains(searchTerm)
                        select p;

                this.ProductGridView.DataSource = q;
                this.ProductGridView.DataBind();
                this.ProductCount.Text = this.ProductGridView.Rows.Count.ToString("n0");
                this.SearchPanel.Visible = true;

            }
        }