!!! Reterive on the basis of primary key !!! Urgent

Hi ,
I have a problem, got a primary key by which i have to reterive the other values i.e i put the primary key no it should reterive parent and child values on the form.

please guide me with suggestion.

Wrgds
Ganesh.K

I found your question very confusing. Maybe a lot more info would help. Are you talking about an SQL query? Are you talking about form properties? What are you trying to do, in detail...

Hi,
the project is in access i'm using oledbadapter,
I created SQL Query with parameters added parameters and set the value to it first i had problem how to execute it. some how found that using oledbadapter.fill(Dataset) it works i'm able to retrive first number what ever i specify but when put other number for reterival it gives me primary key ,null, violation, etc...

Hope this was quite explainatory..
Could u please help me how to go about ...

Wrgds
Ganesh.K

try an OleDbCommand an use .ExecuteReader.... http://www.vbforums.com/showthread.p...hreadid=197229

just set the commadtext to the stored proc and set your param