Sql server 2008 Spatial data type

• amrit-494341

  SSC Rookie

  Points: 45

  More actions

  March 19, 2009 at 11:42 pm

  #103709

  I m using vc++ with ado and i want to insert data into spatial datatype column using vc++,

  But i m not able to insert ,

  My code is

  CString FieldName=(TCHAR*)tmpColumn->ColumnName;

  HRESULT hr=field->put_Value(COleVariant(tempValue));

  here FieldName shows the column name

  and tempValue is CString type and consists the following values

  ('point(2 4)').

  So plz tell me how to execute .

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  March 20, 2009 at 8:50 am

  #963577

  You could if you use SMO because VC++ does not support ADO.NET, so start with the link below.

  http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.datatype.geometry.aspx

  Kind regards,
  Gift Peddie