Using Databases To Store Data?
Apr 30, 2011
Currently I have a list of items that are based off of a structure of information. I have been putting off the saving function of my program until near the end to make sure that I have all the elements before I start worry about what needed to be saved. I am not asking for code, more for direction. Is it possible that I can load and save data directly to a database rather than have to hold it all in memory as a list? I have never worked with databases in vb.net, and wonder if there are places that would help with this under the requirements I need.
My program saves recipes into a structured list. All the listboxes and forms use the list to populate the correct data on them. I know I could just save all the data each time the program ends into an XML file, and load it each time the program opens.... but is that the best way? Can it be done with a database without having to constantly save or load a file?
View 8 Replies
ADVERTISEMENT
Jun 6, 2011
I'm developing a project for gathering customer feedback using a Samsung Q1 Ultra, a cheap touchscreen PC. The project consists of two parts: a PC based application that builds the survey and stores the info on an SQL Server, and a survey viewer on the Samsung device which downloads survey data from the SQL Server and stores it on a SQL Server Compact 3.5 database.
My question is, how best can I transfer survey data from the SQL Server to the handheld device's database? Writing a tonne of code to copy data from one database to another seems overcomplicated - is there a handy function or somesuch that I can use to copy data from identical tables on these two separate databases?
View 2 Replies
Feb 5, 2009
I collect two sets of data from two different databases, This data is now in two collections. I then join/append the one collection to the other and then put it in to a list view.I really would like to order this list view by the first column without the click event.To make this even harder the First column contains Data that is DateTime and i have found that it orders the items by the day number and not the months or years or time.I have found one way but it then cause's me further agony when doing some checks upon the data within the listview later in my code. This answer is to rearrange the format to "yyyy-MM-dd HH:mm:SS" then using the listview.sorting = sortorder.
View 7 Replies
May 22, 2009
Does anyone know how to, or if it is even possible, to add data from two different databases into one datagridview? For instance, the following is my code for one source of data, pulling from Access.
[Code]...
PartNumber from the first dataset and ItemNumber from the second are supposed to be alike. What I need in my datagridview is all the info from the first dataset and then for each row I need the description from the second dataset, based on the PartNumber that is listed for that row.
View 26 Replies
Apr 20, 2009
I need to get data from 2 databases namely cable and History. The results obtained from it will be display in a datagridview. MyCommand is a sql statement i wrote. However,i have errors in it. The codes are as followed.
Dim dbset As New DataSet
Dim data As New OleDbDataAdapter
data = New OleDbDataAdapter(MyCommand)
[code]....
View 5 Replies
Sep 21, 2011
I'm doing a little project on the side and was wondering if it was possible to enter data from text boxes on a vb form into two different tables in the same database? [code]
View 3 Replies
Oct 27, 2011
I have used two database (1) party (2)partydup.[code]In both tables i have common field ("code"). I tried to retrieve the value of "description" field from partydup table when the "code" field in both the tables are same. I run the below coding but it is showing the error as "No data exists for the row/column". But i have a record which contains the code field value as 123 in both the tables. Still it is showing the error. Please let me know what is the mistake i have done.[code]
View 8 Replies
Jan 24, 2012
I am rewriting a program I originally did in MS Access. In this program I pull a table from the company's AS400 iSystems, it is filtered by data that I have in an Access Table. In Access, I first link both tables to the source and then just create a Query as if both tables were local. Now that I am using .Net, the second table is in SQL Server 2008.
SELECT LPROD
FROM ITEMS
WHERE EXISTS(
[code].....
View 1 Replies
Nov 12, 2009
I am in the process in developing a new version of my software. I have changed my design of my database slightly (added a few new tables and new fields to existing tables). The issue is that my users have user data in the old Db that I would like to transfer to the new Db. Both Db's are access 2003. Because my software is distributed over a wide geographical are it would not be possible to do this manually
I have appended data between two different tables in a single Db, but not between two separate Db's.
View 4 Replies
Oct 25, 2010
I have an interesting project.I've been tasked to create utility in VB.Net. So far from what I can see, I will need two tables produced from data in other databases. The mockup was done in Access which has a unique way of treating all tables as local tables that can interact with one another without any serious side effects. Simply put, I can add three tables from three databases and create a relationship and query against them without any problems.I'm not allowed to write or create items on the Server, so I need to do everything within VB.NET. I've created a local MDF file that will be included in the project installation, but as I'm new to .Net. I'm not sure if this is the best practice.I was excited at the prospect that I might be able to avoid having an attached data source when I realized I could create a DataTable and call data from it. When the application shuts down, the table would disappear and the footprint would be virtually 0. But now rather than just selecting data from that table I need to now delete and insert data to the Datatable object based on AdHoc selections on the form.
View 8 Replies
Sep 22, 2010
I want to store Usernames/Passwords in a Database/Data Connection...eg. A login.
View 4 Replies
Aug 4, 2006
I would like to import the excel in to the sql server using vb.net. how can i do it? Another question is how can i execute the DTS using vb.net
View 6 Replies
Jun 9, 2011
I have started making applications that retrieve data from sql databases.
I write the database with Sql management studio then apply that database to my applicaton.
My question is, how can I make my applications more secure against hackers. Some applications store user names and passwords and personal information / finantial information and so on.
View 1 Replies
Sep 29, 2010
I developed a program using Vb.Net that is data based enabled, it has a field for serial number etc. its working fine but the serial number failed to update when a record is deleted, its always keeps tracks of its formal numbering, even when the program is restarted, unless reinstalled.How do i also backup the data stored in such program.
View 6 Replies
Feb 27, 2012
I have two MS Access database; Mydb1 and Mydb2. I would like to do the following:
1. Copy all records in table (MyTable1) from Mydb1 to Mydb2. MyTable1 also exists in Mydb2
2. Move all records in table (MyTable2) from Mydb1 to Mydb2. MyTable2 also exists in Mydb2 which needs to be flushed.
View 5 Replies
Mar 22, 2012
I am coding a program that will allow the user to input 5 payrolls for Store 1, Store 2, and Store 3. The total of the 5 payrolls are then added together and shown in the respective Store's labels. A total label is also there to add up all the totals into one number. The numbers in the label must be in currency form. My problem is the numbers don't add correctly when I hit calculate. The first two numbers add together, but then after that the number just seems to subtract a random amount.
So far I have this --
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.Close()
End Sub
[CODE[...
View 14 Replies
Aug 11, 2007
Ok, most of my Visual Basic experience I admit was with VB 3 and VB 5. I'm just starting with VB 2005 Express, and get this error when trying to connect to a new database.
I'm using Windows Vista and have the latest Microsoft JET version, so I have no idea why I'm getting that error.
View 3 Replies
Sep 11, 2009
I am new to VB.net. I want to read and input file and store that data to an SQL Server database. Do you have an sample code that do such?
View 1 Replies
Mar 2, 2012
I have a modbus TCP device that I have managed to connected to through my VB source code.
I want to poll (continueously read) data from certain registers of the device, and store the polled data in a file (text,csv, excel).
View 1 Replies
Feb 14, 2011
I have an application that uses Dataset.WriteXML to create a small backup before data is syncronized to a data store (less than a meg).This application has worked well for 5 years now, and all of a sudden with the installation of XML 6.0 SP2 the XML document is not working correctly.I have multiple tables within a Dataset (Company, Contact, Notes, etc...)When WriteXML is called, the first table should be Company, however, the first table is being named Contact with the Company Data in it. The Notes table is being called Contact and so forth. In other words it's not giving the correct names to the tables in the XML File.This appears to be a bug, which is causing great distress on all the companies who have been using this program.
View 3 Replies
Dec 12, 2011
i just want to know how to get a template and store it in a data base without using data set
View 1 Replies
Jul 31, 2011
I hope this is the correct place to obtain a little bit of advice for a program I am looking to produce in visual basic 2010.
I currently work as a design engineer designing press tools and a lot of our designs are similer just maybe a feature, length, diameter change etc. So the design principles are the same for each product.
What I am aiming to do is program the 3D design package so that 80% of the tool design can be done using the program etc.
Now the enquiry I have is where would the best place to hold the standard data be?
For instance each press has a maximum blank diameter, shutt height, bores diameters in the bed and likewise each product type has design features with the same calculations such as length, pierce etc.
I have done a bit of reading and I have found that data can be stored into text files, xml files and databases etc or hard coded into the program.
I am looking to allow new presses to be added so the user would need to add new shutt heuights, blank size etc but the tooling would have to be unqiue dependent on the typs of stage. So I am wondering to store this information would a database be the best option even though the data will not be continually updated more a place for it to be retrived from excpet under failry rare circumstances.
View 3 Replies
Jul 24, 2009
I was thinking about using an access database to store the data but I would like to know if there is a better way of storing data?
View 4 Replies
Dec 19, 2009
I'm writing an app in vb.net and was wondering wath the best way to store/retrieve data was?
View 5 Replies
Mar 31, 2011
I've just finished an application which does everything I want within the Visual Studio environment now I need a way to store the data the user creates but I've never had to do it before and am a bit lost. I've spent days trying to use XML to do this but to no avail mainly cos my classes use ArrayLists as properties and it gets a bit beyond me. I've been told that ArrayLists were not the best choice for this and would be prepared to change my design if need be if I thought the end to this problem was in sight.
View 11 Replies
Apr 21, 2011
I am reading data from wordpad one by one which records the sale of grocery item by barcode. I want to store it in memory so that after reading the whole file I can calculate the total number of the same items sold by comparing the bar code.
View 2 Replies
May 21, 2010
I'm making a program that uses XML to store data and I'm having problems retrieving the data. Here's an example of how I'm storing data:
<?xml version="1.0" encoding="utf-8"?>
<main>
<category>
[Code].....
View 4 Replies
Aug 5, 2009
I'm having problem displaying and storing data from RS232 to access 2007. I have a PIC demo board that sends SMS via AT commands. I want to grab useful information like phone numbers and status message and store/display to access/richtextbox respectively. Right now every line of AT commands are display. And does not store to access. How do i search for the string with numbers like phone numbers?
[Code]...
View 1 Replies
May 31, 2011
I'm creating a program that outputs Quotations (and other information relating to these 1. What is the BEST way to read/write from a database (I only really know how to use Access but if XML or SQL would be better, I'm willing to learn). The database needs to be stored and accessed from the same state every time that the program opens. I've tried multiple different ways, both through DataAdapters (in code) to doing it through connecting the database through the Visual Studio GUI. Neither have seemed to work. Other people have told me that using DataAdapters and such aren't the best way, but no one has been able to tell me what this 'best way' is. Also, I need to somehow be able to link pictures in the database - apparently it's not easy to do in SQL?[code]...
View 5 Replies
Apr 18, 2009
i want to store data for Pilots ( a program i am working on ), i want to store the Callsign (ie UKV1918) and there Lat and Lon (latitude and longtitude)I need to be able to update the pilots lat and lon, and remove the pilot when they disconnect.
View 4 Replies