I've been doing everything by hand for so long simply because I could never get this to work in VS6....now..basically...the same thing is here in vs.net. Anyone have any idea how to parameterize a query to work with SQL Server? I know it will accept =? opposed to the @param from Access db's. What I'm trying to figure out is this....once you've put that in (the =?'s)....how in the world do you get the dataset and adapter to realize that you want a parameterized query...and that it should be looking for perameters. AND...WHERE do you define the parameters?????