奇怪的问题 串口通信程序将txt数据保存进access中产生

Question

private void button1_Click(object sender, EventArgs e)
        {
            openFileDialog1.InitialDirectory = @"c:\";
            openFileDialog1.Filter = "文本文件(*.txt)|*.txt|所有文件(*.*)|*.*";            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                int n = 0;
                string fname = openFileDialog1.FileName;
                StreamReader sr = new StreamReader(@fname, System.Text.Encoding.GetEncoding("gb2312"));
                char[] parsChar = { ' ' };
                string water = string.Empty;
                string date1 = string.Empty;
                string time1 = string.Empty;
                string temp = string.Empty;
                string date2 = string.Empty;
                string time2 = string.Empty;
                string space = string.Empty;
                string sctemp = textBox1.Text;
                string tmpLine;
                string splitline;
                string[] line; //string[] line2;
                while ((tmpLine = sr.ReadLine()) != null)
                {
                    n++;
                    linebuilder.Append(tmpLine + " ");
                    if (n % 2 == 0)
                    {
                        splitline = linebuilder.ToString();
                        line = splitline.Split(parsChar);
                        water = line[0];
                        date1 = line[1];
                        time1 = line[2];
                        space = line[3];
                        temp = line[4];
                        date2 = line[5];
                        time2 = line[6];
                        OleDbCommand cmd = new OleDbCommand("Insert Into txttest ([water],[date1],[time1],[temp],[date2],[time2],[sctemp]) values ('" + water + "','" + date1 + "','" + time1 + "','" + temp + "','" + date2 + "','" + time2 + "','" + sctemp + "') ");
                        using (OleDbConnection conn = new OleDbConnection(connStr))
                        {
                            cmd.CommandType = CommandType.Text;
                            if (conn.State != ConnectionState.Open)
                            { conn.Open(); }
                            cmd.Connection = conn;
                            cmd.ExecuteNonQuery();
                        }                    }                }
            }
        }编译时也没有错误。但调试的时候会卡住。用了debug版本运行后出现上图中的错误。
串口通信 access

Answer 1

1，查看你的SQL语句有没有进错表格。
2，LZ你的split代码好奇怪， 从N=3开始你怎么进入ACCESS表？

Answer 2

楼上说的对。另外我发现用seriport的同时不能写入数据库。估计是线程冲突。