I have a CSV file with 35 fields. I have to read it into 35 variables. i know I can read the line, split it, write 35 assignment statemens. I am looking for an easier way (because I am lazy).
I'm looking for something like ReadCsvFile (A1, A2, A3, A4...A35) that will read a line, split it, and make all the assignments.
OK, I am trying to create a "payroll" program and I want to be able to have end users add information to a file and have the program read that file
View 3 RepliesI have been searching for days to get some code that will do this. I need to open a spreadsheet and read maybe 2 dozen cells into variables in a VB.Net program. Specifics are: MS Office 2003, Vis Basic of VB.Net 2008. Everything seems to revolve around the following lines which do not work for me. I am not sure if this is version differences as most ppl here do not name which version they are using. [code]Does this method not work in VB.NET 2008?
View 2 RepliesLast year (2010) I came across a FANTASTIC command that allowed me to take a string of variables with a common delimiter and break it all back out into separate variables (possibly an array) with one statement.
[Code]...
As long as the delimiter was a unique specifiable character, this one-statement command could break it out into elements. my memory and point me in the right direction.
I have code, shown below, that works all except for 1 thing: The variables being passed byRef get passed, but once modified in the else section of the "if me.invokerequired" code of RecordData, the variables are never updated in the calling function. To reiterate, the calling function does not receive the updated data that is in the variables custid and amt.When debugging, I see the data change in the else section of "if me.invokerequired", but once it returns from the callback the data is missing.[code]
View 15 RepliesI define some global variables of a class as follows:
Private Class MyClass
Private var1 as Decimal
Private list1 as List(Of string)[code].....
But I found that after this form is closed, all above variables, var1, list1, list2 still exist in memory. I thought they should be collected by gc since the form is already disposed as I confirmed.
Add: I have monitored half an hour after the form is closed. But these variables are not collected by gc. I have an automatic update procedure on the form which uses above variables.Since the above variables still hold values, the automatic update procedure is always called which causes exception. (One quick fix is to check if form.isDisposed in update procedure. But I do not think this is elegeant. Besides, these variables occupy memory.)
I have a class file, myClass.vb. Here is an example of the file:
Private _active As Integer
Private _categoryID As Integer
Property active() As Integer
[code]....
when I want to assign a value to the variables in the class file, should I assign them like what I have in line 24, and 25 or line 28 amd 29? how I assign the variables in terms of performance?
Passing variables from .bat file to vbscript. I have .bat file that launches test.vbs. I need to pass variable defined in the batch file inside the .vbs file.
the batch file contains the code
set /p var= please enter the value: cscript test.vbs "%var%"
Where as test .vbs has the following codes
Dim StrText
MsgBox StrText
In my requirement value assigned to variable 'var' in batch should assign to StrText variable in the test.vbs and then it should display in VB message box.
I deleting the files of certain age in a directory and also need to write a log file. So my question is how can we pass a variable from one method to another?
Example : Dotnet.Explorer
I have a text file that has a list of certain values and I need to read each one back to the correct variable.
View 2 RepliesWe have this current VBA program to help us with AutoCAD via the use of a template excel sheet.The setup we have created works well; however occasionally we have two drawings per folder, which often results in, two templates excel sheets of the same name, one overwriting the other. how I can set the active drawing name in a variable that our program uses to check for, then if not present that it creates a copy of out template and then saves it as the active drawings file name which was set as the variable
This would allow our program to locate the associated excel sheet by name then save it by the unique drawing name and prevent existing excel files being overwritten if in the same folder.
;===CODE STARTS HERE===
Option Explicit
Private Objexcel As Excel.Application
Private ObjWorkbook As Workbook
[code]....
After getting the file name I create a new filestream and load all the bytes from the FileStream into a byte array, now I need to get certain bytes and store them in fields like the second 4 bytes are the time the file was created. When storing these in the variables should I store them as bytes or as string/integers/etc.
Or have I done it completely wrong?
EDIT:Should I be doing this way instead of a filestream?
Dim data() as Byte = File.ReadAllBytes(path1)
I have searched the web for an answer to this but can not find one anywhere. I have a program that will be sending text to different text files based on a selection in some combo boxes, I was wondering if it is possible to select the file path based on the combo box variables eg
if the user selects hello and then 4 in the combo boxes then the text will be saved to
w = New IO.StreamWriter("c:projecthello4.txt")
or if they select hi and 5
w = New IO.StreamWriter("c:projecthi5.txt")
i have tried setting 2 variables called a and b and trying to run the following
w = New IO.StreamWriter("c:project{a}{b}.txt") but this does not work
I have 10 variables, how do I save it into a txt file with each variable a line?
View 9 RepliesDoes the memory used in declaring variables are reclaimed by the OS when these variables go out of scope?Does the memory used be released by setting thier value to nothing? if not, then how can I force the garbage collector to run or excecute at a certain/desired time..How about in Windows Forms..How can we make sure that the memory used in initializing and showing forms be released if those forms were closed?
View 13 RepliesQuestion 1: What is the difference between "Background Worker" and "Worker Pool" as indicated within the MSDN samples provided.
Question 2: I noticed while using, AddressOf _Function_, variables cannot be passed; what would be an efficient solution to this?
Question 3: While using multithreading is it required to invoke before setting variables, or only form properties?
Question 4: While using System.Net.Sockets is it safe/efficient to use Application.DoEvents while waiting for new data; or would be using a Do While loop be fine without DoEvents since the action would be multithreaded? Note: there can be up to 2000-3000 sockets in use at a time.
I'm new in .NET programming.I have a class Form1 that includes Button1_Click event.Button1_Click creates a multiple Text Boxies at run time)Here is the class:
Public Class Form1
Dim shiftDown As Integer
Dim counter As Integer
[code].....
Is there equivalent for getevn/setenv functions in VB.NET. I have looked at system.Environment.GetEnvironmentVariable but it gives the system environment variables like USERNAME, COMPUTERNAME etc. I need to get the variables that are stored in config.user file. Is there any way to do that in VB>NET.
View 2 RepliesI recently asked a question about reading a file with Streamreader to variables arrays, but I made it more complicated than need be. Here is the simple version of what I am trying to do:
dim MyNumber(1) as String
strMyFile = 100,200 (I already have this)This is the result that I am trying to make happen:
MyNumber(0)=100
MyNumber(1) =200
I would also like the result to be MyNumber(0), MyNumber(1) as double, but I could do that in a later step. This is almost embarrassing to ask, because it is probably basic stuff.
I am wanting to get information from a text file into different arrays.
My current text file has a new line for each driver but I would like it to look something like this
[code]...
I want to read a comma seperated file, there are 4 columns. I want to read each column into a different variable.
Here are the data
1.89,Dog,434,0.754
45.32,Cat,674,89.6
....
[Code]....
I have been tasked to create an application, for which the requirements may change over time.This application will be a data entry Windows application,of which multiple copies will be running.All data will be written to text (.CSV) files for validation before being uploaded to a remote mainframe system (iSeries).My application needs to store certain variable information in an external text (or XML) file; for example, the file path to shared resources (which may change over time),as well as the specific data fields required by the mainframe system.
My questionsare these: what is considered the best practice for accomplishing such a task, and how would I accomplish it?I am completely new to XML, so I don't even know where to begin, although I am sure that XML is the path to follow for what I am trying to accomplish.
I'm tasked with the job of creating a javascript version of a units conversion application written in vb6. I have the source code but I don't have vb 6. The source code uses a dat file to hold a conversion array (unit type, unit, xfactor, plusfactor). Getting the data out of this file would be good to me. I tried creating a little app in vb 2010 to write the data from that dat file to a txt file using essentially the same code as the source code. And that has been somewhat successful (took a while to figure out the fixed string business). Now I can pull the data out as an array. The math elements of this array look fine but the strings are somewhat read-able but too garbled to use. I can't seem to fix that by changing the character set/encoding.
View 3 RepliesIm trying to load a price of an item from a prices file (Items). The variable (ItemName) is taken from a listox populated from the file on another form. And (Item) is the structure which i saved the prices information for into (Items).
What im trying to do is take the string from the listbox and change the textbox (txtCurrentPrice) text into the price for the highlighted item, which is also the name of the (txtItem) textbox.
However i cant find a way to reference the Item.(ItemName) to get the correct price from within the file, as ItemName isnt a member of the Items structure Item instance.
ChangeItemForm
Private Sub ChangeItemForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]....
ItemName holds the name of one of the variables saved in the structure. So say if ItemName was holding "IridescentRoll" As its string I would be trying to find Item.IridescentRoll, which would show me the price of IridescentRoll which im trying to put into the textbox. and As Item.IridescentRoll = 3.35 it would display 3.35 in the textbox.
As you have probably guessed, the Item.ItemName doesnt work ('ItemName is not a member of...'
Is there any way to write this without having to create a new record for each item? As that would take a while, and im not sure i have the time x.X
I've got a few variables and a list of decimals i'm trying to store to a text files. If I run it, and file exists, it errors correctly returns to the form. If it's new, it creates it, but writes nothing to it.
Private Sub SaveExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveExit.Click
If File.Exists(Filename) Then
MsgBox("File Name Currently In Use") ' Check if file name in use
[code]....
When I use to do some Delphi programming you were able to define variable as a target for a comma delimited file and then under that give variable names for each field to fall into. I forget the syntax now but it looked something like this...
Using Getline as Record:
RecordId = Integer
RecordName = String
RecordAddress = String;
[Code]....
I'm looking to be able to save and load the content from multiple structured arrays and variables into/from an encrypted file, is there any reliable source of information or tutorial that I'd be able to use for this? I've never written a program in visual basic that writes to/reads from a file.
I'm using microsoft visual studio 2008.
I have a delimited text file, let's call it models.txt and it's delimited by a comma with carriage returns.
example:
21,Z920081
22,Z920082
59,Z930023
120,Z930027
I'm trying to input this into an array and then a combo box using:
dim item as integer
dim array() as string
dim ifile as integer
[CODE]............
What I want to do is to display the right part of the delimited text (Z920081, Z920082, etc) in the combo box. But when you select the item in the combo box, I want it to use the left part of the delimited text (21, 22, 59, 120, etc) as a variable for other use.
visual basic 2008
I am pretty good with visual basic and visual studio, but the one problem I have is saving... I am currently creating a game, and it has a lot of variables, I want o be able to save all those variables to a text file and then re-open it later. When it is open, i want the variables to have the original value from the text document.
To sum it up: I need variables to be saved in a text file, and then be able to open the text file back and have the variables have the proper values from the text file.
I have been searching around google, and I found ideas, but I have no idea how to use them. Like using XML or saving a table with " TextFile.WriteFromTable" "TextFile.ReadToTable" but I don't exactly get how to use those (the posts weren't too clear)
Im creating a game like CityVille where you create a city and such. The game allows you to name your city and such and because I dont understand how to use the settings thing to save stuff I want to use a text file. I want the textfile to look like this:
city_name: namehere
money: moneyhere
plots: plotshere
population: pophere
smallhouseowned: numberhere
etcetc
How do I make VB read the file and put the information in the right variables?