Recent content by daniness

  1. daniness

    Foreign Key Values Not Passing on Button Click Event

    Hello All, I've been having a hard time trying to figure out why some values, which happen to be foreign keys, are not passing between my stored procedure and my code on a button click event. I keep receiving the error, "Procedure or Function 'sp_OrderTracking_Update_UpdateItem' expects...
  2. daniness

    Question Saving New Selection from Combobox to SQL Database

    Hello All, Thanks for your posts. The thing is, my comboboxes are populating correctly. What I need them to do is if another item is selected from any of them, I'd like to save the new item (i.e. new depot, freight forwarder, dispatcher) to the database as an update to that particular location...
  3. daniness

    Question Saving New Selection from Combobox to SQL Database

    Thanks everyone. We can only hope to achieve the same status as cjard one day:)
  4. daniness

    Question Saving New Selection from Combobox to SQL Database

    InertiaM, Thanks.........I caught that too and changed it to @Email, but it made no difference....any other suggestions, please?
  5. daniness

    Question Saving New Selection from Combobox to SQL Database

    Hi ss7thirty and All, Yup, everything in my stored procedure matches up. Here it is; could you please advise: ALTER PROCEDURE dbo.sp_OrderTracking_Update_UpdateItem ( @site varchar(30), @siteRefnbr varchar(5), @aac varchar(10), @phoneNbr varchar(20), @faxNbr varchar(20), @depot...
  6. daniness

    Question Saving New Selection from Combobox to SQL Database

    Hello All, I'm back! Hoping you can help me with this one. I have an app I'm working on with multiple forms. One of the forms, frmLocationInfo, has textboxes and comboboxes which are automatically populated based on a combobox selection from a previous form, frmLocations. I've been able to get...
  7. daniness

    Resolved TextBox Transparent

    BackColor Property Hi JuggaloBrotha, There is an option for textbox properties, called "BackColor". If you click on the dropdown arrow and select the "Web" tab, at the top of the list is an option for "Transparent". Hope that helps :)
  8. daniness

    Question Update SQL Table Using Stored Procedure

    Hi MattP, Thanks for your reply. I tried adding the "BEGIN" and "END", but I'm still receiving the "Procedure sp_OrderTracking_Update_UpdateItem has no parameters and arguments were supplied." error. Do you have any other ideas as to what's causing this? Thanks in advance!
  9. daniness

    Question Update SQL Table Using Stored Procedure

    Hello All, I would appreciate if you could please advise on the problem I'm running into while attempting to get my app to update a database. I'm using a stored procedure, but am receiving a "Procedure sp_OrderTracking_Update_UpdateItem has no parameters and arguments were supplied" error. Here...
  10. daniness

    How to Edit SQL Table Row via Textboxes?

    jmcilhinney, Thanks for the advice. I will give it a try. Regarding the 3rd step you've suggested, what if I'm not using databinding?
  11. daniness

    How to Edit SQL Table Row via Textboxes?

    Hi jmcilhinney, Okay, so I've uncommented out the part I think is behind the save, but now I'm receiving the error, "Update unable to find TableMapping['Locations'] or DataTable 'Locations'." Any clue as to what's causing this? :confused: Here is my code for this as of right now: Private Sub...
  12. daniness

    How to Edit SQL Table Row via Textboxes?

    Hi jmcilhinney, Thanks for your reply. The database is actually attached to a SQL server. What would you suggest in this case? Thanks in advance.
  13. daniness

    How to Edit SQL Table Row via Textboxes?

    Hi All, I would appreciate your assistance with the following task: I'm trying to edit and save changes made to a row of a SQL table via Windows form textboxes. Right now when I run the app, I try to make a change to one of the textboxes, I click on the Save/Close button, but when I go to the...
  14. daniness

    Question How do I add items to a combo box depending on what the user selects in the other?

    Hi techwiz24, I've actually done something similar to this recently. I would imagine that your comboboxes are pulling from a table. Could you please provide your table structure and from that, I'll be able to show code to populate the 2nd combobox based on what is selected in the first. It has...
  15. daniness

    Concatenating Multiple NonNull Columns into Combobox Text Property

    Hello All, I would greatly appreciate your assistance with this issue. I'm trying to concatenate nonnull multiple columns from a database into the text property of a combobox. Right now, I'm receiving an "IndexOutOfRangeException was unhandled name, address1, address2". The line in red is where...
Top Bottom