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

[krigans]

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

[hellswraith]

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...

[krigans]

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

[Magiaus]

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