国产探花免费观看_亚洲丰满少妇自慰呻吟_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ā)表
主站蜘蛛池模板: 广饶县| 利川市| 红原县| 玉山县| 广宁县| 易门县| 河东区| 南通市| 南投市| 独山县| 内黄县| 英山县| 彩票| 城口县| 林西县| 农安县| 福鼎市| 鄂温| 临海市| 新安县| 阳东县| 绥化市| 沽源县| 桦甸市| 永仁县| 苗栗市| 镇沅| 谢通门县| 潜江市| 海兴县| 年辖:市辖区| 海南省| 滕州市| 西乌珠穆沁旗| 万源市| 湾仔区| 寿阳县| 泰来县| 额尔古纳市| 资溪县| 綦江县|