Geekpedia Programming Tutorials

Latest News News

Latest Programming Tutorials Tutorials

Latest Source Code Code

Latest Tech Resources Resources

Latest Newsgroups Newsgroups

Search

Tutorials and Code

Syndication

My Account

Community Forums

Webmaster Tools

Tech Jobs

Geekpedia » Newsgroups » .NET Data Tools Newsgroup » Strongly Typed Dataset Accessing Query Using 'IN'

Strongly Typed Dataset Accessing Query Using 'IN'

 On Thursday, May 8th 2008 at 09:58 AM
By Anonymous
This problem touches both SQL/Server and ADO.NET, and its solution could be
in either. A round of applause if you can provide the solution.

The goal:
Produce a stored procedure which accepts a string of options to be used in a
SELECT WHERE <a field> IN (<the string> ) statement, AND make the resulting
set of rows available as a strongly typed dataset.

What I???ve tried so far and why it doesn???t work:
1 ??? pass the string into the stored procedure, build a varchar containing
the entire select statement, and execute that string
??? Doesn???t work because VS / ADO.NET sees the ???exec??? command, not a ???select???
command, so when I drop the sProc onto the dataset page in VS2008, it becomes
part of the QueriesTableAdapter, not its own table adapter, as if it were a
SQL command that doesn???t return rows.

2 ??? use option 1 but select into a temporary table, then follow that with a
SELECT * FROM #tempTable.
??? Doesn???t work because the scope of the temporary table that the Select
creates is limited to the ???exec??? command, and the subsequent ???select (*)???
command can???t access the temporary table.
3 ??? use option 2 but use a global temporary table
??? Won???t work because multiple simultaneous accesses will collide, trying to
simultaneously access the single global temporary table
Latest Tech Bargains
Apple 16GB iPod Touch

Apple 16GB iPod Touch

$299 + shipping
Samsung A437 + $25 Airtime GoPhone Package

Samsung A437 + $25 Airtime GoPhone Package

$34.99 w/ free shipping
Xbox 360 Pro System with HDD and HDMI

Xbox 360 Pro System with HDD and HDMI

$199.99 w/ free shipping
ECS GOAL3+ Barebone System

ECS GOAL3+ Barebone System

$59.99 + shipping
Bargains View More Bargains
RSS Feed Bargains RSS Feed

Advertisement

Free Magazine Subscriptions
Website Magazine

Website Magazine

FREE SUBSCRIPTION
by Website Services Inc.
InformationWeek

InformationWeek

FREE SUBSCRIPTION
by CMP Media LLC
Better Software Magazine

Better Software Magazine

FREE SUBSCRIPTION
by Software Quality Engineering
z/Journal

z/Journal

FREE SUBSCRIPTION
by Thomas Communications, Inc.
Magazines View More Magazines

Today's Pictures
AMD Turion 64 Mobile Wallpaper

AMD Turion 64 Mobile Wallpaper


Tags: Wallpaper, AMD
Intel Inside Pentium 4 HT Wallpaper

Intel Inside Pentium 4 HT Wallpaper


Tags: Intel, Wallpaper
Intel Inside Centrino Wallpaper

Intel Inside Centrino Wallpaper


Tags: Intel, Wallpaper
Pictures View More Pictures

Today's Video
New Windows Mobile Release

New Windows Mobile Release
Videos View More Videos

Other Resources

Latest Download
Building Line of Business Applications with WPF

Building Line of Business Applications with WPF

Downloads View More Downloads

Latest Icons
Skype Samba
Keys Smiley Face
Icons View More Icons
About Geekpedia
Legal
More Resources
Closed Sections
Geekpedia Network


Geekpedia Logo
Copyright © Geekpedia 2004 - 2008. All Rights Reserved.