|
-
Apr 27th, 2001, 03:48 PM
#1
Thread Starter
New Member
passing parameters to command object created in the data designer
This seems like it would be well documented but I have looked through about 20 websites and several books and still haven't found the answer. I am simply trying to pass parameters from my vb code to an ado query I've created using the data designer within vb. I want to bind the controls on my form to the data returned from the command object(sql). I have seen hundreds of examples of how to do the entire thing using vb code only(without building the query in the data designer), but I don't want to do it in code. Firstly, because it's tedious. Secondly, because if my data source moves, it's much quicker for me to visually change the properties of the connection rather than search for every reference to it in code. And thirdly, once my command object(sql) is created with the data designer, I can drag and drop the command object onto my form and it creates objects bound to the fields selected in my sql. There has to be a simple answer to this. Once I've created the query, it should just be a matter of passing the parameter value, requerying or something, then refreshing the form to see the new values in my textboxes. Anyone know of a good website or have a quick answer. THANKS IN ADVANCE!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|