在代码中给SQL2008中空间数据类型的存储过程赋值

using Microsoft.SqlServer.Types;

 

SqlCommand cmd = new SqlCommand();

SqlParameter geoParam = new SqlParameter(@gps, SqlDbType.Udt);
geoParam.UdtTypeName = "geography";
cmd.Parameters.Add(geoParam);

 

赋值:

public SqlGeography gpsValue
{
     get
      {
            return (SqlGeography)cmd.Parameters[@gps].Value;
       }
       set
       {
              cmd.Parameters[@gps].Value = value;
        }
}

 

usp.gpsValue = SqlGeography.Parse("POINT (" + txtLat.Text + " " + txtLong.Text + ")");

 txtLat.Text ,txtLong.Text  为坐标