ok i have a comma delimited text file with two fileds. I am loading the first field which is strings into a checked list box based on a open file dialog prompt. now when the user clicks a button i want it to be able to increment the second field(which isintegers)of the corresponding string field index by one and save the file. i am very confused on how to even start this.
View 7 RepliesI am new to the VB Forums. I searched the forums for an answer, but could not find one that exactly fit my issue. I apologize if I missed it. What I am doing is I'm pulling strings of text from a backslash-delimited text file and throwing it into a (Of String, Array) dictionary. This info is then displayed, added to, removed from, through the use of the form. Changes to the entries (new, old, or otherwise) then need to be written back in the same delimited format to the text file.
[Code]...
Using Visual Basic 2008 express, I would like to access a database with 2 tables, one table (useraccounts) which has Users and Password and ID, and the other table which has information (linktable). Basically I would like to do a login form which reads from the table useraccounts and be able to create new users which will write into the database.
Another is that I have a form with a number of links which I would like to store in the table 'linktable' and it basically just gets the links from the table and straight to the form where it is used. I have tried using access or the .mdf files that visual basic has but I have been unable to find an answer for either.
I wouldn't mind using either access or the .mdf file for the database, I would just like it to work. Overall I am trying to get:
Login form which reads from database table 'useraccounts' and has a new user feature
Just a form that can read / write to the database once the save button is clicked.
I have a form that validates a users info, address, phone, etc. I want to have the form submit the data only if all of the fields are valid, but haven't had any luck. Right now the fields are able to validate but the form submits the data to the text file regardless of whether the fields are valid or invalid.
Here is my code
Imports System.Text.RegularExpressions
Imports System.IO
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
[Code] .....
How to create an if then statement to only submit the form when the data is valid. I was thinking I might have to set up a separate function but I'm not sure how to set it up really.
There is way to input comma delimited files:
Using MyReader As New Microsoft.VisualBasic.FileIO.TextFieldParser(currentfile)
MyReader.TextFieldType = FileIO.FieldType.Delimited
MyReader.SetDelimiters(",")
Is there an equivalent way to output a comma delimited file. The approach I used in earlier versions of Visual Basic does not work in .NET.
I have been using:
Printline(1, val1, val2, val3)
In .NET that is not comma delimiting
For now I am hardcoding ... & ", " & ... between variables.
Basically say I have a text file with the following contents:
"Tim", "USA", "1982"
"Jane", "Germany", "1980"
"Brad", "France", "1989"
Can I have a ListBox for each field, one listbox for Names, one for countries, one for years?
Basically say I have a text file with the following contents:
"Tim", "USA", "1982"
"Jane", "Germany", "1980"
"Brad", "France", "1989"
Is there a set function in vb.net that allows you to read a delimited file with text qualifiers? In the past I have used the split command but that does not allow you to take into account the text qualifiers.
View 1 RepliesMy customer requires text files to be written in the following format:
"adrian","sigamoney","01","1","B"
No matter what I do I get in file
adrian,sigamoney,01,1,B
I have tried split, replace, adding extra hyphens to string.
I use to code looooong (98ish)ago in Visual Basic 5 but I haven't touched it since 2000. Well now im back and I must say i quite rusty!!Here is what I need help with. I've successfully created a save command for a Comma-Delimited txt file. My problems come from when I try to load the file, I can load the first line just fine. But multiple lines are going to be an issue. I don't quite understand how to tell the program to go through each line.[code]
View 1 Replieshow to best go about this project. I have just been given the task of creating a program that will primarily be used to import and sum a excel or text file that is tab delimited. As a quick example the file would be in the following format:[URL]The problem is that I would need to store this information locally (unless you know better) because I need to be able to append information to this from a second (or third, fourth, etc...) file and re-sum it, lets say that this is the second excel file that I needed to sum:
[URL]
I would have to append the week5 and week6 columns and add the Neapolitan row to my summation. This program will then format the sums into a list of the different flavors and the sums of all products sold during the total weeks and output to a text file.I have informed my employer that it would be easiest to do this with a VB script in excel, however, they are adamant that they want this done in VB.NET with a GUI.
I'm busy with an applicaton which reads space delimited log files ranging from 5mb to 1gb+ in size, then stores this information to a MySQL database for later use when printing reports based upon the information contained in the files. The methods I've tried / found work but are very slow.
or is there a better way to handle very large text files?
I've tried using textfieldparser as follows:
Using parser As New TextFieldParser("C:logfiles estfile.txt")
parser.TextFieldType = FieldType.Delimited
parser.CommentTokens = New String() {"#"}
[Code].....
I need to dump a bunch of delimited data to Excel. In VB6 days, I would save the data to a text file, then use ExcelApp.ActiveSheet.QueryTables.Add (blah blah blah...) to import the data to Excel (I got this code from recording a macro while manually importing a text file).In VB.NET (2005), QueryTables does not appear to be an option for ActiveSheet.I could take the long path and manually parse thru the data writing to individual cells - however if I could just import it, it would be much faster.Part of the issue is not being able to record a macro in Excel in .NET format.So my primary question is, how do I import a delimited text file in to Excel without having to manually parse the data into individual cells.Secondary question is any tips for not being able to have ready made examples (in VB .NET format) by recording a macro.
View 3 RepliesIn one of my school assignments I am trying to count fields (that are strings) in a database and then publish them to the screen, however I can't seem to figure out how to count them.I've been trying to do something like this but I am having trouble with the bold part. I think the datatypes are the issue but if not this then what? What is a better way to try and do this?
Private Sub btnCalc_Click(sender As System.Object, e As System.EventArgs) Handles btnCalc.Click
Dim numRep As Integer
Dim numDem As Integer
[code]....
Ok I know this question has been asked to death but I still have not seen a good answer. I have created an application in VS2010 using VB.NET. In my application I have an error log that is an XML file located in the Public gstLocalErrorLogLocation As String = Application.StartupPath & "ErrorLog"that gets written to in the event of an error so I can trouble shoot application easier. My application also downloads files from our FTP site and puts the files in Public gstLocalDownloadLocation As String = Application.StartupPath & "download"So I have files that get read and written to as well and created and deleted all in the Application.StartupPath which is either "c:Program Files(Application Directory)(Some Directory)(Some File)" or "c:Program Files (x86)(Application Directory)(Some Directory)(Some File)" depending on 32bit or 64bit Windows 7.
After creating the setup I install it on my test machine that have both Windows 7 32bit and 64bit.Everything in the application works great till I have to write to, delete or creat a file in those directories above. I know it is an access issue and the UAC. This will get installed on numerous systems so the options I have seen to change file or folder permission on the computers manually is not an option.What has to happen is after I install the application it just works like when you install it on XP. Some post have suggested that you us a user with administrator privilages or group which is all fine and dandy but the user I have used to test the application has all of that.
So what I am asking is how do you create an application with VS2010 in VB.NET that after creating a setup package and installing on Windows 7 will just work with out "Access to the path c:Program Files(Application Directory)(Some Directory)(Some File) is denied." If I have to install this on 100 Windows 7 computers it has to be a concreate no manually doing anything just install and work like when we installed on XP.
i want to take a comma delimited text file and then select all unique records based on one of the fields in the text file. should i read the text file into a data table or just use a data reader?
View 7 RepliesI have search system that works like charm: 1> Searches specific folder for text files which contain specific word 2> Puts those text file names and/or paths to listbox However i want it to put (instead of InputStr) the specific line where word is found in text file to listbox.
[Code]...
i have line like this
46N93 P594 40898, 35899 39MIL;
PHY2_P2_CONFIG0 P2767 34205, 33537 39MIL;
18N879 P141 120461, 49324 39MIL;
PMC3_270_ETH1_D0+ P3021 8061, 44624 50MIL;
[code]....
but before that i must check the MIL value. If it is 39MIL i should write T5 first followed by the value from all 39MIL than if have 50MIL it should write T10 followed by all the value from 50MIL my output file will be like this
T5
40898 35899
34205 33537
120461 49324
[code]....
I try this code to split
Dim tfLines() As String = System.IO.File.ReadAllLines("C:file.txt")
Dim sf As New System.IO.StreamWriter(drill, True)
For I As Integer = 0 To tfLines.Length - 1
[code]....
But i can not get the exect value that i want?
i have a xml file thats looks like this:
<Item xmlns="Element1">
<SubItem>item1</subitem>
<SubItem>item2</subitem>
<SubItem>item3</subitem>
<SubItem>item4</subitem>
</Item>
[Code]...
And then i want to add 1 SubItem for every item in my listbox to one specific element without touching the other code. I already have the code for saving listview items to xml.
For example lets say I want only admins to be able to see and edit CustomerID in details view, moderators can see this value but it is not editable, and regular users cannot even see it.
View 2 RepliesGND P3559 9812, 7993 p9910.26;
GND P3559 9812, 7993 p9910.26;
46N93 P594 40898, 35899 39MIL;
PHY2_P2_CONFIG0 P2767 34205, 33537 39MIL;
18N879 P141 120461, 49324 39MIL;
PMC3_270_ETH1_D0+ P3021 8061, 44624 39MIL;
I have lines like above in my text file. I have write all this value in another text file by adding the title. In my original file's line I must check whether the line contain any MIL value if not, I must write first T1 the below T1 I must write all the line which not contain MIL value until I reach a line which Contain MIL value. If the line contain 39MIL the I must write first T5 then followed by all the line which contain 39MIL until it reach the line which contain another MIL value. Let say 50MIL. the I must write T7 then followed by all the line which contain 50MIL. I sort my original file already. so the original file will start from the line which dont have MIL to 39MIL,50MIL,75MIL and 100MIL.
My output file will look like this:
T1
GND P3559 9812, 7993 p9910.26;
TERM_RX3_2- P3347 41621, 2965 j22.49 50MIL;
58N895 P169 62611, 96124 50MIL;
ITP_TMS P200 67411, 49624 50MIL;
63N674 P175 20911, 34124 50MIL; .....
GND P3559 9812, 7993 p9910.26;
GND P3559 9812, 7993 p9910.26;
46N93 P594 40898, 35899 39MIL;
PHY2_P2_CONFIG0 P2767 34205, 33537 39MIL;
[Code]...
If you know the cell number that you need to write to in excel, say E3 what would you use for the VB2005 code? I can't seem to find an example on this!
View 7 RepliesSo im trying to get evything that has ends with .iso into a list box, tryed a couple of things but not getting anywhere as yeat
Here is code.
Dim Locate As String = Application.StartupPath & "\Games\"
ListBox1.Items.Add(Locate.EndsWith("*.iso"))
The Locate String is there because thats the location where the iso files are but the application is in the root of the drive. The ListBox1 command is fairly easy to understand
I am making a vb.net app and I need to know how to overight onto a specific line in a text file. For example:[code]Now, I want to completely overight the "B" to an "A" and the line I need to write on is "2" also, my application will produce dynamic text files as well so I wont always be able to know what line exactly to overight. So my question is, how do I write to a line when I know what line it is and how do I search for a specific line and overight that.
View 3 RepliesI'm trying to create a program that stores a users stats for their character (for something like an RPG). I know how to write more than one line in a text file, but I want to learn how to read and write text on specific lines of my file. I know that you can just read each new line individually in order using a StreamReader, such as
username.text = readLine.ReadLine()
userage.text = readline.ReadLine()
[Code]....
This is good for just displaying the stats and changing them from a constant interface, but I'm afraid that eventually I'll need to read/write specific lines, like reading the fourth line which might specify magic level, or writing a new money amount.
What I am trying to do is I have a .dat file that I cannot read but can at the same time. What I mean is I know how to decipher it by hand (alas takes minutes per 6 parts and there are thousands.) I am trying to make an application that can read this and allow me to edit it from my computer. I can open this with a hex program such as hex editor neo. I am currently trying to get it so I can read the file and have it place corresponding parts in to text boxes that I can alter to suit my needs.
I am new to visual basic and know a tiny bit about C++ if you think I would be better off trying in C# I can try that as well I do know some since learning c++. There are 41 parts to each item listed in the file and each one would need to go in its own text box. In hex there are 348 blocks that need to be arranged in corresponding order. Also the beginning of the file has 6 block followed by a code for each item. I need to find a way to put all the correct code in the correct text box and have it make sense.
I'm trying to write to a specific cell located in the datatable, which is from dataset. I know that it would be datagridview1.rows(xx).columns(xx).value=(""). But how to do it in a datatable
Public Class Form1
Dim ds As New DataSet1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim TestValue As String = "test value"
[Code] .....
The following code above does write to column 3 row 1, but if you say .rows(1), i get "there is no row at position 1". So, in summary if I have 7 columns, and I created a second row I want to write to column 3 and the 2nd row.
I am writing a program to login and read information off of specific web pages.I have gotten serveral working already, but I'm having a problem with this one.
<input name="DL_AUTH_USERNAME" type="text" size=10 style="font-size:9px;font-family:arial">Password:<input name="DL_AUTH_PASSWORD" type="password" style="font-size:9px;font-family:arial"><input type="hidden" name="next" value="/"></span><input type="submit" value="Go" class="button">
For some reason I can get it to load username and password but I cannot figure how to get it to click the go button.
I'm developing a program that handles money, and there is a pre-made excel spreadsheet that I am to be transfering data into specific cells. How can I go about telling my program to write specifc data into specific cell numer in excel? Also, how can I get my program to write into specific areas of a MS Word Template (my program will generate letter with the same template just different names/addresses/valus)?
View 1 Replies