protected void Page_Load(object sender, EventArgs e)
{
DataClasses1DataContext dataContext = new DataClasses1DataContext();
GridView1.DataSource = from quote in dataContext.Quotes
select quote;
GridView1.DataBind();
}
protected void btn_filter_Click(object sender, EventArgs e)
{
DataClasses1DataContext dataContext = new DataClasses1DataContext();
var query = dataContext.Quotes.AsQueryable();
if(txt_symbol.Text != "")
{
query = query.Where(p => p.symbol == txt_symbol.Text);
}
if (txt_high.Text != "")
{
query = query.Where(p => p.high == Convert.ToDouble(txt_high.Text));
}
if (txt_low_min.Text != "")
{
query = query.Where(p => p.low > Convert.ToDouble(txt_low_min.Text));
}
if (txt_low_max.Text != "")
{
query = query.Where(p => p.low < Convert.ToDouble(txt_low_max.Text));
}
GridView1.DataSource = query;
GridView1.DataBind();
}
