How i can return a DataSet or DataTable from a Stored Procedure

Yes you can fill the Data Adapter from command
as cmd.ExceuteReader()

then from this you can pull data to dataset from dataadapter

as

da.fill(ds,"somename")

Atul Kumar Sharma
Database Analyst

actually i want to return a dataset from stored procedure, not through data adapter

You can't. A DataSet is a .NET thing, and Sql server is not aware of that concept. All it can return is data, a result set, which can be put in a DataSet through a DataAdapter.

Take a look at the Enterprise Library and the Data Access Application Block in particular. The EntLib allows you to easily retrieve data from Sql server and other data sources without you bothering with DataAdapters, connections etc.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.