# How can i pull raster data from database?

**URL:** <https://mapwindow.discourse.group/t/how-can-i-pull-raster-data-from-database/678>\
**Category:** Uncategorized\
**Created:** [July 29, 2020, 5:47am UTC](https://mapwindow.discourse.group/t/how-can-i-pull-raster-data-from-database/678 "2020-07-29T05:47:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zahid](https://avatars.discourse-cdn.com/v4/letter/z/e79b87/32.png) [@zahid](https://mapwindow.discourse.group/u/zahid)\
**Post date:** [July 29, 2020, 5:47am UTC](https://mapwindow.discourse.group/t/how-can-i-pull-raster-data-from-database/678/1 "2020-07-29T05:47:14Z")

</div>

Hi Everyone,

I am trying to show spatial datas using MapWinGis in C#. The database that i am using is postgresql/PostGIS. I have number of tables in my database either in vector and raster format. To call and show these datas i am using the code below.

```
        string text = textBox1.Text;
        string sql = "SELECT * FROM public.\"" + text + "\"";
        int handle = axMap1.AddLayerFromDatabase(ConnectionString, sql, true); 

```

For vector datas which is stored in database with ‘geom’ type, works perfect but for raster data (column type is raster) does not work. ‘AddLayerFromDatabase’ function returns a layer but it is am empty layer. when i call the function ‘ZoomToLayer’ it goes to (0,0).

My raster data is a .tif file. i use raster2pgsql.exe to upload it. I don’t get any error but can’t view it.

How can i pull raster data from my database and view it on Map?

---

<div class="post-metadata">

**Author:** ![pmeems](https://yyz2.discourse-cdn.com/free1/user_avatar/mapwindow.discourse.group/pmeems/32/9_2.png) [@pmeems](https://mapwindow.discourse.group/u/pmeems)\
**Post date:** [January 5, 2022, 3:09pm UTC](https://mapwindow.discourse.group/t/how-can-i-pull-raster-data-from-database/678/2 "2022-01-05T15:09:06Z")

</div>