Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can do this one of three ways:</p> <p>1) Write your own StreamReader. Here's a good place to start: <a href="https://stackoverflow.com/questions/829568/how-to-know-positionlinenumber-of-a-streamreader-in-a-textfile">How to know position(linenumber) of a streamreader in a textfile?</a></p> <p>2) The StreamReader class has two very important, but private variables called charPos and charLen that are needed in locating the actual "read" position and not just the underlying position of the stream. You could use reflection to get the values as suggested <a href="http://www.daniweb.com/software-development/csharp/threads/35078/streamreader-and-position" rel="nofollow noreferrer">here</a> </p> <blockquote> <pre><code>Int32 charpos = (Int32) s.GetType().InvokeMember("charPos", BindingFlags.DeclaredOnly | BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.GetField ,null, s, null); Int32 charlen= (Int32) s.GetType().InvokeMember("charLen", BindingFlags.DeclaredOnly | BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.GetField ,null, s, null); return (Int32)s.BaseStream.Position-charlen+charpos; </code></pre> </blockquote> <p>3) Simply read the entire file into a string array. Something like this:</p> <blockquote> <pre><code>char[] CRLF = new char[2] { '\n', '\r' }; TextReader tr = File.OpenText("some path to file"); string[] fileLines = tr.ReadToEnd().Split(CRLF); </code></pre> </blockquote> <p>Another possibility (along the sames lines as #3) is to read in the lines and store the line in an array. When you want to read the prior line, just use the array.</p>
    singulars
    1. This table or related slice is empty.
    1. POTracking the position of the line of a streamreader
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USChris Gessler
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POTracking the position of the line of a streamreader
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for the response, but I have tried out solution #2 but I dont think that that gives me the current position/line I am currently reading with the streamreader.ReadLine() method. And Also is there a way to start reading the file from a specified line/position? Thanks in advance.
      singulars
      1. PO
      1. USjohnnie
    2. CO@johnnie - possibly by setting the BaseStream.Position = N and using StreamReader.Read(). I think it would be better to keep your own collection of cached lines so you can re-read any line by line number without going back to the file itself. However, this may present memory issues with large files.
      singulars
      1. PO
      1. USChris Gessler
    3. COthats the problem I am lying with, the file that i need to read from a certain line will be a huge file and reading each line to find a certain position i need to read from will be to intensive. SO i am trying to find a way to get the current position and then save that and read it from there.
      singulars
      1. PO
      1. USjohnnie
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload