国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁(yè) > 學(xué)院 > 開發(fā)設(shè)計(jì) > 正文

csharp: datagridview Convert csv file

2019-11-17 02:56:35
字體:
來(lái)源:轉(zhuǎn)載
供稿:網(wǎng)友

csharp: datagridview Convert csv file

 /// <summary>        /// 保存文件        /// 涂聚文        /// 2014-08-29        /// Geovin Du        /// </summary>        /// <param name="dGV"></param>        /// <param name="filename"></param>        public static void DataGridViewToCsV(DataGridView dGV, string filename)        {            string stOutput = "";            // Export titles:              string sHeaders = "";            for (int j = 0; j < dGV.Columns.Count; j++)                sHeaders = sHeaders.ToString() + Convert.ToString(dGV.Columns[j].HeaderText) + ", ";            stOutput += sHeaders + "/r/n";            // Export data.              for (int i = 0; i < dGV.RowCount - 1; i++)            {                string stLine = "";                for (int j = 0; j < dGV.Rows[i].Cells.Count; j++)                    stLine = stLine.ToString() + Convert.ToString(dGV.Rows[i].Cells[j].Value) + ", ";                stOutput += stLine + "/r/n";            }            UTF8Encoding utf8 = new UTF8Encoding();            string file = "1.csv";            SaveFileDialog saveFileDialog1 = new SaveFileDialog();            saveFileDialog1.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);//Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);            saveFileDialog1.CreatePRompt = true;            saveFileDialog1.OverwritePrompt = true;            saveFileDialog1.Title = "Save text Files";            //saveFileDialog1.CheckFileExists = true;            //saveFileDialog1.CheckPathExists = true;            saveFileDialog1.DefaultExt = "csv";            saveFileDialog1.Filter = "csv files (*.csv)|*.csv|All files (*.*)|*.*";            saveFileDialog1.FilterIndex = 1;            saveFileDialog1.RestoreDirectory = true;            System.IO.Stream fileStream;            if (saveFileDialog1.ShowDialog() == DialogResult.OK)            {                //FileStream fs = new FileStream(filename, FileMode.Create);                file = saveFileDialog1.FileName;                fileStream = saveFileDialog1.OpenFile();                MemoryStream userInput = new MemoryStream();                byte[] output = Encoding.Default.GetBytes(stOutput);                //fileStream.Read(output, 0, (int)output.Length);                fileStream.Write(output, 0, output.Length);                fileStream.Close();            }         }        /// <summary>        /// 保存文件        /// 涂聚文        /// 2014-08-28        /// Geovin Du        /// </summary>        /// <param name="dGV"></param>        /// <param name="filename"></param>        public static void DataGridViewToCsVDu(DataGridView dGV, string filename)        {            string stOutput = "";            // Export titles:              string sHeaders = "";            for (int j = 0; j < dGV.Columns.Count; j++)                sHeaders = sHeaders.ToString() + Convert.ToString(dGV.Columns[j].HeaderText) + ", ";            stOutput += sHeaders + "/r/n";            // Export data.              for (int i = 0; i < dGV.RowCount - 1; i++)            {                string stLine = "";                for (int j = 0; j < dGV.Rows[i].Cells.Count; j++)                    stLine = stLine.ToString() + Convert.ToString(dGV.Rows[i].Cells[j].Value) + ", ";                stOutput += stLine + "/r/n";            }            UTF8Encoding utf8 = new UTF8Encoding();            //Encoding utf16 = Encoding.GetEncoding(1200);//unicode encoding            byte[] output = Encoding.Default.GetBytes(stOutput);            FileStream fs = new FileStream(filename, FileMode.Create);            BinaryWriter bw = new BinaryWriter(fs, Encoding.Default);            bw.Write(output, 0, output.Length); //write the encoded file            bw.Flush();            bw.Close();            fs.Close();                    }


發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 连州市| 镇康县| 仁怀市| 彩票| 长沙市| 新郑市| 铁力市| 繁峙县| 米林县| 明星| 鸡东县| 浦北县| 资讯 | 广汉市| 盐边县| 嘉义县| 永新县| 剑河县| 万源市| 如东县| 曲沃县| 长阳| 鹤峰县| 习水县| 宜君县| 阜康市| 平远县| 繁峙县| 朝阳县| 毕节市| 乐业县| 紫金县| 惠安县| 德格县| 山丹县| 巴彦淖尔市| 崇明县| 洛隆县| 镇江市| 洮南市| 于都县|