Using VB 2008, I am stumped. I have a fillby and getdataby table adapter query that does a SELECT COUNT from FILENAME where fieldname = textbox and I want to use the number of rows returned, but can't figure out how to reference it. This seems so simple, but I have been Googling this for nearly two hours and can't figure it out. Any help would be appreciated.
Thanks,
Bill P.
Bill Purkins
0
Light Poster
Recommended Answers
Jump to Post"Select Count (*) from FILENAME where fieldname = '" & Trim(textbox.text) & "' "
All 4 Replies
Jx_Man
987
Nearly a Senior Poster
Featured Poster
Bill Purkins
0
Light Poster
Jx_Man
987
Nearly a Senior Poster
Featured Poster
dgmdaily
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.