Stored Procedure return records

[Alan T]

I have a SP:

CREATE PROCEDURE dbo.users_name
as
select name
from users
order by name

Here's my C# code:
public string[] GetUserNames()
{
SqlCommand objCommand = new SqlCommand("users_name", _Conn);
objCommand.CommandType = CommandType.StoredProcedure;
_Conn.Open();
objCommand.Connection.Close();
objCommand.Connection.Open();
objCommand.ExecuteNonQuery();

// how so I assign the names from the stored procedure to the return array
of string?

_Conn.Close();
}

[Brendan Green]

Either use a DataAdapter with a dataset, or use a DataReader.

See here for an example:
http://msdn2.microsoft.com/en-us/library/haa3afyz.aspx

"Alan T" <al*************@yahoo.com.au> wrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...

I have a SP:

CREATE PROCEDURE dbo.users_name
as
select name
from users
order by name

Here's my C# code:
public string[] GetUserNames()
{
SqlCommand objCommand = new SqlCommand("users_name", _Conn);
objCommand.CommandType = CommandType.StoredProcedure;
_Conn.Open();
objCommand.Connection.Close();
objCommand.Connection.Open();
objCommand.ExecuteNonQuery();

// how so I assign the names from the stored procedure to the return array
of string?

_Conn.Close();
}

[Peter Bromberg [C# MVP]]

You don't want to use ExecuteNonQuery as that returns no resultset. Use
ExecuteReader or DataAdapter.Fill to fill a DataSet. Then just iterate over
the rows, assigning the correct column value to your array.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Alan T" wrote:

I have a SP:

CREATE PROCEDURE dbo.users_name
as
select name
from users
order by name

Here's my C# code:
public string[] GetUserNames()
{
SqlCommand objCommand = new SqlCommand("users_name", _Conn);
objCommand.CommandType = CommandType.StoredProcedure;
_Conn.Open();
objCommand.Connection.Close();
objCommand.Connection.Open();
objCommand.ExecuteNonQuery();

// how so I assign the names from the stored procedure to the return array
of string?

_Conn.Close();
}