Sql statement problem

vks.gautam1

Well-known member
Joined
Oct 10, 2008
Messages
78
Location
Chandigarh, India
Programming Experience
Beginner
I am developing a VB project in which i want to search a value .& a text

In database i set
Mobile_no Field Text property .
now i want to search a no.

select * from table_name where mobile_no= ' " & textbox1.text & " '

But im not finding no.

Second i want to search a string how to write a query for this.
 
Last edited:
I am developing a VB project in which i want to search a value .& a text

In database i set
Mobile_no Field Text property .
now i want to search a no.

select * from table_name where mobile_no= ' " & textbox1.text & " '

But im not finding no.

Second i want to search a string how to write a query for this.

Now i have got where i was wrong i was giving space between ' & "
 
actually, youre forming your query entirely incorrectly.. :( read the PQ link in my signature to find out why
 

Latest posts

Back
Top