How to read data from SqlDataReader in C# .Net

mfonjame...

SOLVED CLOSED ACTIVE ANSWERED
User: mfonjames
Posted: on Mar 31, 2014 08:14 AM
Forum: .Net Basics
Answer: 1
Views: 3570

Hello everyone, i am having this issue, i have a table in ms sql server database called customer,

and i am doing a select statement like: select top 5 customername, customeraddress, customerPhone, dateOfPurchase

from customer order by dateOfPurchase ASC in a stored procedure. and in my C# code i am using

datareader to retrive the records.

while (rdr.Read())
            {
                customername = rdr["customername"].ToString();
                customeraddress = rdr["customeraddress"].ToString();
                customerPhone = rdr["customerPhone"].ToString();
                dateOfPurchase = rdr["dateOfPurchase"].ToString();
            }

the above code is returning only the last record, i want to be able to store each of the customer record

in a variable. i.e.

while (rdr.Read())
            {

//customer#1

string customer_1_Name= rdr["customername"].ToString();
string customer_1_customeraddress= rdr["customeraddress"].ToString();

string customer_1_customerPhone=rdr["customerPhone"].ToString();

string customer_1_dateOfPurchase = rdr["dateOfPurchase"].ToString();

//customer#2

string customer_2_Name= rdr["customername"].ToString();
string customer_2_customeraddress= rdr["customeraddress"].ToString();

string customer_2_customerPhone=rdr["customerPhone"].ToString();

string customer_2_dateOfPurchase = rdr["dateOfPurchase"].ToString();

//etc

}

Please assist, thanks in advance...

Download FREE API for Word, Excel and PDF in ASP.Net

Azim

0 2

Reply
ANSWER
User: Azim
Replied: on Mar 31, 2014 09:28 AM
Report

Please refer this code.

C#:

public class Employees
{       
    public List<string> FirstName;
}
protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.PopulateEmployees();
    }
}

private void PopulateEmployees()
{
    string constr = ConfigurationManager.ConnectionStrings["conString2"].ConnectionString;
    using (SqlConnection _cn = new SqlConnection(constr))
    {
        List<int> id = new List<int>();
        List<string> fistName = new List<string>();
        using (SqlCommand _cmd = new SqlCommand("SELECT FirstName FROM Employees", _cn))
        {
            _cn.Open();

            SqlDataReader sdr = _cmd.ExecuteReader();

            while (sdr.Read())
            {                    
                fistName.Add(sdr["FirstName"].ToString());
            }

            Employees obj = new Employees();                
            obj.FirstName = fistName;
            _cn.Close();
        }
    }
}

Image:

Thank You.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to read data from SqlDataReader in C# .Net

Company

Explore

Follow us

Contact Us