How to add information from database to list<t>

Good morning,

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

I have the following code

public List 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 CustList = new List();
            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

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());