What "type" is returned?

[Lasse Edsvik]

Hello

I was wondering if you guys could tell me if:

cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

returns a dataset, datatable or what?

SqlConnection conn = new
SqlConnection(C onfigurationSet tings.AppSettin gs["ConnectionStri ng"]);

SqlCommand cmd = new SqlCommand("Emp loyeesList", conn);

cmd.CommandType = CommandType.Sto redProcedure;

conn.Open();

DataGrid1.DataS ource = cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

DataGrid1.DataB ind();

[Martin Dechev]

Hi,

It returns System.Data.Sql Client.SqlDataR eader. See
http://msdn.microsoft.com/library/en...eaderTopic.asp

Greetings
Martin
"Lasse Edsvik" <la***@nospam.c om> wrote in message
news:OW******** ******@TK2MSFTN GP15.phx.gbl...

Hello

I was wondering if you guys could tell me if:

cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

returns a dataset, datatable or what?

SqlConnection conn = new
SqlConnection(C onfigurationSet tings.AppSettin gs["ConnectionStri ng"]);

SqlCommand cmd = new SqlCommand("Emp loyeesList", conn);

cmd.CommandType = CommandType.Sto redProcedure;

conn.Open();

DataGrid1.DataS ource = cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

DataGrid1.DataB ind();

[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/d...displaylang=en

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

"Lasse Edsvik" <la***@nospam.c om> wrote in message
news:OW******** ******@TK2MSFTN GP15.phx.gbl...

Hello

I was wondering if you guys could tell me if:

cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

returns a dataset, datatable or what?

SqlConnection conn = new
SqlConnection(C onfigurationSet tings.AppSettin gs["ConnectionStri ng"]);

SqlCommand cmd = new SqlCommand("Emp loyeesList", conn);

cmd.CommandType = CommandType.Sto redProcedure;

conn.Open();

DataGrid1.DataS ource = cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

DataGrid1.DataB ind();