Convert SqlDataReader into array

Question

C# code :

string conn = @"Data Source=MRT\SQLSERVER;Initial Catalog=hrm;Persist Security Info=True;User ID=sa;Password=*******";

SqlConnection objsqlconn = new SqlConnection(conn);
objsqlconn.Open();

SqlCommand cmd = new SqlCommand("usp_fetchtest", objsqlconn);
cmd.CommandType = CommandType.StoredProcedure;

SqlParameter lastname = cmd.Parameters.Add("@userid", SqlDbType.Int);
lastname.Value = 6;

SqlDataReader sdr;
sdr = cmd.ExecuteReader();

Stored procedure :

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[usp_fetchtest] 
    @userid int
AS
BEGIN
    SELECT firstName, lastName 
    FROM personal  
    WHERE personal.userid = @userid
END

How can I store this value in two array for firstname and lastname? So I can operate on that info in further project steps?

What have you tried? And what exactly do you mean by "...in two array". It all depends on how you want to access the data later. What kind of requirements you have... — Barns
– Barns, Commented Feb 27, 2020 at 19:20

W. Winnie · Accepted Answer · 2020-02-27 20:16:30Z

1

You can iterate over the Read method:

while(sdr.Read())
{
    //Use get methods ex. sdr.GetString(columnIndex) or indexer sdr["firstName"] to 
    //extract data and place them in to other objects for further processing.
}

answered Feb 27, 2020 at 20:16

W. Winnie

1066 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert SqlDataReader into array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related