21-11-17, 10:16 PM
NCHAR
NVARCHAR
PHP كود :
If ComboBox1.SelectedIndex < 0 Then Return
'==========================================================='
Dim SQL As String = "SELECT * FROM [PationtInfo] WHERE [" & {"PationtCode", "PationtName", "PationtReveal"}(ComboBox1.SelectedIndex) & "] LIKE '%' + @param + '%'"
Dim ADB As New SqlClient.SqlDataAdapter(SQL, Sqlconn)
ADB.SelectCommand.Parameters.AddWithValue("@param", TextBox1.Text)
Dim DT As New DataTable
ADB.Fill(DT)
'==========================================================='
DataGridView1.AutoGenerateColumns = False
DataGridView1.DataSource = DT
