reading text file as a database

[Lost User]

Member 4737022 wrote:

How can I read each line in that file?

StreamReader()[^] should do it.

[TheDudeJuan]

another idea would be using the File.ReadAllLines method :P this is easily found on google

Here we rest... So why not make the best of it? :D

[Lost User]

With a loop.

Check out the CodeProject forum Guidelines[^] The original soapbox 1.0 is back![^]

[Nuri Ismail]

You can use StreamReader[^] class to read the file line by line. If your fields are with fixed lengths you can use the String.Substring[^] method to extract the fields from the line. Here is an example:

string filePath = @"Path_to_your_file_here";
string line;

// Field lengths (I use the lengths from your original post):
int idLength = 5, snLength = 13, amountLength = 15, blankLength = 15;

if (File.Exists(filePath))
{
StreamReader file = null;
try
{
file = new StreamReader(filePath);
while ((line = file.ReadLine()) != null)
{
// Extract fields from the line
string id = line.Substring(0, idLength);
string sn = line.Substring(idLength, snLength);
string amount = line.Substring(idLength + snLength, amountLength);
string blank = line.Substring(idLength + snLength + amountLength, blankLength);
}
}
finally
{
if (file != null)
file.Close();
}
}

I hope this helps. :) Regards, Nuri Ismail

[TheDudeJuan]

there is no need for loop with the ReadAllLines method.. It returns a string array containing all the lines of a file ;)

Here we rest... So why not make the best of it? :D

[Lost User]

He said he was using this file as a database, which tend to be large. I'd personally prefer not to have an entire database in a string, whereas I can read a line, perform operations and discard of it keeping my memory footprint down.

Check out the CodeProject forum Guidelines[^] The original soapbox 1.0 is back![^]

[SilimSayo]

use StreamReader

int id;
int sn;
double amount;
int blank;
StreamReader sr = new StreamReader("C:\FileFolder\myfile.txt");//
String strInput="";
strInput=sr.ReadLine();//Read first line in file
while ((strInput = sr.ReadLine()) != null ) //Read file rest of the file
{
//Use Substring to extract specific portions of the string and assign value to the right variable
try
{
id = int.Parse(strInput.Substring(0,5));
sn=double.Parse(strInput.Substring(5,13));
//etc
}
catch(Exception e)
{

 }

}

NB. Just a learner so my code is not the best but there is a general idea

[PIEBALDconsult]

Do you want to have all the records in memory at once? Or do you want to read each particular record based on its ID or SN (e.g. GetRecord ( 7 ) )? What are you going to do with the data?

[User 4733684]

hello everybody I write one c# program for reading data record from an access database ant write each record to one line in text file and now I want to read data from each line in text file and show them on a form using labels or text boxes etc to check that the data on text file are equal to database records or not? I am sorry if i can't describe as well as you want .

[User 4733684]

Very thanks mr nuri ismail

[PIEBALDconsult]

Why not have the application that displays the data also get the data from Access? It's really not a difficult task.

[Nuri Ismail]

You're welcome! :) Regards