sql statement not working properly

modoufuloo modoufuloo

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

2 Replies

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

Imtiyaz Ansari13y ago

HI

character value where condition :- ' " + TxtName.text + " '
numeric value :- " + Txtid.text + "
Vulpes13y ago
You need to surround textBox1.Text with single quotes:

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