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 为坐标