I have a xml file that I know what line number the value is on. Right now I'm using a loop through, look for line number 5, when you find it do this. But it's slow. I was wondering if there was a way to say "take value from line 5", or something like that. can I query a xml file by line number?
View 7 RepliesHow do i load a specific or a couple of line(not full file) to a RichTextBox by its line no...
For Example if i want load line 14...
Or sometime line 14-18...
It is SO useful for me to know the line number where an exception occurred. I inherited a project someone else created and I suspect he has some inherited Project properties from his initial Visual Studio Express solution. Where do I go to restore that critically important feature?[code]...
View 6 Repliesi want to get the line number of a text file that contains a particular string data.
1. using the string data like str="book"
2. find if the string is part of the file
3. get the line numbers of where it occurs.
eg
filename=sample.txt
sample.txt contains
dance
book
[Code]...
i want to delete few lines from a big text file , normally this lines are at the starting of the text file , so it is possible that i can enter the line no from input box and the vb.net can delete that particular line number from the text file ,
[Code]...
I am trying to figure out how to replace text in a text file on a specific line number. (for testing, line number 4).
View 6 RepliesI'm new here, but have been in and out for a while. Past threads have been helping me along thus far.
I'm currently developing an app which essentially needs a way for me to search in a text box or file for a specific string, and extract the line on which that string appears on. It will be unique, and the syntax is the same on each line. It has basically 2 ID numbers, and is laid out like this:
123456|123456
So, I'd need to search for the first part before the |, and then get the line so I can get the bit after the |, which is the important bit for me.
When the user clicks the Process Files button, do the following:
Read and process the contents of each of the 6 files.
Each file contains data in a different format.
and display them in arrylist. In the list it should contain name of the file and number of person in the text file example below.[code]...
How to create an error log system, which will log all errors(caused in my app) to a text file with line number, sub/function in which the error occurred, error details, etc. ?
View 11 RepliesI have a problem with a sql query. Through the query I am trying to search database for any occurrences of string (can be anything) in a column using the SQL LIKE command. The problem is that it works fine for most of the strings say john, jim, ji"m , but does not work when i include the following characters which are ( ' , { , } , and a single quotation mark). MYSQL query takes care of these special cases by putting them in [] block whenever user enters them .But i am getting the following error when i go to query the database using the GetSelectCommand() in VB.NET
Exception Details: System.ApplicationException: Number of values provided must be equal to the number of placeholders in query.I have checked the query over and over again .. but its fine .My database server is Sql Server 2008.So my application throws the exception in this command:
Using reader As MustDisposeDataReader = _
pmSystem.DatabaseManager.GetSelectCommand(selectStatementBuilder.ToString(), New Object() {})
Where MustDisposeDataReader is an instance of a class in an internally developed library, which inherits from System.Object. pmSystem is an instance of the class PlanManagerSystem which implements the commandlayer. GetSelectCommand() takes the select command
Is there a way to show the line number of the line of code that caused an exception within a Try...Catch block?
View 5 RepliesHow do I limit the number of characters per each line of an RTB to 1 char per line? That is you type one character, after that the textbox should not accept further input on that specific line.-Knock knock -Who's there? -(looong pause..) Java
View 1 RepliesI am searching for a best practice for Incremental Line Number generation i.e in an Invoice application. I am using VS2005, Sql2005 as a development environment. I need to create autoincremental line numbers for an invoice. I dont want to solve it in Database.
[Code]...
I'd like to know if its possible to copy a certain line chosen by line number(EX: line #3) from rtb1 to rtb2 and then split it word by word and copy those words as new lines into rtb3
Ex:
Originally Posted by richtextbox1
line 1
line 2
[Code]....
You would think a search for this would show some results but I have had no luck.If I want to delete a line by a line number from a text file, how do I do that?
View 6 RepliesI'm doing a notepad project, just because, and in Ms's notepad there is an option for a statusstrip. I'm just having probems getting the line number and I know it's not called column number, more like selection start. When I do the selection start, it works, just not how I want it to like so:
[CODE...]
but when I use that, it acts funny. I have it in my textbox's.keydown event. So if I were to use the arrow keys to navigate around text then it gets thrown off very easily. How would I do this?
what i need to do is open a txt file, read line by line, decode each line into an array and display. Now all works ok apart from one line.
sTextLine = objReader.ReadLine() <-- Value of string cannot be converted.
full code here
-------------
Dim objReader As New System.IO.StreamReader(sOpenFile.Text)
Dim sTextLine As New ArrayList()
Dim sText As String = ""
Dim i As Integer = 0
[code]....
How would i go about reading a file Line by Line that within that line The values are delimited by " Example of the data:
"bob" "cat" "1243"
"steve" dog" "6789"
I've started this with this code but not sure how to go about the next stage:
Using MyReader As New _
Microsoft.VisualBasic.FileIO.TextFieldParser(My.Application.Info.DirectoryPath & "Records28112011.jd")
MyReader.TextFieldType = FileIO.FieldType.Delimited
[code]....
I'm reading a text file with StreamReader, line by line. If a condition is met, then I do an operation and then start reading the file again from the first line. I realize I could close and then re-open the file, but surely this would be very slow.
I could do this easily in VB6, but pulling my hair out trying to do this in vB.net. It seems that 'Seek' is the function to use, but it doesn't work.
I've seen other examples, where it works, but you must open it a different way -- with a file number.
Imports System.IO
Dim I as Integer
Dim LineText as String
[Code].....
If i have a line in a txt document "text.txt".Now what i want to do is open the file and read the contents.
When it find this "search.selectedEngine" term then it should delete that particular line and replace it with another string ("REPLACED STRING").
SQL String with multi line query
View 14 RepliesThis is my frist post on the forum So I hope I am giving enough info, If not let me know if there isanything I missed.I have currently completed a project where I do a Query in SQL Server 2000 in VB 2010 and produce reports for each Tax id. When I Debug the program it finds the number and processes the reports, when I just let it run as an executable it does not pick up or find the number.
This number happens to be the last number coming back from the query and it processess in a loop while Not filename.EOF it goes thru 4 seperate routines and then loops back to get the next taxid. I did not put any routines to sleep and I am thinking maybe the application is just stepping on itself, could this be right? Thecreatereport path does a sql execute for the appropriated Table against the TaxID an the current Cycledate, then produces the report va CR2010(beta) and exports it as a pdf file to a directory on the shared sever.
[Code]...
Now i need to add a number to each line.
If File.Exists("C:adresa.txt") Then
Dim file1Sr As New StreamReader("C:adresa.txt")
Dim theLineNumber As Integer = 1[code].....
why thos code will not add a number to each line from text file ?
I have some pieces of code like this:
strSoftware = "select MobileSoftware.Entertainment, MobileSoftware.MobileApplication, MobileSoftware.RingingTone, MobileSoftware.Directory from MobileSoftware where MobileName = '" + strName + cmdSoftware = New SqlCommand(strSoftware, con)
drSoftware = cmdSoftware.ExecuteReader
When I write the query in one line, then it works. But when I do like this:
[Code]...
I am using VB.NET to query via SQL an Excel spreadsheet using ADO. The general way is like this: SELECT [firstname], [secondname] FROM [Sheet1$] Which works perfectly
However, one of the headings is called 3, so I want to do: SELECT [firstname], [secondname], [3] FROM [Sheet1$] However, this does not work. I know I can use * to get all columns, but later on I want to use (using dataReader): dr("3") which won't work
I want to query items from countries that are selected from a treeview (with checkboxes). However the number of countries that is selected by the user is not known beforehand. So how can I make a proper query when the number of OR operators is unknown? For example: SELECT DISTINCT Item FROM Countries WHERE Country LIKE @c1 OR @c2 OR @c3 etc� and then add the parameter values based on the selected countries in the treeview. I looked into parameter arrays but can�t make sense out of it really
View 13 RepliesI'm trying to read a file line by line into an array but It skips the item at index:3 I have it msgboxing just to make sure and it wont even touch it.
Dim Btn As Button = DirectCast(sender, Button)
Dim path As String = Application.StartupPath & "Libraries" & Btn.Text.Replace(" ", "_") & ".ipt"
Dim i As Integer = 0
Dim lines As String() = IO.File.ReadAllLines(path)
[code]....
I'm having trouble with reading a .txt file line by line, converting it into a string, then putting it into a listbox. When I execute I get an error saying "IndexOutOfRangeException was unhandled" Here is my
[Code]...
i would like to store contents from a text file line by line to arrays before copying them to another text file. what i have is currently like this:
[Code]...
Currently I'm only able to store the whole content into one variable, would like to store the content line by line in arrays.
How to get a line number that contains a specified string in a text file?
Example text file contains:
Red
White
Yellow
Green
How to get "Yellow" line number? and can i write a string in a specified line, lets say i want to write a string in line 2?