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...
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
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...
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 =...
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...
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...
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...
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...
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...
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.