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.
Answer Posted / 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;
}
}
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Why SessionID changes in every request in asp.net?
Is viewstate enabled by default?
What is asp.net mvc5? : Asp.Net MVC
How to add DateTime Control in normal DataGrid Server Control?
Will session work if cookies is disabled?
Explain how caching in asp.net 2.0 is different from caching in asp.net 1.1?
Explain Session state management options in ASP.NET.
Explain the components of web form in asp.net
Can you change a Master Page dynamically at runtime?
What is meant by server side scripting?
What is repository pattern in mvc.net? : asp.net mvc
Difference between application events and session events
Explain the difference between singleton and single call?
What are the asp.net 2.0 features?
What happens if an ASP.NET server control with event-handling routines is missing from its definition?