Question

c#winform怎么记录执行过的sql语句到txt文本中

c#winform怎么记录执行过的sql语句到txt文本中，请提供详细代码，谢谢

Answer 1

写日志一样。。 

 //strExp 执行过的Sql语句
        public void WriteSQLLog(string strExp)
        {
            try
            {
                string path = AppDomain.CurrentDomain.BaseDirectory.ToString();
                path = path + "SQL/";

                if (!Directory.Exists(path))
                {
                    Directory.CreateDirectory(path);
                }

                FileStream fs = new FileStream(path + "sql_log.log", FileMode.Append);
                StreamWriter sw = new StreamWriter(fs);
                sw.Write("[" + DateTime.Now.ToString("yyy-MM-dd HH:mm:ss") + "]" + strExp + "\r\n");
                sw.Flush();
                sw.Close();
            }
            catch
            {
                return;
            }
        }