>>>That's what I'm looking for.. The names of the properties I Need to change for the Database name and the Parent Command!!!1
>
>>You can change the database name with this object hierarchy: >DataEnvironment1.Connection1.ConnectionString
>
>>Why do you want to change the Parent Command? If you have the same table >structure in both databases, you don't need to change anything else than the >ConnectionString.
>
>Because the defaul Query do not specified the cotation I want to print... He will print it all... I want to select the cotation number 10 then print it without creation a temporary table or view and drop it
Since you created a command, add a parameter to it and give a value to this parameter at run-time. This way, you won't have to change the command. Command are supposed to be static (except for parameter that vary from one call to another)!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com