<div>
Does it return a datatable?<br />
<br />
You can do something like below<br />
<br />
Dim dTable As DataTable = &nbsp;dropOffContext.selectDropO<wbr />ffLocation<wbr />sByZip(lat<wbr />itude, longitude)<br />
<br />
If dTable.Select(&quot;fieldname &gt;&nbsp;25&quot;).Count &gt;&nbsp;0 Then<br />
&nbsp; &nbsp;'Code to do what you want<br />
End If<br />
gvLocations.DataSource = dTable
</div>


<div>
This is the whole block<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-36350968-1"><span>Private dropOffContext As dataEntities</span>
<span>dropOffContext = New dataEntities()</span>
<span>            Using dropOffContext</span>
<span>                gvLocations.DataSource = dropOffContext.selectDropOffLocationsByZip(latitude, longitude)</span>
<span>                gvLocations.DataBind()</span>
<span>            End Using</span>
</code></pre>
<br />

</div>


<div>
Entity Framework? Beyond my knowledge.
</div>


<div>
I'm trying to get the min value of the distance field from the database:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-36366334-1"><span>            Using dropOffContext</span>
<span>                Dim temp = dropOffContext.selectDropOffLocationsByZip(latitude, longitude)</span>
<span>                gvLocations.DataSource = temp</span>
<span>                gvLocations.DataBind()</span>
<span></span>
<span>                [b]Dim test = temp.FirstOrDefault.distance.Value[/b]</span>
<span></span>
<span>            End Using</span>
</code></pre>
<br />
<br />
Any Ideas? <br />
<br />
I'm getting the following error: <br />
<br />
The result of a query cannot be enumerated more than once.
</div>


<div>
non of the answered worked.
</div>


<div>
<div class="content wysiwyg-content">
What is the best way todo this:<br />
<br />
I'm binding the results of stored procedure to a gridview in the following code:<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-27251012-1"><span> gvLocations.DataSource = dropOffContext.selectDropOffLocationsByZip(latitude, longitude)</span>
</code></pre>
<br />
What I would like todo is update a panel (pnlMailBack) with some code if the first result has a value &gt;25 in a particular field.<br />
<br />
Thanks,<br />
<br />
James.
</div>
</div>


What is the best way todo this:

I'm binding the results of stored procedure to a gridview in the following code:

(CODE)

What I would like todo is update a panel (pnlMailBack) with some code if the first result has a value >25 in a particular field.

Thanks,

James.

Test for min value from a datasource

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.