Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lanm

  1. lanm

    Trying to cache dataset for 10 dropdownlists

    Got it by (see =>): =>DSNewName = Cache("DSNewName") KSddlNewName.DataSource = DSNewName KSddlNewName.DataTextField = "Expr4" KSddlNewName.DataValueField = "ZNumber" KSddlNewName.DataBind() KSddlNewName.Items.Insert(0, "") KSddlNewName2.DataSource =...
  2. lanm

    Trying to cache dataset for 10 dropdownlists

    ca8msm, Correct...I'm trying to build the KSddlNewName ddl from the cached dataset DSNewName
  3. lanm

    Trying to cache dataset for 10 dropdownlists

    Here's my code. I can't get the ddls to populate when the pages loads. I've only got two built in the code so far, but we want to be able to support 5-10 when the code goes live. I know the sprocs work, since since I tried using cache for the datasets, the ddls wouldn't populate. The...
  4. lanm

    Last Name parameter allow all data on first run

    Got it: check the allow "Blank Value" box for the parameter, then click "View Report" when the report is run! Thanks!
  5. lanm

    Last Name parameter allow all data on first run

    I have a query that uses a parameter for a person's last name in the where clause. I'd like to figure out how to get the report to pull all names the first time the report is run, then allow the user to specify specific records afterwards. I can't get the default values right, or I'm missing...
  6. lanm

    Trying to add row to dataset

    The dataset is created in cache from a previous / startup page. I declare the var: Dim dsContacts As dsContacts ..above the Page_Load event
  7. lanm

    Trying to add row to dataset

    Fixed with: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load adptContacts = Cache("adptContacts") dsContacts = Cache("dsContacts") dsContactTypes = Cache("dsContactTypes") If Not IsPostBack Then drpContactTypes.DataSource =...
  8. lanm

    Trying to add row to dataset

    Below is the code for the Page_load and button click event. When the button is clicked, I get: Object reference not set to an instance of an object. ..which happens @: Line 80: rowNew = dsContacts.Contacts.NewContactsRow Dim adptContacts As SqlDataAdapter Dim dsContacts As dsContacts...
  9. lanm

    Caching DataSet and DataAdapters

    BoulderBum, Thanks for the extra eyes on that one! It was the case sensitivity.
  10. lanm

    Caching DataSet and DataAdapters

    I've been asked that on another forum about the adapter. The "lab" for this chapter has you cache the connection, adapter, and the dataset. Thanks for the help!
  11. lanm

    Caching DataSet and DataAdapters

    I'm working through the MCAD training, and can't seems to get a dropdownlist to populate from a cached dataset: ********** Here's the code on the first page: Private Sub Page_Load(....) If Not IsPostBack Then AddtoCache("adptCalls", DA1) AddtoCache("adptContactTypes"...
  12. lanm

    Security on Folder for machine widely used

    Okay, it was a bit easier than I thought. 1. Go to Control Panel / Users Accounts / Change the way users log on or off 2. Un-check "Use the Welcome screen". This will now use the classic option where users are prompted for a username / password 3. I set the Computer administrator User...
  13. lanm

    Security on Folder for machine widely used

    One of our admin people uses a machine that others can get to. There is a folder on the hard drive she'd like to protect. I know I can create another user to log onto the machnine, but my questions are: 1. Can I password protect each account icon on the desktop (or just the admin's icon) 2...
  14. lanm

    Updatecommand with Datagrid problem

    ca8msm, That's doing the trick....using FindControl()! Thanks!
  15. lanm

    Updatecommand with Datagrid problem

    I'll try that! Thanks so much for the help! I'm getting closer with this whole thing!

Part and Inventory Search

Back
Top