How Do I Fill List From Database ?

List<string> temp = new List<string>();
SqlConnection connectToDb = new SqlConnection(mycon);
SqlCommand cmd = new SqlCommand(getsp, connectToDb); 
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

foreach(DataRow dr in dt.Rows)
{
    temp.Add(dr["Name"].ToString());     // your column name instead.
}

return temp;