Search results

  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, 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...
  3. 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...
  4. 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...
  5. 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...
  6. daniness

    Populate Combobox w/Selected Item and All Other Items

    Hello All, Was wondering if I could please get some assistance with this. I have a frm1 and frm2. frm1 has a combobox, cboLocations, from which a location is selected and then the "Ok" button is clicked upon which frm2 loads. frm2 contains textboxes and other comboboxes, which all should...
  7. daniness

    Question Populate Textboxes Based on Combobox Selection NOT Using Databinding

    Hello Everyone, Could someone please advise on how to go about this? I have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the...
  8. daniness

    How to Pass Value from Stored Procedure?

    Hello All, I've been working on a project, but have decided to take another direction on it, after much and continued struggling. I started out trying to use data binding, but was advised to use straight SQL statements in the code. So what I'm trying to do now: I have 2 forms, frm1 and frm2...
  9. daniness

    Populate Combobox Text with Query Result

    Hello All, I would appreciate your assistance with the following issue I'm having: I have 2 tables: locations and depot: Locations: site_refnbr (primary key) site_name depot_refnbr(foreign key) Depot depot_refnbr (primary key) depot_name I have 2 forms, frm1 and frm2. Frm1 has a combobox...
  10. daniness

    Question Conversion from string "System.Data.DataRowView" to type 'Integer' is not valid

    Conversion from string "System.Data.DataRowView" to type 'Integer' is not valid Hello All, Could someone please help me with this? I have 2 forms, frm1 and frm2. frm1 has a combobox, cboLocations and based on what selection is made here, frm2 is loaded and its combobox, cboOffices is...
  11. daniness

    Binding Foreign Key to Combobox

    Hello All, Can anyone please advise me on this: I have 2 tables: Locations location_refnbr (pk) location_name office_refnbr (fk) Offices office_refnbr (pk) office_name On my first form, I have a combobox that is bound to the Locations table and displays all the different locations. Once...
  12. daniness

    Question Populate Cascading/Dependent Comboboxes

    Hello All, I'm new here and am a novice VB.Net programmer. Could someone please advise on how I can populate a combobox (combobox2) based on the selection made from another combobox (combobox1)? They are on different forms. Combobox1 lists locations, while combobox2 lists offices for each...
Top Bottom