Assign return value of function to column of mssql query

Question

If someone know i would be very thankful to help me how to assign return value of function as a field that can be printed on screen here is my code and a little better explanation:

  SqlCommand myCommand = new SqlCommand("SELECT latitude,longitude,name FROM otherLocations WHERE dbo.DistanceInKm(" +myx + "," + myy + "," + "latitude" + "," + "longitude" + ") < 5", connection);
        SqlDataReader myReader = null;
        myReader = myCommand.ExecuteReader();
        while (myReader.Read())
        {
            Response.Write(myReader["latitude"].ToString() + "<br>");
            Response.Write(myReader["longitude"].ToString() + "<br>");
            Response.Write(myReader["name"].ToString() + "<br>");
        }

I want to assign dbo.DistanceInKm return value to some field so i can show it on page by calling Response.Write(myReader["thatfield"].ToString() + "<br>"); So what i want to do is to add field that is defined with distanceinkm function for each row in table so i can print it on page or sort result by it.

Related: stackoverflow.com/a/15623108/26226

jrummell
– jrummell

2013-03-28 16:17:57 +00:00
Commented Mar 28, 2013 at 16:17 — jrummell
– jrummell, Commented Mar 28, 2013 at 16:17

jrummell · Accepted Answer · 2013-03-28 16:14:39Z

1

Add the function to your select list with an AS clause:

string query = @"SELECT latitude, longitude, name, 
     dbo.DistanceInKm(" +myx + "," + myy + "," + "latitude" + "," + "longitude" + @") < 5 
     as distance";

Then you can get the value from reader like any other column:

string distance = myReader["distance"].ToString();

answered Mar 28, 2013 at 16:14

jrummell

43.2k18 gold badges116 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Assign return value of function to column of mssql query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related