SubSonic Forums
All Your Database Are Belong To Us

How to set default value

Latest post 10-22-2008 12:08 AM by ranomore. 1 replies.
  • 10-15-2008 11:11 PM

    • mylok
    • Not Ranked
    • Joined on 10-16-2008
    • Posts 3

    How to set default value

     My code like below:

    DetailView1.datasource = New Query("table").Where("ID", id).ExecuteReader();      // id from session

    My question is: How can I set the default value for id?      id = 1

    Thank.

  • 10-22-2008 12:08 AM In reply to

    • ranomore
    • Top 10 Contributor
    • Joined on 11-05-2007
    • Salt Lake City
    • Posts 322

    Re: How to set default value

    Reply |Contact |Answer

    I don't really understand the question, but does this help?

    DetailView1.datasource = New Query("table").Where("ID", (id > 1 ? id : 1)).ExecuteReader();

Page 1 of 1 (2 items) | RSS