Dynamic Data Storage Without Seperate Database Program?
Jun 5, 2010
I'm relatively new to the vb.net framework and object oriented programming. After perusing the threads for a few hours I can't quite find an answer so I'm posting this thread. I'm not necessarily looking for code examples. I just want to know if it's possible and where to look next. Basically I'm trying to build a starter application that will help me learn programming. One of the main things I want to do is to be able to dynamically (at run time) create a set of information (data) that can be manipulated via a set of static (and/or dynamic) functions/calculations. The reason I need it to be dynamic is because even though this program is really just for my own fun and perusal on my own machine (and I want it to be able to run without any outside connections (i.e. databases or servers) the data itself is going to be location (i.e.State of residence or even city) specific. Essentially most of the data will be numerical and can be of the integer type. But I'd like to be able to adjust and create new data sets if desired. From everything I've read and researched I haven't found a way to do this (at least now without an excessive amount of coding that is above my expertise). So I want to know if there is a way to do this that is relatively simple.
View 2 Replies
ADVERTISEMENT
Jan 26, 2012
I'm a junior VB programmer and looking for some advice on this subject. I'm trying to create a chunk of code that will create dynamic storage for variables for use later by dynamic custom controls.
For example:
An INI file might have an entry in it that looks something this:
....
[var1] <-- this becomes the Storage name
description=My Variable
type=System.Int32 <-- this could be any valid VB type
last_val=456 <-- Other code would save the last value
....
And I want to access the data using a standard "property set" like so after it's created:
var1_reference.value = 55
I've tried using a generic class which works ok as long as I declare the variables at design time from within the design environment. But when I try to create them from the INI file it gets messy.
Here's the simple generic class i've constructed to test this:
Public Class GenericVar(Of T)
'
' Generic Symbol Class for data storage
'
Private VarName As String
Private VarType As Type
[Code] .....
Also, as each object is created (and they could be different types) I store a reference in an array to make it easier to keep track of, but I'm having a hard time getting access to the objects and their properties, and certainly cant seem to assign an event handler to it once its in an arraylist because the design time code doesn't know what "Type" it is in the arraylist of objects.
View 2 Replies
Dec 2, 2011
Where should I store my programs user data so no one will have trouble accessing it?
View 2 Replies
Mar 4, 2011
Whether using XML database for data storage is safe enough? because I wanted to branch using an XML database and then she sends the data to the center. and then the data is in process at the center and then incorporated into the database server
View 4 Replies
Jan 27, 2009
trying to write a dynamic sql query that fetches data from oracle 10g database. My Where criteria is giving me real problems but i guess it has to do with the oracle data format. The data column is a TIMESTAMP data type storing values like 25-JAN-09 07.06.01.000000000 AM. Am trying to get rows having the columns matching a specific date( ignoring the time values), my where looks like this
WHERE to_date(COMPLY_RUN_DASHBOARD_DATE,'DD-MON-RR')='" & Now.Date & "'"i get the following error :CheckError ORA-01830: date format picture ends before converting entire input string
View 1 Replies
Oct 7, 2011
I'm making an installer that needs to have information stored inside the exe itself.I cannot use my.settings because it is stored outside the application and if it is changed and the exe is moved to another computer it will reset to default.
And I cannot use resources since I cannot add/edit resources after the application is build.
Is there any way I can store and change info even if the application is moved to another location?
View 1 Replies
Jan 14, 2011
I have for example this text:
User:text Something xxx
And I want to program seperate only word "text"
So, word after colon and before first space. I'm interested in code.
View 4 Replies
Oct 10, 2009
I am planning to write a recipe storage program for personal use. I know what I want to do, but I am not perfectly clear on the most efficient way to do it. I am using SQL server 2005 and I am comfortable writing stored procedures. This is one of my first vb.net projects and I am still getting comfortable with ADO.net.What I want to do is create a form that can handle an list of ingredients of an unknown number.
The form will also accept a cooking procedure of an unknown number of steps. Each step will be written by the user into Rich Text boxes (vb 6 term?)I am planning to use combo boxes to select ingredients from a list or add new ingredients as needed. I also want to eliminate duplicates in the ingredients table of the sql 2005 db. I am looking for the most efficient method to save all the parts of a recipe to the database. saving a recipe will require dozens of database hits and therefore be unacceptably slow.
View 1 Replies
Feb 3, 2010
I am new in this forum, also new in VB.Net I need to create a public class for insert and delete data to database Public Class My_DBFunctions
[Code]...
View 1 Replies
Oct 19, 2009
I have and application written that works great on XP. It is VB.Net 2008, using .net 3.5. I install and Access database to the program file directory. In Vista, I get an error that is permissions related as even admins don't have default write permissions to the Program Files directory and access creates a .ldb file when in use. To solve this, I have had the users give themselves permission to the folder.
Is that the best solution? If not, where should data be stored in Vista and in Windows 7? Also, I have an update feature of my software that will download updates to the program files folder. Is this out, too?
View 20 Replies
Jun 10, 2009
say you have a database that you want to store 100 different recipes in. Out of that 100 recipes 20 have 5 ingredients, 30 have 7 ingredients, 30 have 4 ingredients and 20 have 6 ingredients. So what's the best practice for storing an unknown number of items in a database?
Currently what I am doing in these situations is storing them in a single field in a database separated by a comma. Then when I have to retrieve them I split them by the comma into an array. This doesn't seem right to me but I haven't noticed an impact on speed or efficiency, so what would be the best practice to handle this situation?
View 2 Replies
Mar 22, 2009
I need a simple method for a user to enter as many rows of data as they wish (probably won't exceed 50 in most cases and that's pushing it) and then store that data for retrieving the next time they want to reuse that list. I will also need to read the rows in for manipulating text in a file with those entries.
Would the best method to be to use the DataSet in VB Express 2008 and then use the DataGridView for allowing the display and entry of the data?
View 1 Replies
May 12, 2008
I am quite green to VB .NET and it start occuring to me that I am doing things probably in a very ineffective way.Anyway here is the problem I have datasets, consisting of integers there is set 1 which is of format ID, ID2 - ID here is unique but different ID can refer to same ID2. Before I start reading in the data I have unknown number of these entries (ID and ID2 can be at least as high as 99999999)
Then I have a second data set of format ID2 here is the same as in the set 1 and it can contain several PID entries (all integers). In this set the ID2 is unique and again for one ID2 there can be unknown amount of these PIDs, same PID can occur more than once.
[Code]...
View 17 Replies
Apr 20, 2010
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
View 4 Replies
Mar 3, 2012
I'm just getting started with Visual Studio (2005), and my aim is to write a fairly simple application in Visual Basic that will need to store some data to disk.What I really want is to be able to send the application to the end users (xp, vista, win7) and have them just be able to use it without having down download all kinds of extras. For example I'm guessing that if I use an SQL database in my application they will need to download SQl server express or some other sql downloadable?
If so is there a similar downloadable for MS Access?I'm just in the 'seeing how things work' stage at the moment and I don't want to waste time going down the SQL track just to find it won't actually work unless my users all download SQL to their machines (which they won't want to do).
View 4 Replies
Jun 2, 2009
Looking for an idea of where the best place to keep files for a program. I use them frequently and they interact with the program directly. I want to place them in a place where they won't be easy to find if someone is just cruising thru the directories. Any ideas?
View 7 Replies
Mar 29, 2010
My database is going to contain personal data. (such as contact details, names, password, etc...) This is what I need:
1) I need to encrypt the database
2) However, i will also need to be able to use it in my vb.net program.
To expand on my second point, i will need to be able to display the data (non-encrypted, obviously), and i will need to be able to compare user inputted data to the database data (like, i will be using datasets, so, IF txtUsername.text = ds.tables(0) ...)
[Code]...
View 12 Replies
Aug 15, 2011
I am new to vb.net i need to know how to display a database data on listbox
View 1 Replies
Dec 27, 2011
I used the following code to insert data from my VB.NET into the MySQL database.[code]..
View 2 Replies
Jun 20, 2012
I am trying to make a simple program to put data from a database into a javascript array and then display one result in a textbox.[code]...
View 1 Replies
Mar 29, 2012
This is the code for displaying data from database to gridview....If i am doing any changes in GridView and it has to update in database.[code]...
View 1 Replies
May 7, 2012
How can you add data in a window form to a sql database in visual studio 2005?[code]...
View 1 Replies
Oct 9, 2011
I need some clarification. I'm planning to make a Scheduler program where it will fetch data from a MS Access Database, and I also want it to upload the data to a web server (MySQL Database) in JSON Format.
In the first process which is the fetching, I'll use System.Data.Ole.db namespace. This namespace mostly worked in MS Access. In the 2nd process which is the uploading, I am planning to use FTP protocol and should be JSON Format.
I was just confused with the second step, is FTP protocol applicable for this process?
I will make an Android apps to view all the data that will be saved on the web server.
View 2 Replies
Mar 10, 2009
Hi.
Im using this little function to search for text within some downloaded HTML source:
Public Function GetStringBetween(ByVal InputText As String, _
ByVal starttext As String, _
ByVal endtext As String)
Dim lnTextStart As Long
Dim lnTextEnd As Long
lnTextStart = InStr(StartPosition, InputText, starttext, vbTextCompare) + Len(starttext)
lnTextEnd = InStr(lnTextStart, InputText, endtext, vbTextCompare)
If lnTextStart >= (StartPosition + Len(starttext)) And lnTextEnd > lnTextStart Then
GetStringBetween = Mid$(InputText, lnTextStart, lnTextEnd - lnTextStart)
Else
GetStringBetween = "ERROR"
End If
End Function
It works great, but i need to be able to search for something that spans over 2 lines. E.g.
Sam works in a shop from the hours
of 09:00 to 15:00
I want to search for the words "hours of" - but because they are on seperate lines, it cannot find it.
I have tried "hours" & Environment.NewLine & "of" - and other variants of envirmonment.newline (knowing they all return the same value, but, hey, you gotta try) but to no avail. Surely there must be some sort of syntax to ge around this?
Any ideas?
View 5 Replies
Jun 11, 2011
Greetings,
My app saves a bunch of stuff to an XML file. This is my line of code-
Using writer As XmlWriter = XmlWriter.Create("C:vdx2kMWSREEXTReportsInboxTK" & frmCitation.txtCiteNumber.Text & "Traff.xml", settings)
So that saves it at that specific location.
I need to duplicate the XML and have it also save in another location. I've been at this for days, Googling, searching, trying different things and now I need to turn here for help.
Any ideas?
View 2 Replies
Mar 6, 2010
i wish to run a program with 2 forms form 1 will have 2 radio buttons and a textbox and form 2 will have 2 textboxs i wish to use the radio buttons to select wich information is bieing displayed from either form2 textbox1 or textbox2 using the radio buttons on form1 then display the information in textbox1 of form1.
View 4 Replies
Aug 4, 2011
How do i go about making variables on a second form have the same value as in the first form while still being able to make the variable on the first any given word or phrase and it appear the same on the second form?
View 2 Replies
Jun 16, 2010
I'm trying to open a connection and create an SQL statement with two different tables in different Access DBs. Is this possible? I'd like to join the tables in a query.
Is there a great advantage in splitting somewhat large Access databases? Or is it best to just create a large access database with many tables?
View 3 Replies
Jun 9, 2012
My code is the following[code]....
I don't have any errors on the password orr the database!!!I only have errors on the "sqlquary"
View 2 Replies
Nov 27, 2009
I have a small database program that gets data from csv file, I created a function that formats the font color of textboxes based on dates and values.
CODE:
I place this in text changed event and I have a problem implementing it, because the date conversion will not take place until the data is loaded. The second part works but not the first(Date) part.
I can create a button and use its click event to format the text boxes just fine, however i wanted the text boxes to be formatted on the fly . The problem is no matter where i call the function the date conversion wont work.
View 5 Replies
