VS 2010 : Loading And Saving To Database?
Sep 12, 2011
I need some help with this project I'm trying to get my program to load and save data to an online database and I haven't been able to find anything that helps me to much, I have the working code for a local database but this program will be being used to multiple people for our business I want everybody to be able to add data, delete data, and such as necessary...
Here is the code i have for opening the file on my local machine
Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|data.mdb;")
but i can't get it to open from my webpage
View 10 Replies
ADVERTISEMENT
Feb 8, 2009
I want to load images into a picturebox, save them into a database and display them again in the picturebox. This is the code I'm actually having problem with:
Private Connection As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:UsersclientDocumentsVisual Studio 2008ProjectsSavingsLoansCalc.mdb"
rivate Sub UploadButton_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles UploadButton.Click
[Code] .....
I'm getting this error message:
"Type 'Connection' is not declared"
On this line:
oConn = New OleDb.OleDbConnection( _
New Connection().getConnectionString)
View 6 Replies
Aug 2, 2009
I would like to enable my app to run from a central database, but I dont want to recompile should the DB server change. Are my only two options saving the connection string to an XML file or the registry?
If so I think the XML file will probably be the way I go at least for me. I dont really want to mess with the registry. I just wanted to check what my options are.
View 10 Replies
May 9, 2012
what I am trying to do is get a program to load data from a text file with multiple lines in the form "Name, Type, Stocklvl, Price, Location, Reorderlvl" then display it all in a data grid. From where it can be viewed and edited as well as saved back into the original file stock.txt as well as generating a separate file reorder.txt which includes data on what needs to be reordered and the date which updates on program exit. I have chosen to use datagridview something I'm unfamiliar with as I figure It'd probably be the most functional to meet my needs of displaying a lot of data clearly as much as 200 items.
View 22 Replies
Apr 16, 2012
Ok, as you can see I am totaly new with Visual Basic. I have learned all those loops, if&else statements, byval, byref and etc. But now, I want to create this kind of application. I have 3 textboxes. One will contain URL, second username, and last password. There is a listbox also and a button. I want when user add a values inside textboxes , that values go to listbox as one variable and then save those settings for user so when he start up application again there are saved variables inside listbox. I just dont know how to do that.
View 11 Replies
Oct 27, 2009
no beating around the bush, here's the code.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myXMLFile As String = Application.StartupPath & "creditors.xml"
[code].....
View 7 Replies
Oct 7, 2011
I'm loading 3 comboboxes and a treeview with values, from a remote database when the app starts. As we all know the app freezes until it's done loading. I want to speed things up.
Dim _thread As Thread
_thread = New Thread(AddressOf test_loading)
_thread.Start()
[code]....
When I execute this code I get the following error:
mycomboboc.Items.Add(reader.Item("columnname").ToString)Cross-thread operation not valid: Control '' accessed from a thread other than the thread it was created on.
View 14 Replies
Apr 23, 2011
I think I have written code for saving All textbox's, maskedtextbox, datetimepicker,ombobox's ect.....I have a save button on a form called "SaveButton8" And what I want is when a user fills out the form, and when they click the savebutton8 I want all the froms, Textbox's, Maskedtextbox, Datetimepicker, Combobox's ect..... to save to the database. I have looked all over the forum with no sucess. here is my code:
Private Sub Button8_Click(sender As System.Object, e As System.EventArgs) Handles Button8.Click
'BookingTableBindingNavigatorSaveItem.PerformClick()
[code].....
View 6 Replies
Sep 6, 2011
I am very new to all of this, and I am trying to build my first program. I have a set of textboxes that are bound to columns in my data set. I am trying to save the changes made to the dataset back to the database. i found the following code online that I am using to do that:
[Code]....
View 5 Replies
Mar 10, 2011
Dim Connection As New OleDb.OleDbConnection
Dim dbProvider As String = "Provider=Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Database Password=cSSO3sEEhrM4vY3je0qC;" 'connect to the access 2010 database, including DB Password
[code].....
View 11 Replies
Oct 24, 2011
I have a MS Access database file that I can view with a DataGridView, but I can not save the changes made. User should be able to modify data, and when pressing the "Save" button, these changes should be reflected on the database. That is not happening.I know this is a common question, but I have read dozens of pages trying yo get this to work.
Imports System.Data.OleDb
Public Class Form1
Dim con1 As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=T:JaimeTest.mdb;Persist Security Info=False")
Dim sql As String = "SELECT * FROM Table1"
[code]....
View 3 Replies
Apr 4, 2011
I keep getting an "Syntax error in Insert Into Statement." error message when trying to save an image to my Access database.
Imports System.IO
Imports System.Data.OleDb
Imports System.Drawing
[code]....
View 9 Replies
Mar 18, 2012
I'm working on a simple data logging program, and I have little to no database experience. I wrote a little VB forms app to log the data to ms access and then graph the data, but I'm having trouble with adding records to the database. First, I created a simple one table database in access. Then, I added the database to the project as a data source, and gave it a data set using the wizard. Right now my code looks like this:
[Code]...
There are no problems during build or run time, but I do not see changes to database after the program runs.
View 1 Replies
Jan 14, 2012
I have a rather straightforward question.How to I get a DataGrid in WPF to save/load raw XML files and have the ability to display/edit them with other controls? The application will only work offline so I won't need SQL. Just simply open, edit and save data to XML.
View 2 Replies
Feb 8, 2012
I am attempting to create a program that users can create "cards" that have user inputted data. There are textboxes for each field such as Name, Location, Description, etc What is the best way to save and load this information?
View 1 Replies
Jul 4, 2010
I'm making a log for my application.I have made the log and it works.I use the streamreader and the streamwriter to save and load the data. I thought that it would be more organized to have columns inside the log.The problem is how will i save the information to the text file and load it up again so that it could organize itself again. The code that i used to make the columns.
log.Columns.Add("Task performed ", CInt((log.Width - 4) * 0.3), HorizontalAlignment.Left)
log.Columns.Add("Time and date", CInt((log.Width - 4) * 0.2), HorizontalAlignment.Left)
log.Columns.Add(" Amount of detected files(s)", CInt((log.Width - 4) * 0.2), HorizontalAlignment.Left)
log.Columns.Add(" App version", CInt((log.Width - 4) * 0.4), HorizontalAlignment.Left)
The code that i use to add the information to the log.
[Code]...
View 4 Replies
Aug 7, 2009
how to create a bitmap image of a specified size? then how to save and reload such a bitmap to and from a file?VB2005 starter
View 1 Replies
Apr 5, 2012
I've been looking into the SaveFileDialog and OpenFileDialog features, but have been failing to implement them. The actualy program that I would be implementing this in is much larger, so alternative methods are welcomed.
[Code]...
View 10 Replies
Jan 10, 2012
I'm looking to work on a project at work and I'm preparing to do my home screen of my program and I'm stuck on how to prep for all of this. I want to be able to save projects (and its not just one form that will be saved, 26 future forms to be exact), load projects, create new projects and view available projects to be selected from in the home screen. Really a very standard home screen when concerning professional programming. I'm not quite sure how to go about this or when looking ahead what might be a best practice. I haven't worked with databases, so my knowledge is limited.
View 17 Replies
Aug 24, 2010
i want to save and load an array as and xml file. what is the easiers way to do so.
View 2 Replies
Oct 30, 2008
like when i close a program, i want it to save its location (i guess to the registry, idk) and then when it loads, i want it to load back where it was.this is what i have so far. it saves to the registry ok, but it doesnt load where it should. also, my button1 click is what saves the location for now, but this code is just a test app for this.
Code:
Imports System.IO
Imports Microsoft.Win32
[code].....
View 11 Replies
Jul 31, 2009
Using the Microsoft VB 2008 Express program, I'm making a SWd20 character sheet (D&D) to be distributed to a few friends. It's a program where the user can figure out stats, species, class, etc without having to make any calculations him/herself.. but this will all be in vain without saving it..
So I'd love to know how I could make it so the user can save and load the entire file(including buttons, labels, text boxes, menu strips, possibly multiple forms, etc) on his/her own computer.. Is this possible, and if so, how can I go about this?
I've already searched through and found lots on saving text in the files to .txt files, but that doesn't cover everything I need
View 14 Replies
Aug 15, 2009
a member mentioned, xml is similar to a txt file. txt files, i can manipulate quite well. so, if this is the case, it should not be to complicated to do as the thread title describes . that, of course is, if you already know how to even create an xml file. i do not. any and all input/suggestions welcomed, links for xml noobing welcomed as well.
i like: VB General google fast cars username password
View 11 Replies
Apr 2, 2012
I am doing a project for part of my coursework which involves the creation of a series circuit designer.
I am having some trouble with the saving and loading functions; I had intended to save them to a text file with commas separating the component name and the value (if any) attributed with it.
Grid(xcoord, ycoord, 0) contains the component name. Grid(xcoord, ycoord, 1) contains the attached value (resistance or voltage- components such as wires have a value here of 0)
Once the save button is pressed, the text file contains 50 rows of "0".
P.S. Let me know if any other parts of my program are required.
Dim comp(maxsize) as ccircuits[globally declared]
Const maxsize = 50
Structure ccircuits
[Code]....
View 2 Replies
Dec 6, 2009
I am trying to Save a Form In My.Settings Then Be able to close the Application Then Open it and Have all the Forms. I need to Save and Load Multiple Forms At a time. I also need to be able to remove one of the saved forms when it is closed before the
View 9 Replies
Oct 18, 2009
What would be the best way to load and save a multi-dimensional array (of bytes). I've looked through streamreader tutorials but it always seems to instructions on how to save strings. I also know there's a very easy way to save a one-dimensional array, but it doesn't work on multi-dimensional ones. What should I be reading up on?
View 5 Replies
Dec 28, 2010
How can I combine specialized string collections so that I can accomplish this :
-Save all the tab's texts from a tabcontrol
-Save contents of the tabs : eg.Every tab contains a label and I save the text of each label
And the real problem:
-Loading them when the program opens
I have made some thoughts about saving them, but not about loading them
setting.TabNames.Clear()
setting.TabLabels.Clear()
For Each item As TabPage In TabControl1.TabPages
Dim name As String = item.Text
setting.TabNames.Add(name)
[Code] .....
View 9 Replies
Nov 29, 2008
I've got a textbox using a custom auto complete source, which gathers info from what the user has previously typed. Problem is, I can't figure out how to have that source saved when the application closes and loaded when the application opens.
View 6 Replies
Jun 20, 2012
I am quite new to VB.NET and I am attempting to create a console application that can write, save, load and edit sets of data. Lets say I have something like this:
[Code]...
However, I have no idea how to load the data so I can manipulate it in the EMPLOYEE structure system. I am not sure if I have made my question clear enough, for as you can see I'm quite new to programming and am not essentially familiar with the terms of speech.
View 1 Replies
Sep 5, 2009
Is it possible to create a kinda virtual storage in a vb application so that data created during run time are stored right in the applicaion instead of its environment?
View 11 Replies
