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...
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...
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
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...
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 :)
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!
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...
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:
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...
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...
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...