Vb.net Check If Record Exists In SQL Database

in this post you can learn about the if Record exists in SQL Server Database.Sometimes we put by mistake the duplicate entry in our text box for insert to database. For that we need to use this query because it will inform me about same entry. Use the below coding as per video instruction.

Imports System.Data.SqlClient Imports System.Data.Sql Imports System.IO Public Class Form1 Dim cnoo As New SqlConnection("") Dim cmddd As New SqlCommand Dim dr As SqlDataAdapter Private Sub B_Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles B_Save.Click If T_number.Text = "" Then MessageBox.Show("Fill Number Box") Else cmddd.Connection = cnoo cmddd.CommandText = "SELECT * FROM Table1 WHERE number='" & T_number.Text & "'" Dim adapter As New SqlDataAdapter(cmddd) Dim table As New DataTable() adapter.Fill(table) If table.Rows.Count() > 0 Then MessageBox.Show("Data Already Available! Go to Search Then Update") Else ' Type here your insert code End If End If End Sub