How to search by database and return a result by condition? (Already link normally)

moknapple

Currently the link is ready. The function to be implemented is based on Cname.text. Search table category
There are only 2 fields in the category table, Cname and CID (pk)
How to make the program get the CID corresponding to Cname?

tsh6969

select * from category where cname = '"&cname.text&"' ??? Wouldn't it be that simple, what is the relationship between the two fields in your database?

hanhuoby

Didn't understand, based on the string Cname.text itself, or the content of this text file?

aboonline

select * from category where cname = '"&cname.text&"'
This is based on the content of cname.text as the search criteria, which is your cname field.
In this way, can not take out the corresponding id.

jiangyixu

Better to add cname.text.trim

jiangyixu

1.Construct a datatable
Dataadapter.fill (datatable)
3, for each row in datatable
4, datatable.rows (i) ("CID") is every CID found