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
Explain the differences between clr & cts?
How do http sessions work?
What is the default authentication mode for asp.net?
How do you handle server controls?
What are the difference between function and stored procedure in .net programming language?
What is caching? What are different ways of caching in asp.net?
What are the different kinds of assemblies?
Explain the function of new view engine in asp.net? : asp.net mvc
Explain how cookies work. Give an example of cookie abuse.
What is asp.net globalization?
What is paging in context of Memory?
What are the major built-in objects in ASP.NET?
What are session state modes? List some of the important session state modes of asp.net.
What are different methods of session maintenance in asp.net?
Why will you usually create an aspnet user account in the database for an asp.net web application?