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!

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

Search results for query: *

  • Users: lanm
  • Order by date
  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

    ...DANewName.SelectCommand = cmd Dim DSNewName As New DataSet DANewName.Fill(DSNewName) '************************************ If Cache("DSNewName") Is Nothing Then CacheDS("DSNewname", DSNewName) End If...
  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!
  16. lanm

    Updatecommand with Datagrid problem

    now, I get an error on the line of code: Dim ddlP3ResCode As DropDownList = CType(e.Item.Cells(4).Controls(7), DropDownList) This is the third row / second column of the HTML table. I have the first dropdownlist working correctly, which is the first row / second column, and it's line of...
  17. lanm

    Updatecommand with Datagrid problem

    Thanks ca8msm! I just had to do: txtType = CType(e.Item.Cells(4).Controls(2), TextBox).Text.ToString() ...and it worked.
  18. lanm

    Updatecommand with Datagrid problem

    I'm using the first data column's EditItem Template to allow the user to edit 6 fields. This has allowed us to get the datagrid to expand vertically and increase the font size too. I'm using an HTML table control to hold the text boxes and dropdownlists so it's structured, but now...on the...
  19. lanm

    Hide cells on Editcommand

    Thanks ca8msm! That's working!
  20. lanm

    Hide cells on Editcommand

    I'm using the first data cell (index 2 since I use the Edit and Delete columns) template column to place all data edits in the first data column in order to have the datagrid expand vertically. What I'd like to do is hide the other cells in the row, as I only need this one column (index 2)...

Part and Inventory Search

Back
Top