Programatically setting LINQ datasource where parameter? RSS

• • Reply
  

  dotNet_Stude...

  Member

  386 Points

  156 Posts

  Programatically setting LINQ datasource where parameter?

  Oct 06, 2008 11:54 PM|LINK

  How can I programatically set the where parameter of a LINQ DataSource control?

   Thanks.

  LINQ Datasource control

• • Reply
  

  kipo

  All-Star

  16475 Points

  2811 Posts

  Re: Programatically setting LINQ datasource where parameter?

  Oct 07, 2008 06:44 AM|LINK

  Try with this:
  

  LinqDataSource1.Where = "CategoryID = 1";

  or this:

          LinqDataSource1.Where = "CategoryID = @CategoryID";
          LinqDataSource1.WhereParameters.Add("CategoryID", DbType.Int32, "1");

  or like this if you have Where clause declared inside LinqDataSource:

  LinqDataSource1.WhereParameters["CategoryID"].DefaultValue = "1";

  • Edited by kipo on Oct 07, 2008 06:48 AM
  • Edited by kipo on Oct 07, 2008 06:48 AM
  • Marked as answer by Wencui Qian - MSFT on Oct 14, 2008 03:05 AM