sql statement not working properly

Question

Hello guys

I am selecting a record from a database with this statements:

BindingSource personalDetailsBindingSource = new BindingSource();
personalDetailsBindingSource.DataSource = GetData("Select * From PersonalDetails where FirstName="+textBox1.Text);

DataGridView2.DataSource = personalDetailsBindingSource;

in the sql statement the where clause is not working at all. If i remove the where clause I get the result of that but with the where clause I get an error.

kindly help,

Thanks in advance

Imtiyaz Ansari · Answer

HI character value where condition :- '  + TxtName.text +  ' numeric value :-  + Txtid.text +

Vulpes · Answer

You need to surround textBox1.Text with single quotes: personalDetailsBindingSource.DataSource = GetData(Select * From PersonalDetails where FirstName='+ textBox1.Text + ');