My customers are literally screaming at me about loosing their data everytime a new version of my program is released. I have diagnosed the problem as being that a new blank copy is installed everytime, but I have no idea how to stop that from happening! Visual Studio 2008 with sp1
View 6 RepliesI have a database structure filled with data that I'm trying to write out to an XML file. Here's a taste of the way the VB code is structured:[code]I can't see or report any progress, because the processing is all tied to one giant LINQ query. Even if I can't make it any faster, I'd like to know how much longer I have to wait. My first version of this code had For loops instead of queries, so I could display progress, but it took a loot longer.Obviously I'd like to speed this up considerably. It seems like there should be a simpler way to convert the data to an XML file, especially since the database structure was created from the XSD in the first place.
View 1 RepliesI am writing a little utility to generate some SQL files. I have a file which is generated from a string array of 400+ elements. It stops writing (without throwing an error) at arround 1000 characters or 380 lines. I am clearly missing something here. Question is what? I've tried (the remed lines of) flush but that seems to have no effect.[[code]...
View 4 RepliesI am building an application that accepts input entered into textboxes, then checks the input for negative values, etc. before writing it to a file. If the data does not meet the conditions, a message box pops up letting the user know. The problem I am having is that after it checks the data and displays the message box, it continues to save the input to the file anyway. How do I make it only write to the file if all the data meets my conditions?
View 1 RepliesI'm currently developing an application for a POS Terminal using VB.net. Our project is approaching the last stage of development and I've been tasked to create 2 installers. 1 for Initial Installation, and the other for upgrade installation.
The project is composed of several elements. These are:
1. The application executable
2. Common DLLs that we developed
3. some resources (.resx and XML)
The requirement for the upgrade installer is that only those files with modification should be installed. (i.e. if only the xml or resx files are modified those are the only items that will be reinstalled, since the size of the upgrade installer is a consideration so we cannot reinstall everything).
I'm using Visual Studio 2005 for my deployment project but I'm a bit confused about how to set the properties of each file in such a way that during the upgrade, only the files that were modified would be updated and the rest of the files will not be removed since I'm setting RemovePreviousVersion property to True. I have a hunch that I need to do something with the custom action but I haven't been able to figure it out. The upgrade installer setup is almost the same as the initial installer except that all files are excluded.I tried to acquire a copy of Phil Wilson's book (The definitive guide to Windows Installer) but its not available in our local bookstore and it would take too long to order it.
Basically while tinkering with the settings/properties there are instances where the dll was not updated and there are also times when the application exe was removed.
I already verified that the Product code is the same for both installers and that I'm sure that the version number is being incremented for each upgrade.
If I will be redoing both installers from scratch, how should I go about it?
I'm also confused about the Condition property and the transitive property.
Triying to use the built in Visual Studio 2010 to install a couple of files and after that is done to run another installer package (3rd Party Installation Wizard).
View 1 Repliesi have this solution that i'm suppose to make an installer of, but because it calls a datebase and the database is not within the solution therefore it was not included in the installer.
and my installer cant work correctly. is there anyway i can go around doing it?
I have a problem with attaching sql server database to an installer file.
View 1 RepliesI have written a program in Visual Basic 10 and all is well. I have published it and have been burning the result to a cd and installed it on various computers, however it is the click once app, which has been fine till now. What I need to do now is to have the program install the .exe file and associated files (non click once app) to a specific drive on a computer or network computer. I have searched the net for instructions on how to initiate the windows installer and have failed. is there a program that you can select the source files then point to the installation folder tell it to go and an installation package gets made that I can burn to disk.
View 3 RepliesBasically I want to write to a database, lets say called testdatabase, and I want to write to a table called dbo.Test_table, under three different colums named one two three. How do I go about this? I created a data set connection to the database but it sits on the right hand side with the other forms and I dont know how to use it or write to those colums in the tables.
View 3 RepliesI have code/support an application built on .NET framework that has always run on .NET 2. This year we are upgrading the application to use .NET 3.5 (or 4?). In preparing for this change we noticed that that Offline Installer (required for our customer base) for .NET 3.5 is 200+ MBs bigger than the .NET 4 offline installer.
Here are my questions.Why is the dotnet 3.5 installer so much bigger than the 4 offline installer?
Can we TARGET .NET 3.5 but distribute .NET 4. In other words, is .NET 4 backwards compatible? Assuming that .NET 4 was the only installed .NET could application still target earlier frameworks?
IF our application is compiled for x86 CPU (rather than Any CPU) do you still have to distribute the x64/x86 Client Profile or can we just distribute the x86 Client Profile? In other words, can we distribute the x86 Client Profile even though it will be installed on x64 machines if our app is compiled for x86 target CPU? Any risks or gotchas for doing this?
The issue is that if we upgrade our app to target .NET 4 there are a lot of application servers that we also have to upgrade which effects a number of other applications.
I'm makin an application which will calculate the amount of carpet needed to floor a room, i would like to add in an order management bit too the application so that the user can add, delete and amend pending jobs. I'm a bit of a beginner so i don't know which way is really best to go, should i use file writing on database? I will be takin values from variables and textbox's if thats of any importance.
View 13 RepliesI have a table in a database with 3 columns: OfferName, ExperienceAward, and GoldAward
I populate a combobox with the various offer names with the code below:
Dim con As OleDbConnection = New OleDbConnection( _
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersDouglasDocumentsVisual Studio 2008ProjectsGameBoxRPGGameBoxRPGContacts.accdb;Persist Security Info=False")
Dim cmd As OleDbCommand = New _
[Code]....
I'm currently under way with a computing project for 6th form and I have encountered a problem when working with a local database.
To give an overview:
-My program is intending to take in data on lorries, drivers and other sections of the haulage industry through multiple forms and afterwards be returned in a suitable manner.
-I have no trouble in reading data from my database that I have set up. However I am unable to write back to the database.
-I can add the relevant new data to either the specific table(Driver_Table in this case) of the Database1DataSet.xsd or to a table set up in this manner.
-My problem is with the Driver_TableTableAdapter.update method.
-When I call this it returns a value of 1 (for one row added) but does not write this to the database.
In specifics the particular section (created to test this section of code) is:
'Dim tbl As New Database1DataSet.Driver_TableDataTable
Driver_TableTableAdapter1.Fill(Database1DataSet1.Driver_Table)
' Driver_TableTableAdapter1.Fill(tbl)
[code].....
Im trying to get my program to fill out textboxes with information it reads from a database, and then save the changes to the database. Does anybody know any good tutorials of this which i could look into?
View 6 RepliesI'm having a problem with some code which seems to stop my program from working correctly. Below is my (i have only added to code which i think you will only need to see.
Dim con As New OleDb.OleDbConnection
Dim dbprovider As String
Dim dbsource As String
[code]....
I want to be able to click on the save icon and have the data on the form save to the original database. Right now I seem to have a disconnected dataset I have tried to change everything from read only to a false statement but it just will not work. It saves to the form fine just not the orignial data base.
View 3 RepliesI have written a program that has a form called AddMembers. it is supposed to get users input from textboxes and write them to an access database. but I am getting an error message Argument not specified for parameter. Also my results are not sent to the database. I have attached both the zip program and also the database.
View 9 RepliesI'm currently doing a project, I have 5 text boxes, and the information I put inside them get's added to a record in my database..In this record, an auto-number is allocated, and I need to display what the auto-number allocated is..
View 7 RepliesI am trying to write the value of 3 variables (Username, Email, Password) to an SQLite Database. I can write text to the database but not a variable. How would I do this?
My Code:
SQCommand.CommandText = "INSERT INTO login_data (username, password, email) VALUES (Username, Password, Email)"
I am trying to write data back to my database in my project, but it keeps disappering when I make any changes to code. I can build the project, add data, close the project and build it again and the data is still there. But as soon as I make any changes to anything, on the next build, all of the data is gone.
The table will not be bound to any controls in the final project, but for testing purposes I have a datagrid control that it is bound to. My code started as follows:
[Code]...
I am creating a fault tracker AKA issue tracker. It is going to be very simple in functionality. As of right now I am using a text file as a database for the end user to store current issues.
The reason for me using a text file is that I do not know much about database programming and I cannot find any simple examples in the same usage. My question is, is it really going to become a problem as more issues are added to this file and it becomes larger? I.E using up more resources, application getting slower etc?
If so, could anyone point me in the right direction to creating a simple database application. Most examples I have seen require ask to download their pre-made database. Although I would like for the program to create a database if one is not there.
[Code]...
im having an issue writing to an access database via vb.net 2008 i can read form it but not write?
View 4 RepliesI have searched all over the forums and not found an answer to my question. My question is how do i write to an access database at runtime. The database is also created at runtime. I have a dataset loaded with a table that i needs to be written to the database. how would i write each row of my dataset to my database? Sorry if this sounds a little jumbled together it is late and i am tired. If it is unclear you can ask me and i will answer any questions you have about my question.
View 14 RepliesI have added a MySQL Database as a data source in VB using the MySQL .NET connector and added the dataset . How do i write to the database from there?
View 7 RepliesHow do I connect to a mysql database, and write a new column to a certain table there?
View 8 RepliesI use Visual Basic in Access, and I have no problem writing data directly to a cell in a database table. But I can not figure out how to write the code for Visual Basic 2008. For example I would
use Me![cust_Cost] = 20 to input 20 in the database table.
I have purchased two different Books on Visual Basic 2008 and not one of them show how to input data manually.
I have created a simple project where I have two forms, one a data entry form where a client name, address, city, state and zip are entered into textboxes. Then, the user clicks a button to add all this data to the datatable via a newrow. The second form includes a datagridview to show the datatable. However, I cannot get the code below to work to update the datatable. I have a button to click to check to see if the data is entered and it returns an error that no row exists.
View 2 Replieswriting to multiple rows in the database using VB 2010?
View 3 RepliesI'm building an application that is intended to function off and online using the new Local Database Cache functionality included with Visual Studio 2008. My issue however does not pertain to that directly, as I have a pretty good understanding of how to use it and how it functions. My issue is with getting an understanding on how to directly write to a SQL database.
Most of the tutorials, videos and education available when it comes to databinding makes the assumption that I need my application to pull data and edit it, but in my case all I really need (in fact intentionally all I want) is for the application on Submit to write data that it pulls from the form as a new record in a SQL table.
Here is what the program looks like now.
Public Class StatCom
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
At the moment the program simply does a status check for connectivity and wether it can ping the server (in this case the SQL server) for the purpose of displaying a online or offline status in the form.
I follow it up by making the status checks.
Finally I declare all the various fields I want to capture and write to the database.
What I want to do now is have a SUBMIT button that on click takes all the data in the form and writes a new record to the database I have already setup and have data connection to.
I know that the code has to be written using the .recordset functionality, but I haven't found any could tutorials on the subject that have turned on the light upstairs.