<div>
The DataAdapter's Fill method also returns the number of rows successfully added to or refreshed in the DataSet. So you can check the return value of the statement Da1.Fill(Ds1) to fidn out if any rows have been added to the dataset
</div>


The DataAdapter's Fill method also returns the number of rows successfully added to or refreshed in the DataSet. So you can check the return value of the statement Da1.Fill(Ds1) to fidn out if any rows have been added to the dataset

<div>
<div class="content wysiwyg-content">
the followin is a section of code from an application<br />
<br />
&nbsp; Private Sub Reg_NumTextBox_GotFocus(By<wbr />Val sender As Object, ByVal e As System.EventArgs) Handles Reg_NumTextBox.GotFocus<br />
&nbsp; &nbsp; &nbsp; &nbsp; Stock_NumberTextBox.Text = UCase(Trim(Stock_NumberTex<wbr />tBox.Text)<wbr />)<br />
&nbsp; &nbsp; &nbsp; &nbsp; WhereString = &quot;&nbsp;WHERE [Stock Number] = '&quot; &amp;&nbsp;Stock_NumberTextBox.Text &amp;&nbsp;&quot;'&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; SqlSelect = New SqlCommand(SqlStr &amp;&nbsp;WhereString, SqlCon1)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Da1.SelectCommand = SqlSelect<br />
&nbsp; &nbsp; &nbsp; &nbsp; Da1.Fill(Ds1)<br />
' Would like something like:-<br />
' &nbsp; &nbsp; &nbsp; &nbsp;if ds1.eof then<br />
' &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; msgbox(&quot;Stock Number&quot; &amp;&nbsp;Stock_NumberTextBox.Text &nbsp;&amp; &quot;&nbsp;does Not Exist&quot;)<br />
' &nbsp; &nbsp; &nbsp; &nbsp;end if<br />
&nbsp; &nbsp; End Sub<br />
<br />
This works fine, but I would like to be able to detect if the query returns no data - like .EOF in classic ADO.<br />
<br />
Is there a simple way of doing this?<br />
<br />
thanks
</div>
</div>


the followin is a section of code from an application

  Private Sub Reg_NumTextBox_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles Reg_NumTextBox.GotFocus
        Stock_NumberTextBox.Text = UCase(Trim(Stock_NumberTextBox.Text))
        WhereString = " WHERE [Stock Number] = '" & Stock_NumberTextBox.Text & "'"
        SqlSelect = New SqlCommand(SqlStr & WhereString, SqlCon1)
        Da1.SelectCommand = SqlSelect
        Da1.Fill(Ds1)
' Would like something like:-
'        if ds1.eof then
'             msgbox("Stock Number" & Stock_NumberTextBox.Text  & " does Not Exist")
'        end if
    End Sub

This works fine, but I would like to be able to detect if the query returns no data - like .EOF in classic ADO.

Is there a simple way of doing this?

thanks

Detecting an empty dataset

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,