In this post you can learn how to Search Query By Urdu and Arabic (Text) In Sql Server Vb.Net copy the below coding then paste to following places
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 Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim cmded As New SqlCommand
cmded.Connection = cnoo
cmded.CommandText = "SELECT * FROM Table1 WHERE name=N'" + TextBox1.Text + "'"
Dim adapter As New SqlDataAdapter(cmded)
Dim table As New DataTable()
adapter.Fill(table)
If table.Rows.Count() > 0 Then
TextBox2.Text = table.Rows(0)(1).ToString()
MessageBox.Show("Record found!")
Else
MessageBox.Show("Record not found!")
End If
End Sub
End Class
Post a Comment