How to add information from database to list

Question

Good morning,

I am trying to retrieve the list of customer from the database

I have the following code

public List<Customer> ListOfCustomer()
        {
            SqlConnection myCon = new SqlConnection();
            string strConString = ConfigurationManager.ConnectionStrings[0].ConnectionString;
            myCon.ConnectionString = strConString;
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "UP_SELECT_CUSTOMER_BY_STOREID";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@StoreID", 1);
            SqlDataAdapter daCustomer = new SqlDataAdapter(cmd);
            DataSet dsCustomer = new DataSet();
            daCustomer.Fill(dsCustomer);
            List<Customer> CustList = new List<Customer>();
            return CustList;
        }

I can't figure out how to add the retrieve data to the list

Can someone help me please

thank you in advance

Suraj Kumar · Answer

Writting the below line at the end of your method is giving a blank object of Customer so it should be removed. List CustList = new List (); You should rewrite your method as shown below. SqlConnection connection = new SqlConnection(ConnectionString); command = new SqlCommand( "TestProcedure" , connection); command.CommandType = System.Data.CommandType.StoredProcedure; connection.Open(); SqlDataReader reader = command.ExecuteReader(); List TestList = new List (); Test test = null ; while (reader.Read()) { test = new Test(); test.ID = int .Parse(reader[ "ID" ].ToString()); test.Name = reader[ "Name" ].ToString(); TestList.Add(test); } OR to return data table directly, you can try as the below. SqlConnection connection = new SqlConnection(ConnectionString); command = new SqlCommand( "TestProcedure" , connection); command.CommandType = System.Data.CommandType.StoredProcedure; connection.Open(); DataTable dt = new DataTable(); dt.Load(command.ExecuteReader());

How to add information from database to list<t>