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