I'm trying to make a report where you see general information of a range of products. I have a stored procedure in sql server 2000 that has two parameters. I also have a DataEnvironment with a command that calls the stored procedure. I see both parameters in the property window of the command. My question is, how do I pass the text value of a combox to the value of each parameter?
My DataEnvironment is named DataEnvironment1, the Command is named Command1 and my parameters are named item1 and item2. The comboxes are named CmbCodigo1 and CmbCodigo2. And I have tried this:
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!