Search results for query: *

  1. P

    Question Creating an Excel Chart

    I am trying to create a program which will output data from a database and produce and Excel file with data and a chart. I have been able to create the Excel file and the data to go in. However, I have not been able to create the chart as I want to. What I am doing is create a workbook as...
  2. P

    Resolved Updating the BindSource

    Found Solution Sorry people....I keep posting then finding a solution. I unbound the particular column in question. Then when I set the Combobox databind properties to the arraylist I do the same for the combobox column in the datagridview. :D
  3. P

    Resolved Updating the BindSource

    Again I have hit a snag!!!! I have patched together a program, initially using the VS object helpers and then coding in functionality as and where I need it. Initially I had a problem updating a table from a combobox, but I did that with a class and attaching it an arraylist as I read on...
  4. P

    Resolved Two Display Values in Databound Combobox

    Found the Solutions Minutes After Posting I was binding to a dataset and not the bindingsource. Once this was done, it worked. For anyone that needs to know, the old entry has been commented out and the new one put in below. With BidOwnerComboBox .DisplayMember =...
  5. P

    Resolved Two Display Values in Databound Combobox

    I am having a problem display a first name and last name from another table that the form is bound to. After a lot of research and experimentation I managed to change the combo box from bound at design time to bound at run time. This displays all the records in the combo box and selects the...
  6. P

    Foreign key updating as -1

    Found the Answer For anyone who comes across this problem I found an answer. It may not be the best way of achieving the desired results, but it worked for me. The code is as follows: Private Sub ClientComboBox_Leave(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...
  7. P

    Foreign key updating as -1

    Please help me. All I want to do is enter text into a combo box and if it is not in the list then update the database. I have been able to do this, but the ID returned is always -1 and I can not work out how to retrieve the correct id number. Please help. I am working on a project at work...
  8. P

    Foreign key updating as -1

    The ID is an Access auto increment field. Working through this I have just assumed that both the ClientName, which is string and the ID field would update to the combo box. I am assuming that as far as that Clients table is concerned, this gets updated with...
  9. P

    Foreign key updating as -1

    I am having a problem and I'm pretty sure it is me missing something somewhere. I have set up a project in VS2008 and for most of the application I am using the Windows controls and their default behaviour. However, I have started programming in some functionality for the combo boxes that link...
  10. P

    Question Add Item To Databound ComboBox

    This may seem like a silly question, but i'm really stuck on this. Short story of how I got to situation first. I started a Windows app using all code for database connection and validation. However, it was always losing the formatting that I had set at run time. So I thought I would use the...
  11. P

    Question DataGridViewTextBoxColumn with dataset

    Absolutely. However, I have gone down the pure code route, so I was thinking that because of this, the program may have some anomolies. What I thought of trying was using more of the objects supplied with Visual Studio, so setting up an actual data source and bringing that into the...
  12. P

    Question DataGridViewTextBoxColumn with dataset

    Thank you for your reply cjard. I set the AutoGenerateColumns to false but this still managed to show the ID Column. Incidentally, another column is hidden and this does not keep be showed.
  13. P

    Question DataGridViewTextBoxColumn with dataset

    I hope you can help me. I have a form with the normal controls as well as a datagridview which get data from another table based on the record displayed. I have hidden the first two columns, as I do not want to show ID and QuoteNumber. However, I do want to display NumberOfPeople, StartDate...
Back
Top