OdbcDataAdapter Insert Command

monteiro

Hi,
I am using OdbcDataAdapter to insert data to postgreeSQL..
Everything’s seems to be fine, but nothing is inserting in the database. Andy Idea??
Thanks in advance

Expand|Select|Wrap|Line Numbers

 string selectCommand = "SELECT ROAD_ID, PONTOS  FROM geom";

OdbcDataAdapter adapter = new OdbcDataAdapter(selectCommand, connection);

adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

try

   {

      adapter.InsertCommand = new OdbcCommand("INSERT INTO geom (ROAD_ID,PONTOS) " + "VALUES (4,GeomFromText('POINT(2000 243118 191108)',-1));");

}

......

debasisdas

Are you getting any error from the code ?

What is GeomFromText('POINT in your code ?

monteiro

Quote:

Originally Posted by debasisdas

Are you getting any error from the code ?
What is GeomFromText('POINT in your code ?

No i don´t receive any error.
GeomFromText is used to convert a Spatial reference system, version of a geometry into a PostGIS geometry.

OdbcDataAdapter Insert Command

re: OdbcDataAdapter Insert Command

re: OdbcDataAdapter Insert Command

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about