Problem with Search DataGridView by using ComboBox and Text

Good morning all,

I try to affect a filter / search on datagridview by a combobox and textbox but when I type the first letter (s) on textbox an error message is displayed:

System.Data.SqlClient.SqlException*: 'Syntaxe incorrect vers 's%'.'

here is my code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Configuration;
using System.Data.SqlClient;
namespace TESTSEARCH
{
public partial class FormFind : Form
{
public FormFind()
{
InitializeComponent();
}
private void FormFind_Load(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
string constring = ConfigurationManager.ConnectionStrings["TESTDEMO.Properties.Settings.connect"].ConnectionString;
SqlConnection con = new SqlConnection(constring);
if (comboBox1.Text == "BD_NameConn")
{
SqlDataAdapter Sda = new SqlDataAdapter ("Select BD_NameConn, BD_BaseType, BD_Base, BD_Serer, BD_User, BD_MenuStyle FROM BD WHERE BD_NameConn '" + textBox1.Text + "%'",con);
DataTable Dt = new DataTable();
Sda.Fill(Dt);
dataGridView1.DataSource = Dt;
}
}
}
}

it stops in the line Sda.Fill (Dt); and displays the message :

System.Data.SqlClient.SqlException*: 'Syntaxe incorrecte vers 's%'.'

I await your help and thank you in advance

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Hi,

Please try this link which will help you and it does same,
https://www.aspsnippets.com/Articles/Search-and-Filter-GridView-on-TextBox-OnTextChanged-event-in-ASPNet-using-C-and-VBNet.aspx
Vinay Singh6y ago
Hi Please chekc hte link

https://www.youtube.com/watch?v=g0qy7_l7vFg
https://www.youtube.com/watch?v=eYUMCwh2MKE
https://www.youtube.com/watch?v=KaQs1K63Q-o
https://www.c-sharpcorner.com/UploadFile/1e050f/search-record-in-datagridview-C-Sharp/
Rajanikant Hawaldar6y ago
You not added LIKE operator / Clause
SqlDataAdapter Sda = new SqlDataAdapter ("Select BD_NameConn, BD_BaseType, BD_Base, BD_Serer, BD_User, BD_MenuStyle FROM BD WHERE BD_NameConn LIKE '" + textBox1.Text + "%'",con);