• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

Record not found

I am using Northwind database. How can I  display msgbox when the record is not found?


Private Sub ToolStripButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton1.Click

        Dim connectionString As String = "Data Source= SUPERMAN;Initial Catalog=Northwind;Integrated Security=True"
        Dim con As New SqlConnection(connectionString)
        Dim selectSQL As String = "select *from orders where orderid = '" & Me.ToolStripTextBox1.Text & "'"
        Dim da As New SqlDataAdapter(selectSQL, con)
        Dim ds As New DataSet


        If Me.ToolStripTextBox1.Text = Nothing Then
            MessageBox.Show("Please enter OrderId", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Information)



        Else


            da.Fill(ds, "orders")
            Me.DataGridView3.DataSource = ds.Tables("orders")

        End If

       

    End Sub
0
VBdotnet2005
Asked:
VBdotnet2005
1 Solution
 
ericwong27Commented:

 If ds.Tables("orders").Rows.Count = 0 Then

     ' Do  something

 End If
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now