ASP.NET with C# and SQL SERVER , some vb.net . asp.net examples, asp.net codes, asp.net programs, c# code, sql server queries, important codes.
Saturday, 20 October 2012
read write text files in asp.net c#
// write data from database to text file
public void WriteToFile(string filename, string type)
{
StreamWriter SW;
if (type.Equals("create"))
SW = File.CreateText(filename);
else
SW = File.AppendText(filename);
dtr = GetData();
while (dtr.Read()) // getting rows of datareader
{
int i = 0;
string str = "";
while (i < dtr.FieldCount) // getting columns of a single row
{
str += dtr[i].ToString() + ",";
i++;
}
SW.WriteLine(str);
}
dtr.Close();
SW.Close();
}
//private void ReadFromFile(string filename)
//{
// StreamReader SR;
// string S;
// SR = File.OpenText(filename);
// S = SR.ReadLine();
// while (S != null)
// {
// // response.write( S );
// S = SR.ReadLine();
// }
// SR.Close();
//}
// loop
//while (dtr.Read()) // getting rows of datareader
//{
// int i = 0;
// string str = "";
// //while (i < dtr.FieldCount) // getting columns of a single row
// //{
// // str += dtr[i].ToString() + ",";
// // i++;
// //}
// str = dtr[0].ToString();
// SW.WriteLine(str);
//}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment