Debugging SQL in ASP.NET

Question

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()
);

stackoverflow.com/questions/799953/… Please re-read the answer ranomore gave you Brett. — Adam Cooper
– Adam Cooper, Commented Nov 18, 2009 at 9:50

Wim · Accepted Answer · 2009-11-17 22:36:06Z

3

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.

answered Nov 17, 2009 at 22:36

Wim

12.1k1 gold badge37 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:47:46Z

2

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.

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Nov 17, 2009 at 23:01

Amal Sirisena

1,48910 silver badges10 bronze badges

1 Comment

Adam Cooper Over a year ago

Yes BuildSqlStatement should do what he wants.

Collectives™ on Stack Overflow

Debugging SQL in ASP.NET

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related