<div>
Hi. Sorry this took so long but here is the rest of the code<br />

<pre><code id="code-20-41908598-1">    Sub oSave()

        Me.lblSave.Text = &quot;&quot;
        Me.lblError.Text = &quot;&quot;
        Dim S As String = &quot;&quot;

        Try

            Dim oHoleNumber As String
            If txtOtherHoleNumber.Text = &quot;&quot; Then
                oHoleNumber = Me.DropDownList_HoleNumber.Text
            Else
                oHoleNumber = Me.txtOtherHoleNumber.Text
            End If
            S = &quot;Select Top 1&quot;
            S = S &amp; &quot;[Drilled To] From Performance&quot;
            S = S &amp; &quot; Where [Hole Number] = '&quot; &amp; oHoleNumber &amp; &quot;'&quot;
            S = S &amp; &quot; Order By [ID] Desc&quot;  

        Catch ex As Exception
            Me.lblError.Text = ex.Message
        End Try
    End Sub</code></pre>
</div>


Hi. Sorry this took so long but here is the rest of the code


    Sub oSave()

        Me.lblSave.Text = ""
        Me.lblError.Text = ""
        Dim S As String = ""

        Try

            Dim oHoleNumber As String
            If txtOtherHoleNumber.Text = "" Then
                oHoleNumber = Me.DropDownList_HoleNumber.Text
            Else
                oHoleNumber = Me.txtOtherHoleNumber.Text
            End If
            S = "Select Top 1"
            S = S & "[Drilled To] From Performance"
            S = S & " Where [Hole Number] = '" & oHoleNumber & "'"
            S = S & " Order By [ID] Desc"  

        Catch ex As Exception
            Me.lblError.Text = ex.Message
        End Try
    End Sub

<div>
That is odd it looks ok however what if DropDownList_HoleNumber has &nbsp;nothing selected when Me.txtOtherHoleNumber.Text<wbr /> is empty
</div>


That is odd it looks ok however what if DropDownList_HoleNumber has  nothing selected when Me.txtOtherHoleNumber.Text is empty

<div>
<div class="content wysiwyg-content">
Hi<br />
I am getting the error &quot;Object not set to an instance of an object&quot; in the following ASP.net VB.net code. This doesn't make any sense<br />
<br />
Dim S As String<br />
S = &quot;Select Top 1 [Drilled To] From Performance&quot;
</div>
</div>


Hi
I am getting the error "Object not set to an instance of an object" in the following ASP.net VB.net code. This doesn't make any sense

Dim S As String
S = "Select Top 1 [Drilled To] From Performance"

ASP.net VB.net Object not set to an instance of an object

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