I have records in table1 and i want to copy them into text files. Can it to be done? I have example in c# codes, but it using streamWriter. If in FileSystemObject what methods should we use? I have solution in c# code, but it using streamWriter. I wanna code using VBScript WSH, and my database is MSSQL 2005 Server.
Any solution, references, or guide are very thankful..thanks
using (StreamWriter tw = File.AppendText("c:\\INMS.txt")) { using (SqlDataReader reader = cmd.ExecuteReader()) { tw.WriteLine("id, ip address, message, datetime"); while (reader.Read()) { tw.Write(reader["id"].ToString()); tw.Write(", " + reader["ip"].ToString()); tw.Write(", " + reader["msg"].ToString()); tw.WriteLine(", " + reader["date"].ToString()); } tw.WriteLine("Report Generate at : " + DateTime.Now); tw.WriteLine("---------------------------------"); tw.Close(); reader.Close(); } }
This post has been edited by dunk_6: 10 September 2009 - 01:58 AM