How to return the ID through a dataset?

		Wrox Programmer Forums > C# and C > C# 2008 > C# 2008 aka C# 3.0
How to return the ID through a dataset?

C# 2008 aka C# 3.0 Discuss the Visual C# 2008 (aka C# 3.0) language

Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# 2008 aka C# 3.0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Page 2 of 2

June 25th, 2008, 07:56 PM

Old Pedant Old Pedant is offline

Friend of Wrox

Join Date: Jun 2008

Posts: 1,649

Thanks: 3

Thanked 141 Times in 140 Posts

> Can "Select" return multiple values like "out" could?

Of course! But then you can't use ExecuteScalar any more. Now you are returning a full ROW of data. The most efficient way to read that row is via a DataReader, but you could even dump it into a DataTable (though presumably you'd end up with a one-row datatable).

Page 2 of 2

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ADD DB RECORD/ RETURN ID	Huascar82	Classic ASP Databases	1	October 1st, 2007 11:55 PM
DTS return table ID	forkhead	SQL Server DTS	2	November 9th, 2006 12:15 PM
Return dataset	lily611	C#	1	July 2nd, 2006 01:35 PM
Webmethod error while return type is a dataset	Hagop	General .NET	1	August 10th, 2005 05:46 AM
Return DataSet / DataTable from Stored Procedure	ashu_from_india	ADO.NET	3	March 20th, 2005 05:39 AM