Exemplo n.º 1
0
 public static int WriteDataTableToCsv(string TabelName, string FileName)
 {
     if (FileName != null)
     {
         try
         {
             Stopwatch watch = Stopwatch.StartNew();
             watch.Start();
             DataTable dt = UiServices.GetDataTableFromName(TabelName);
             SaveCsv(dt, FileName);
             watch.Stop();
             return(Convert.ToInt32(watch.ElapsedMilliseconds / 1000));
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message);
         }
     }
     return(-1);
 }
Exemplo n.º 2
0
 public static int WriteDataTableToCsv(string TabelName)
 {
     System.Windows.Forms.SaveFileDialog saveFileDialog1 = new System.Windows.Forms.SaveFileDialog();
     saveFileDialog1.Filter     = "csv文件|*.csv";
     saveFileDialog1.FileName   = TabelName;
     saveFileDialog1.DefaultExt = ".csv";
     if (saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
     {
         string filename = saveFileDialog1.FileName.ToString();
         try
         {
             DataTable dt = UiServices.GetDataTableFromName(TabelName);
             int       i  = SaveCsv(dt, filename);
             return(i);
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message);
         }
     }
     return(-1);
 }