Hi, on a form I have a datagrid, list box, a button and a textbox. It is all linked to a database (Used access). In the database there are 2 columns, the first is the type of item, and the other columns is the amount in stock. The listbox shows the type of item, and the textbox shows the...
Hey well I have the following:
Dim myconnection As New OleDb.OleDbConnection
myconnection.connectionstring = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = C:\Documents and Settings\Frank\Desktop\Equipment.mdb"
But on the second line, it underlines "MyConnection" and says...
Sorry, what would I replace Myconnection with? What would the my connection mean? Also upon the following coding which goes with the button, I replaced the (tablename) with (AddRemoveItems) and it says it has not been declared for some reason.
me.OleDbDataAdapter1.Update(tablename)
Thanks for...
Hi, I used your coding but had to change the Datagridview to Datagrid1 as that is what its called. The problem I have now is Only the "listbox" Column is shown, however I want all of the columns to be shown.
Hi, Ive tried Google but cant find anything. I know I should be using Dataset but for what I need to do i prefer Datatable. However So far I have the following in a Buttons command, but its still not working:
Equipmentadapter.Update(oDatatable)
Im sure i have to mention textbox1 Somewhere...
Hi i have the following coding which adds text from textboxes in to a datagrid, with these text boxes there is a listbox, is it possible to add all the data within the listbox to a cell or a few cells in the datagrid? Thanks
Addorder("Name") = TextBox1.Text
Addorder("Dept") = TextBox2.Text
Basically in the datagrid the text at the top is too big for the columns and they are not sized as they should be by showing the full texts. Nope in access its different to hwo it is shown in vb for some strange reason.
Hi I have linked my Vb program to my database, but when the datagrid shows the data, the allignment of the collumns is not to its original size if you understand, also when linking to the database the columns are not in the correct order as they should be (the correct order is in Access) rather...
Hi, I have the following coding which shows data from a database. However throughout the form the number in Textbox1 Changes, when I exit the program and re-load the program the quantity number does not change. The coding I have used is:
visual basic code:Dim connStr As String = _
"Provider...
Hi, I know im going to sound stupid but I need help with linking Vb.Net to access. I would prefer the most easy approach as I have not that much knowledge.
Hi, I was wondering is it possible to re-activate the current form? I have some coding which is in the form activate, and that coding needs to be run a few times but the only way I can get it to work is clicking on to another form and returning to the form. I have tried me.activate, or...
Hi mstrmage1768, I know it sounds stupid from where you are sitting but it is the best solution to what I am trying to achieve. Basically, the system I amtrying to build lets users see what type of items I have and the Quantities of the items. Different Items in Listbox1 have different...
Hello Tipgiver, Sorry I dont think you understood what I was trying to say, I know it sounds confusing but let me break it down. I have 2 ListBox's, Basically there are items in Listbox1, and the user selects a Random item and clicks on the first button, this makes the selected Item appear in...
Hi, I was wondering if anybody out there could help me out a little bit. I have two list boxes and 2 buttons, there are items in listbox 1 and the first button adds the items to the list box2, the second button only removes items from listbox2 and does not alter any of the items in list box1. As...
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.