How to resume StreamReader to start reading from continue.

Srinivas M

Actually I have an application in that I'm reading Stream data using StreamReader line to line and Inserting into Data Base If any Case Internet Connection Closed or system shutdown then i want to resume Stramreader don't want to read from starting Position of the Stream.

Stream stream = res.GetResponseStream();
using (StreamReader sr = new StreamReader(stream))
{
int i = 1;
int j = 0;
string ss = "";
List<string> strContent = new List<string>();
while (i > j)
{
StringBuilder sb = new StringBuilder();
while (!sr.EndOfStream)
{
string line = sr.ReadLine();
ss = ss + line;
i++;
if (line.Equals(""))
{
if ((sr.EndOfStream))
{
}
else
{
ss = ss + "";
}
var mySourceDoc = new XmlDocument();
//load the file from the stream
mySourceDoc.LoadXml(ss);
//XmlNode nd = mySourceDoc.DocumentElement.SelectSingleNode("//records");
XmlDocument xmlAPDP = new XmlDocument();
xmlAPDP.LoadXml(ss);
XmlNodeReader xmlReader = new XmlNodeReader(xmlAPDP);
DataSet dataSet = new DataSet();
dataSet.ReadXml(xmlReader);
string sds = WriteXML(dataSet);
ss = "";
ss = "";
j = i;
i = j + 1;
break;
}
}
if ((sr.EndOfStream))
{
break;
}
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Hi. When you insert the data in DB at that time create another table as well as a column and simultaneously you update that column like how many lines updated. For example 10 lines inserted then you need to update 10 as in the another table. When you will resume the reading at that time retrieve the line value from db and Seek that much number of lines by using Seek method which is given below. Inserting the value In line number column should be a repetative process. Thanks. Cheers.
Amit Gupta7y ago
Hey

You can use Seek function to resume the position like

var sr = new StreamReader("test.txt");
sr.BaseStream.Seek(2, SeekOrigin.Begin);

Refer
https://stackoverflow.com/questions/5404267/streamreader-and-seeking/17457085

Be a googler :)

Good Luck