How can we read a columnised text data in ASP.Net C#? Columnised means my data

How can we read a columnised text data in ASP.Net C#?
Columnised means my data is stored in a text file and I
have numeric data or string data in this file. For ex. If I
am searching for the data of gender and I know that gender
data is stored at column 32 in text file. How can I get
this data in ASP.Net page. Thanks for help in advance.

Question Posted / abhinavsaxena24

2 Answers
5764 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we read a columnised text data in ASP.Net C#? Columnised means my data is stored in a text..

Answer / sandeep kumar shaw

we need that text file convert into integer for example
cint(Textbox1.text)..

Is This Answer Correct ?

6 Yes

6 No

How can we read a columnised text data in ASP.Net C#? Columnised means my data is stored in a text..

Answer / praveen kumar

string OpenPath, contents;
int tabSize = 4;
string[] arInfo;
string line;
DataTable table = CreateTable();
DataRow row;
try
{

OpenPath = Server.MapPath(".") + @"\My
File.log";
string FILENAME = OpenPath;
//Get a StreamReader class that can be used
to read the file
StreamReader objStreamReader;
objStreamReader = File.OpenText(FILENAME);
while ((line = objStreamReader.ReadLine())
!= null)
{
contents =
line.Replace(("").PadRight(tabSize, ' '), "\t");

// define which character is seperating
fields
char[] textdelimiter = { ']' };

arInfo = contents.Split(textdelimiter);
for (int i = 0; i <= arInfo.Length; i++)
{
row = table.NewRow();
if (i < arInfo.Length)
row["Type"] =
arInfo[i].ToString().Replace("[", " ");

if (i + 1 < arInfo.Length)
row["Source"] = arInfo[i +
1].ToString().Replace("[", " ");
if (i + 2 < arInfo.Length)
row["Time"] = arInfo[i +
2].ToString().Substring(1);
if (i + 3 < arInfo.Length)
{
row["Description"] = arInfo[i +
3].ToString().Replace("[", " ");
table.Rows.Add(row);
}
i = i + 2;
}
}