What "type" is returned?

[Lasse Edsvik]

Hello

I was wondering if you guys could tell me if:

cmd.ExecuteReader(CommandBehavior.CloseConnection);

returns a dataset, datatable or what?



SqlConnection conn = new
SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

SqlCommand cmd = new SqlCommand("EmployeesList", conn);

cmd.CommandType = CommandType.StoredProcedure;

conn.Open();

DataGrid1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);

DataGrid1.DataBind();

 

[Martin Dechev]

Hi,

It returns System.Data.SqlClient.SqlDataReader. See
http://msdn.microsoft.com/library/e...qlClientSqlCommandClassExecuteReaderTopic.asp

Greetings
Martin

 

[Kevin Spencer]

Hi Lasse,

Here is a link to the free Microsoft .Net SDK, which will answer this
question as well as any future questions you have regarding any .Net Common
Language Runtime Classes:

http://www.microsoft.com/downloads/...A6-3647-4070-9F41-A333C6B9181D&displaylang=en

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living