I am having problems getting the data I need. I keep getting "index was outside bounds array" I guess I am just plain confused. The text file looks like:
First = John Smith
Last = 550 Jackson St
Street = Nantucket
City = xxxxxxx
Misc = xxxxxx
[Code]...
I'm trying to use hyperlink fields in my gridview to pass certain values into another page using querystrings. On the next page I've put 'labels' that should be populated with data from the gridview, however nothing happens. This is my gridview code:
Code:
"<asp:GridView ID="GridViewGuitars" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSourceGuitars" DataKeyNames="ProductID" BorderColor="White">
<Columns>
[Code].....
I have a textbook loop using a TextFiledParser, which terminates when EndofData is trueTrouble is it's true prematurely. There is a knowledgebase article which decribes the issue perfectly but it only applies to V3.5. I'm using V4.0.I can't for the life of me see anything wrong with the data file, or the code. I reluctantly
MyReader.TextFieldType = FileIO.FieldType.Delimited
MyReader.SetDelimiters(",")
MyReader.HasFieldsEnclosedInQuotes = False
[code].....
It seems like in order to use "TextFieldParser " you need to include the path of the file to be parsed. Is it possible to use OpenFileDialog1 and then choose a file? I keep getting error messages.
Public Class Form1
Private Sub btnOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOpen.Click
[Code].....
I am trying to use the TextFieldParser in windows 7. I have tried running visual studio 2008 in elevated security mode but i still get file not found. I have tried it on my XP machine and it runs completely fine.am i doing something wrong or is it that windows 7 doesn't like to give access to the filesystem?
View 5 RepliesI created a program that has serval labels on a form and a listview object. It has a button that when clicked reads a textfile and loads up values in the listview object. I then can click and drag text from the listview box to any label on the form and then the program removes the value from the listview box. Now, my question is how can I instruct VB to save these values in the text property of the labels so that the next time the program is loaded the labels will contain the values loaded during the last run time session?
View 1 RepliesI'm currently busy coding a hangman game in VB.NET.As a wordlist, I have a textfile containing 1520 words, each one seperated by a new line. The best I could think of to get a random word is with a Randomize() function. Then getting the word from the line # which was randomly generated.
[Code]...
Is there any better way for me to extract the word from that random line? If not, what would be the delimiter I should use for this and how do I quickly change the breaklines into that new delimiter without resorting to Office?
Also, how can I use the textfieldparser to get the file from resources? When I tried using my.resources.filename instead of "filepath", it gave me an ArgumentException due to "invalid characters in the path".
Ok so I am taking jm advice and using TextField Parser instead of ADO.net to read my delimited files and then build my own datatablesFirst question is how would I query the data?I need to be able to have two tables, one with sold propertys and one with propertys still for sale.The table I created thus far has all the records, the problem and my second question is how do you allow for a null value ?If one of the records isnt Sold then it won't have a Selling Price therefore when I set my datacolumn to be of System.Integer type It is not accepted
HTML
Private Sub FileToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FileToolStripMenuItem.Click
[code].....
Well im currently developing an application for public use, I have a login screen in which the user enter's their registered credential's and the progressbar loads by increments of 3, now i placed 6 labels ontop of eachother and where the progressbar coding is i put:
If Progressbar.Value >= 1 Then
Label3.Show()
If Progressbar.Value >= 20 Then
Label3.Hide()
Label4.show()
And so on up until Label8 Show at 100%,
Now the problem is... As i have placed the labels ontop of eachother i need them hidden until they are called to show, i have tried adding a background worker to do this but have had no luck, all i see is the labels overlapping eachother when i run my application when i want them hidden untill Label3.Show() is called, and then to display them as they are called and hide them when another one is called to show...
With VB, but I've got the few basics down, file naming, adding objects, naming objetcs, etc. But the reason I'm on here is because I cannot complete even the first step. Our form is 640 X 480, and we need to have two labels, both have vertical scrolls. I know how to add and resize the labels to meet my needs, but I do not know how to create scrolling labels. Or are they text boxes? On our bubble chart (Do you know what that means?) it says lblInformation. We are going to have clickable radio buttons which will update the lblInformation with info about each of the radio buttons.
View 7 RepliesI am using the TextFieldParser to read a 3rd party .txt Tab Delimited File Sometimes the file contains duplicate column names and subsequently I cant create my DataTable.
How can I check for duplicates first and change the name of the duplicate fields so I can populate my Table?
Example:
I have two columns called ST and would like to Change of of them to ST1 or something similiar to populate my table
Dim safeFileName As String = IO.Path.GetFileName(Me.OpenFileDialog1.FileName)
Using myReader As New Microsoft.VisualBasic.FileIO.TextFieldParser(safeFileName)
myReader.SetDelimiters(vbTab)
[Code]....
The following is a text file of 4 lines delimited with (,) making 8 elements and 1text string making 9 eliments in all.In my Environmental dictionary Environment and Conservation, Devoid of life non-biological.The Oxford University Physical and Theoretical Chemistry Laboratory definition says free of biological organisims. Does this mean the water in a pond is not abiotic but pure water is?"The following from the MSDN help that works:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Using MyReader As New Microsoft.VisualBasic.FileIO.TextFieldParser("L:GlossaryListBox0
[code].....
I'm using the following code to read some values in from a tab delimited text file:
vb.net
Using Parser As FileIO.TextFieldParser = My.Computer.FileSystem.OpenTextFieldParser(LogFile, vbTab)
Parser.TextFieldType = FileIO.FieldType.Delimited
Dim comments(0) As String
[Code]...
As you can see I have set the HasFieldsEnclosedInQuotes property to true on the textfieldparser because I want to make sure I capture the data correctly if quotation marks are used. If I set the HasFieldsEnclosedInQuotes property to False then it all works (or at least it doesnt error anyway) but like I said, I need to have that set to true because otherwise if the line contained a tab character within the quote marks then my app would think this was two separate fields and process it incorrectly.
Is this class normally slow or maybe there is something in my process making it slow.I have to import 170,000 rows of data from a fixed length text file into a SQL table. It takes about 2 minutes in a DTS package on SQL server 2000. But we are migrating to a SQL 2008 server and since this code has several manual steps and does not manipulate the data I thought it would be easier to use the TextFieldParser object to handle reading in the data.
Here is the code:
CODE:
I have a VB2010 project where I need to read a tab delimited 50MB file using Microsoft.VisualBasic.FileIO.TextFieldParser. This technique works fine until the reader encounters a Unicode character upon which it inserts the little square thingy. The obvious choice is to change the encoding of the reader to Unicode from the default. This would probably work fine but for most files but this one is fairly large and I get the error TextFieldParser is unable to complete the read operation because maximum buffer size has been exceeded. By the way this file can be read completely without the Unicode option. Making the file smaller or breaking it up really isn't an option. Is is possible to increase the buffer size or is there another way to read this data that places the data in fields like the textparser and allows unicode characters?
View 9 RepliesI'm currently refactoring an old Visual Basic DLL (VB.Net), which stores all of its data in one module called Globaldefinitions as public fields. There are about 200 fields, referenced thousands of times all around the code:
Public Module Globaldefinitons
Public a As Short
...
Public zz10 As Double
[Code]...
I need to change the module into a class with non-shared fields. This means, each and every of these thousands of references needs to reference the instance of that class:
globalDefinitionsInstance.a = 5
How do I go about this efficiently?
Regular expressions operating on the source fall flat. Refactoring tools like Re-Sharper or CodeRush don't seem to offer this functionality. Visual Studio 2010 cannot do it automatically either.
I'm trying to make a program that allows the user to click on labels which have a number in it and then that value has to be stored into a different label.
For example the user click on label1 and the values goes into label12, then it click on label3 and the values goes to label13 and so on.
At the moment I can only code on the respective label underneath (1->12,2->13...) but it has to be in any order (5->12,7->13...)
Here a picture and below my code:
'defining the click order....
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click
[Code]...
Class Foo
ReadOnly name As String
Public Sub New(name As String, dependentUpon As Foo)
Me.name = name
[code]....
The output of New Bar() is:
Dependent created. Dependent upon nothing.
Independent created. Dependent upon nothing.
It seems fields are initialized in the same order as they appear in the source code, which (a) leads to an unexpected result, and (b) seems a little puzzling, given that one is normally not permitted to read from uninitialized variables in .NET, yet that seems to be working fine above.I would've expected VB.NET to be smart enough to initialize referenced fields first, and only then those that reference it; i.e. I'd have liked to see this output instead:
Independent created. Dependent upon nothing.
Dependent created. Dependent upon Independent.
how to get VB.NET to behave like that instead, without simply having to swap the declaration order of dependent and independent inside class Bar?
I'm trying to create a table in Word using data from a table in Access. There are four fields in the access table that I need. 3 fields are text which I can populate the Word without any issues. However the fourth field is a memo with >255 characters.I'm struggling to come up with the proper code to allow me to populate the Word field with the memo data that has more than 255 characters. The code I have so far is listed below. But when it hits the memo field, it crashes on the line I marked with **. I know it's not text, but I've tried many different field types, but nothing has worked so far.[code]...
View 1 RepliesMy intent is to have the code - on a button.click event - check the Username and Password fields and return an error depending on which is wrong. Or if both are wrong, return a different error message. I've set the username as parts and the password as parts (still learning how to use external authentication). [Code]
View 2 RepliesI use a textfieldparser to read a csv file in my app. I set the delimiter to a, Problem is, if there is a field that contains double quotes, the textfieldparser fails. So if I have Example",test. it fails. If i remove the " it works. That's quite odd. How can I fix this.
View 8 RepliesI have several sqldatasources for my gridview. All of the columns are autogenerated. However they all have some consistent fields and I'd like to make those fields template fields so I can modify the edit template for them such as adding a drop down menu. Is this possible?
View 1 RepliesI am using VB.NET's TextFieldParser (Microsoft.VisualBasic.FileIO.TextFieldParser) to read a delimited file. However, when I try to read in a field with consecutive newlines within the field, the consecutive newlines are turned into a single new line. I would like the consecutive newlines to be preserved, but am unsure how.Here's an example file that I am reading in with exactly one field. The quotes are part of the file's content and there are three newlines (including the two consecutive newlines following line 2):
"This is line 1
This is line 2
This is line 4, which follows two consecutive newlines."Here is the code that I am using to parse and read in the file:
Dim reader as New Microsoft.VisualBasic.FileIO.TextFieldParser(myFile, System.Text.Encoding.Default)
reader.TextFieldType = FileIO.FieldType.Delimited
reader.SetDelimiters(",")
[code].....
The end of the text document my application is reading is denoted by a character that I cant identify, copy or paste. I attached an image of it so you can see. I have no control over the formatting of the document so I can't change the character. During debugging it shows the same character as shown in the picture, but if I hit the little tack next to where the variable shows then it changes to "f". However, if I try to see if the variable equals "f" it returns false.
View 3 RepliesI am learning to use TextFieldParser to read a fixed width text data file. It works great. I copied code below. Question: How to stop at the end of each line because I need to add some code?
Using tf As New TextFieldParser(fileName)
tf.TextFieldType = FileIO.FieldType.FixedWidth
tf.SetFieldWidths(60, 30, 20) //three columns
[Code].....
I am trying to use Microsoft.VisualBasic.FileIO.TextFieldParser for parsing any format of tab delimited text file that user may have and show the data in web page in tabular fashion.I have sample tsv file with text qualifiers such as quotes saved in different encoding styles for different platforms such as pc, unix, mac saved using textpad. and I am trying to parse these using TextFieldParser. It works for all PC files but fails for mac.
View 2 Repliesexperience on how to create an engine using C# (VB.NET is okay too) that is generic enough to handle most cases of MS Word text fields I need to fill with data I'm getting from a database? In short, I'm about to embark on this little Office automation excursion and I'm hoping a little bit of feedback here.
View 2 RepliesI have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
how to execute this SQL Statement
Scenario:
Given Tables T_Data, T_AllDesc, T_System1, T_System2
Given Fields:
T_Data= f_id, f_Desc, f_CreationDate, f_CreationTime, f_System1, f_System2
[Code].....
I am trying to implement a BGW and want to report progress to a progress bar for my TextFieldParser program, sometimes if your opening very large files it takes a while and I would like the user to be able to see the progress and have some interaction so they know the program is still running I am a little hung up on what to in the reportprogress
I have:
worker.ReportProgress(0, myReader.ReadFields())
and its not doing anything, I didnt expect it too since ReadFields is an array
parser
Private Sub BackgroundWorker1_DoWork(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
Dim worker As System.ComponentModel.BackgroundWorker = DirectCast(sender, System.ComponentModel.BackgroundWorker)
[code]....