how to display the postGIS files

[windhello]

hi,
I'm a newer to use the AspMap(for. NET).
I converted  SimpleMapApp's shapefile(the first Demo sample of the C# Samples)  data to the postGIS .But I don't know how to  set the MapPath if  I use the data from postGIS,  the original code of mapfile like this:

private void AddMapLayers()
    {
        string MapFolder = MapPath("MAPS/WORLD/");

        map.AddLayer(MapFolder + "world.shp");
        map.AddLayer(MapFolder + "lakes.shp");
        map.AddLayer(MapFolder + "capitals.shp");

I use the  Visual Studio 2005,postGIS 8.4. C# language.

can someone  show me the details of how to display the postGIS files ?

Thanks in advance.

[amanero]

I usually work with VB.NET so I'm sorry, but my code is in VB.

Time ago I made a little project to do that; it's code is like this:

        Dim sqlSelect As String = "SELECT name, asBinary(the_geom) AS WkbGeometry FROM public.a0;"
        Dim connectionString As String = "Server=127.0.0.1;Database=callejero;User ID=postgres;password=postgres;"

        Dim adapter As Npgsql.NpgsqlDataAdapter = New Npgsql.NpgsqlDataAdapter(sqlSelect, connectionString)
        Dim dataTable As DataTable = New DataTable()

        adapter.Fill(dataTable)
        adapter.Dispose()

        Dim dbLayer As AspMap.Layer = Map.AddSpatialDataLayer(dataTable, "WkbGeometry")
        dbLayer.Symbol.LineColor = Color.Black
        dbLayer.Symbol.FillColor = Color.LightYellow
        dbLayer.Symbol.FillStyle = AspMap.FillStyle.Solid

[windhello]

OK, Thanks for your answers