private void BuildGridView2()
{
GridView1.DataSource = new Select()
.From("NewsReleases")
.Where("RelMonth").IsEqualTo(this.ddlAward.SelectedValue)
.And("RelYear").IsEqualTo(this.ddlYear.SelectedValue)
.OrderAsc("RelDate")
.ExecuteDataSet();
}
The SQL statement above is not working for some reason. Is there a way to write the output of the staement to to the page to see what is happening?
I tired the following but got an error:
Response.Write(
new Select()
.From("NewsReleases")
.Where("RelMonth").IsEqualTo(this.ddlAward.SelectedValue)
.And("RelYear").IsEqualTo(this.ddlYear.SelectedValue).ToString()
);