I come from a MS Access background and am trying to develope a ASP.NET app using VB. I have a mdb which I have connected to with the accessdatasource control.
How do I use my own function in an expression in the SQL select statement to add a calculated field to the query?
Basically I have a table that has latitudes and longitudes and a function which determines distance between two sets of coordinates. I want to display all the records that are within x number of miles from a coordinate set but when I try to call my function from the accessdatasource it says its not defined. What is the best way to do this?