Web Development

Ask something
Question Locked

sql select comand in VB

0 helpful
2 replies

by sajjad81

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In minr project i use that query it is workinf fine.
"select * from attend where eid=" & CLng(eid.Text)
but i can not wirte a query for two fields. i try tyo write that
"select * from attend where eid= and field2=" & CLng(eid.Text) and clng(1)
but i get a error data missmatch.
can any body helpme??

2 replies

by thecool_ranjith

just type:
"select * from tablename where fieldname1 ='" & text1.text & "'and fieldname2 = '" & text2.text & "';"

This discussion is closed to new replies.