views:

68

answers:

2
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()
);
+3  A: 

Use SQL Profiler. It allows you to see the actual SQL query being sent to the database.

It comes with SQL 2005/2008 client tools.

Wim Hollebrandse
Will that work with SQLServer Management Studio Express?
Brett
+2  A: 

I'm not familiar with Subsonic, but according to this question you may be able to use the BuildSqlStatement() method of your query to see the generated SQL.

Amal Sirisena
Yes BuildSqlStatement should do what he wants.
Adam
Thanks - this worked.
Brett