Displaying map icons where the longitude and latitude is stored in a SQL database

I will give you a vague answer, as all I know is are using C#, some flavor of SQL, and an unknown display medium.

For the SQL portion, I will use a minimal table structure

CREATE TABLE dbo.Locations (
  LocID   INT IDENTITY(1,1) NOT NULL,
  locName NVARCHAR(100)		NULL,	-- Location Name
  LocLat  DECIMAL(9,6)		NULL,	-- Latitude
  LocLng  DECIMAL(9,6)		NULL,	-- Longitude
  CONSTRAINT [PK_Locations_ID] PRIMARY KEY CLUSTERED([LocID] ASC) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT Locations( LocName, LocLat, LocLng)
VALUES  ('Los Angeles', 34.05223, -118.24368)
,       ('Santa Monica', 34.02421, -118.49647)
,       ('Redondo Beach', 33.84918, -118.38840)
,       ('Newport Beach', 33.62834, -117.92793)
,       ('Long Beach', 33.77005, -118.19373)
GO

The next 2 parts will be in C#; first a POCO

CREATE TABLE dbo.Locations (
	public int LocID
	public string LocName
	public double LocLat
	public double LocLng
}

And the second will be population

// write your own code, but here are the highlights

string cmd = "SELECT LocName, LocLat, LocLng FROM Locations"
// create DataReader and use above to populate
// return Collection<Locations> from above DataReader

Last thing is to display this. Without knowing how you intend to do this all I can tell is to just pass the above collection and iterate through it.