User Profile

Collapse

Profile Sidebar

Collapse
arthurvanderwal
arthurvanderwal
Last Activity: Oct 28 '09, 12:29 PM
Joined: Sep 21 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • arthurvanderwal
    replied to How to use IN () syntax in asp.net datasets (xsd)
    in .NET
    Thanks ssnaik84!

    However I cant help but thinking that these functions do a 'non' MSSQL operation on the dataset. Ie aren't these functions potentially slow on large result sets?
    See more | Go to post

      Leave a comment:

    • arthurvanderwal
      replied to How to use IN () syntax in asp.net datasets (xsd)
      in .NET
      Hi Steven,

      I like to retrieve records of which the ID is one of the IDs i supply..

      so

      SELECT * FROM tblTable WHERE id IN (1,2,3,4,5)

      would be the thing I'm after...

      However if I try this with

      SELECT * FROM tblTable WHERE id IN (@idList)

      I don't get it to work ...

      Thanks!

      Arthur
      See more | Go to post

        Leave a comment:

      • arthurvanderwal
        started a topic How to use IN () syntax in asp.net datasets (xsd)
        in .NET

        How to use IN () syntax in asp.net datasets (xsd)

        Hi,

        I use Visual studio datasets to create table adapters etc. for queries. This normally works fine for me with 'simple' queries (i.e. only 1 parameter of type string, int ...). However if I specify the following query in the dataset:

        SELECT * from tblTable WHERE tblId IN (@idList)

        the query editor accepts, but the generated code will create a function that just accepts a single integer. Changing the...
        See more | Go to post
        No activity results to display
        Show More
        Working...