how to use parameterized query for select and display the data in front panel table

[bhushan191096]

Hiiiiii

I am using acess 2007 database
I want to select the the specific  data in database using string control like "Select Product,Dimension,Weight From ProductInfo where Barcode(string control)=?"  and also display the same in front panel table.

I am using Database connecting toolkit.
I saw the example of parameterized insert but it didn't help to use parameterized select query and also to diplay data of parameterized select query.

I looked for example on parameterized select query but i didn't get any.
So pls guide me how to do this. I would like to know other method(if any) than using  parameterized query to perform same.
If possble pls share a reference vi.
Thank you!!!

[szewczak]

The lack of this comments Might be because of the broad nature of your question. lets break it down.

What you are describing is defiantly possible: see the links below:

http://digital.ni.com/public.nsf/allkb/8BDBCD17DD091B788625772300757446
http://digital.ni.com/public.nsf/allkb/1D5EB4DCBD13106486256B9D005E11B0
https://decibel.ni.com/content/docs/DOC-11448

I would suggest getting the first few steps off the ground (connecting, displaying in an unideal display) then posting your incomplete work here with a more specific question.

Or hire me to do it 😛

[bhushan191096 · Accepted solution]

Hii szewczak
thanks for reply
but i didnt getsolution in any one of your shared links
My problem is solved. There is no need to use parameterized query for selecting values from control
In my case i want to display data from database where barcode no is same as entered by user
i use DB TOOL SELECT data function and create string condition by concatenate strings function