private static void ExportDescription() { int countCompany = 0; StreamWriter outfile = new StreamWriter("ShortDescription.txt"); List <string> lst = new List <string>(); ProductAdapter productAdapter = new ProductAdapter(new SqlDb(Server.ConnectionString)); List <long> companyIds = productAdapter.GetAllCompanyIdSystem(); foreach (long companyID in companyIds) { foreach (DataRow rowInfo in productAdapter.GetDescriptionData(companyID).Rows) { if (rowInfo["ShortDescription"] != DBNull.Value) { string data = rowInfo["ShortDescription"].ToString().Trim(); if (!string.IsNullOrEmpty(data)) { outfile.Write(data + "\n:::::\n"); } } } log.Info(string.Format("Success compay {0}/{1}", countCompany++, companyIds.Count)); } outfile.Close(); log.Info("OK"); }