winform实现TXT文档内容的读取并存入SQL数据库 急求代码

Question

希望有高手帮我解决

Answer 1

StreamReader读取
http://msdn.microsoft.com/en-us/library/system.io.streamreader.aspx

Answer 2

using System.IO;
 StreamReader sr = new StreamReader(@"E:\WebPage\2011-04-12\248808221\250167153.txt");//你的txt文件路径
            string rowstring = "";
            while (sr.Peek() > 0)
            {
                rowstring = sr.ReadLine();// 获取当前行字符串
                  //ADO.NET将其插入数据库
              }
            sr.Close();

Answer 3

      private void 保存ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.saveFileDialog1.ShowDialog();
            saveFileDialog1.Filter = "*.txt|*.txt";
            string MyFileName = this.saveFileDialog1.FileName;
            if (MyFileName.Trim() == "") return;
            StreamWriter MyWriter = null;
            try
            {
                MyWriter = new StreamWriter(MyFileName, false, System.Text.Encoding.Default);
                MyWriter.Write(this.richTextBox1.Text);
            }
            catch (Exception )
                {
                 MessageBox .Show ("写文本时发生错误!","信息提示",MessageBoxButtons .OK ,MessageBoxIcon.Information );
                 return;
                } 
            finally 
            {
                if (MyWriter != null)
                {
                    MyWriter.Close();
                }
            }
            
        }
     private void 打开ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            openFileDialog1.ShowDialog();
            openFileDialog1.Filter = "*.txt|*.txt";
            string MyFileName = this.openFileDialog1.FileName;
            if (MyFileName.Trim() == "")
                return;
            StreamReader MyReader = null;
            try
            {
                MyReader = new StreamReader(MyFileName, System.Text.Encoding.Default);
                this.richTextBox1.Text = MyReader.ReadToEnd();
            }
            catch//(Exception )
            {
                MessageBox.Show("读取文本发生错误，请检查原文件是否是文本文件！","信息提示",MessageBoxButtons .OK ,MessageBoxIcon.Information );
                return;
            }
           
            finally
            {
                if (MyReader != null)
                {
                    MyReader.Close();
                }
            }
        }        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }        private void 关闭ToolStripMenuItem_Click(object sender, EventArgs e)
        { 
            Close();
        }        private void 剪切ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.richTextBox1 .Cut ();
        }        private void 复制ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.richTextBox1.Copy();
        }        private void 粘贴ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.richTextBox1.Paste();
        }        private void 撤销ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.richTextBox1.Undo();
        }        private void 重做ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.richTextBox1.Redo();
        }        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (richTextBox1.Text == "")
            {
                Application .Exit ();
            }
            else
            {
                MessageBox.Show("窗口即将关闭，是否保存？", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.saveFileDialog1.ShowDialog();
                saveFileDialog1.Filter = "*.txt|*.txt";
                string MyFileName = this.saveFileDialog1.FileName;
                if (MyFileName.Trim() == "") return;
                StreamWriter MyWriter = null;
                try
                {
                    MyWriter = new StreamWriter(MyFileName, false, System.Text.Encoding.Default);
                    MyWriter.Write(this.richTextBox1.Text);
                }
                catch (Exception)
                {
                    MessageBox.Show("写文本时发生错误!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                finally
                {
                    if (MyWriter != null)
                    {
                        MyWriter.Close();
                    }
                }
            }
        }        private void 打开OToolStripButton_Click(object sender, EventArgs e)
        {
            openFileDialog1.ShowDialog();
            openFileDialog1.Filter = "*.txt|*.txt";
            string MyFileName = this.openFileDialog1.FileName;
            if (MyFileName.Trim() == "")
                return;
            StreamReader MyReader = null;
            try
            {
                MyReader = new StreamReader(MyFileName, System.Text.Encoding.Default);
                this.richTextBox1.Text = MyReader.ReadToEnd();
            }
            catch//(Exception )
            {
                MessageBox.Show("读取文本发生错误，请检查原文件是否是文本文件！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }            finally
            {
                if (MyReader != null)
                {
                    MyReader.Close();
                }
            }
        }        private void 保存SToolStripButton_Click(object sender, EventArgs e)
        {
            this.saveFileDialog1.ShowDialog();
            string MyFileName = this.saveFileDialog1.FileName;
            saveFileDialog1.Filter = "*.txt|*.txt";
            if (MyFileName.Trim() == "") return;
            StreamWriter MyWriter = null;
            try
            {
                MyWriter = new StreamWriter(MyFileName, false, System.Text.Encoding.Default);
                MyWriter.Write(this.richTextBox1.Text);
            }
            catch (Exception)
            {
                MessageBox.Show("写文本时发生错误!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            finally
            {
                if (MyWriter != null)
                {
                    MyWriter.Close();
                }
            }
        }        private void 字体颜色ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            colorDialog1.ShowDialog();
            //string []s=new string [1048576];
            //for (string q = richTextBox1.SelectedText; ; q++)
            //{
                            //}
           
        }        private void 新建NToolStripButton_Click(object sender, EventArgs e)
        {
        }        private void 剪切UToolStripButton_Click(object sender, EventArgs e)
        {
            this.richTextBox1.Cut();
        }        private void 复制CToolStripButton_Click(object sender, EventArgs e)
        {
            this.richTextBox1.Copy ();
        }        private void 粘贴PToolStripButton_Click(object sender, EventArgs e)
        {
            this.richTextBox1.Paste ();
        }