To add a parameter to the data adapter

1. Select the data adapter icon, then expand the properties under SelectCommand in the Fill area of the Object Inspector.

You should be able to see your Select statement in the SelectCommand property drop down list box.

  1. Change the ParameterCount property to 1.
  2. Click the (Collection) entry next to the Parameters property. This displays the BdpParameter Collection Editor.
  3. Click Add to add a new parameter.
  4. Rename the parameter to emp.
  5. Set BdpType to String, DbType to Object, Direction to Input, Source Column to FIRST_NAME, and ParameterName to emp.
  6. Click OK.
  7. In the Object Inspector, set the Active property under Live Data to True.
Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook

Post a comment