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
How can we register exception filter from the action?
What is difference between viewstate and session state in javascript?
What are client activated objects?
What is anonymous authentication?
What is asp.net version?
How does a web application session work?
What does asp in asp.net stand for?
List the major built-in objects in asp.net?
What are themes and skins in 2.0, explain usage scenario?
What are validator? Name the validation controls in asp.net?
How to reduce the width of textbox in editcommandcolumn of datagrid?
What is round trip in asp.net?
explain code with datachaching with example
Which protocol is used to call web service?
Explain the difference between page.registerclientscriptblock and page.registerstartupscript?