C# WINFORM 导入文本文件到ACCESS数据库中,将文本文件中日期为空值也能导入到ACCESS中

 

string conString = ConfigurationManager.ConnectionStrings["conn"].ToString();

conn = new OleDbConnection(conString);

conn.Open();

string QueryString = "Insert Into [chelxx](cphm,clcpxh,fdjhm,cljg,yplx,llyh,sjyh,zzl,yxrj,cllx,cslc,jyxzlcbz,czxm,zj,fphm,rzzlbz,rzzgzsh,clxxbgrq,clsyzt,clztbgrq,nsrsbh,swjgdm) Values(@cphm,@clcpxh,@fdjhm,@cljg,@yplx,[llyh],[sjyh],[zzl],@yxrj,@cllx,@cslc,@jyxzlcbz,@czxm,@zj,@fphm,@rzzlbz,@rzzgzsh,@clxxbgrq,@clsyzt,@clztbgrq,@nsrsbh,@swjgdm)";

                cmd = new OleDbCommand(QueryString, conn);

                try{
                        while( file.Peek() > -1)

                        {

                             string instr = file.ReadLine();
                             string[] inData = instr.Split(',');
                             MessageBox.Show(inData[1] +","+ inData[2]);
                            
                             cmd.Parameters.AddWithValue("@cphm", inData[0]);
                             cmd.Parameters.AddWithValue("@clcpxh", inData[1]);
                             cmd.Parameters.AddWithValue("@fdjhm", inData[2]);
                             cmd.Parameters.AddWithValue("@cljg", inData[3]);
                             cmd.Parameters.AddWithValue("@yplx", inData[4]);
                             cmd.Parameters.AddWithValue("@llyh", inData[5]);
                             cmd.Parameters.AddWithValue("@sjyh", inData[6]);
                             cmd.Parameters.AddWithValue("@zzl", inData[7]);
                             cmd.Parameters.AddWithValue("@yxrj", inData[8]);
                             cmd.Parameters.AddWithValue("@cllx", inData[9]);
                             cmd.Parameters.AddWithValue("@cslc", inData[10]);
                             cmd.Parameters.AddWithValue("@jyxzlcbz", inData[11]);
                             cmd.Parameters.AddWithValue("@czxm", inData[12]);
                             cmd.Parameters.AddWithValue("@zj", inData[13]);
                             cmd.Parameters.AddWithValue("@fphm", inData[14]);
                             cmd.Parameters.AddWithValue("@rzzlbz", inData[15]);
                             cmd.Parameters.AddWithValue("@rzzgzsh", inData[16]);
                            //导入日期格式，空值或有值
                             OleDbParameter parameterClxxbgrq = new OleDbParameter();
                             parameterClxxbgrq.ParameterName = "@clxxbgrq";
                             parameterClxxbgrq.OleDbType = OleDbType.DBDate;

                             if (inData[17].ToString().Trim().Length == 0)
                             {

                                 parameterClxxbgrq.Value = System.DBNull.Value;
                             }
                             else
                             {
                                 parameterClxxbgrq.Value = DateTime.Parse(inData[17]);
                             }
                             cmd.Parameters.Add(parameterClxxbgrq);

                             //cmd.Parameters.AddWithValue("@clxxbgrq", inData[17]);
                              cmd.Parameters.AddWithValue("@clsyzt", inData[18]);
                             //导入日期格式，空值或有值
                             OleDbParameter parameterClztbgrq = new OleDbParameter();
                             parameterClztbgrq.OleDbType = OleDbType.DBDate;
                             parameterClxxbgrq.ParameterName = "@clztbgrq";
                             if (inData[19].ToString().Trim().Length == 0)
                             {
                                 parameterClztbgrq.Value = System.DBNull.Value;
                             }
                             else
                             {
                                 parameterClztbgrq.Value = DateTime.Parse(inData[19]);
                             }
                             cmd.Parameters.Add(parameterClztbgrq);

                             //cmd.Parameters.AddWithValue("@clztbgrq", inData[19]);
                             cmd.Parameters.AddWithValue("@nsrsbh", inData[20]);
                             cmd.Parameters.AddWithValue("@swjgdm", inData[21]);

                             odr = cmd.ExecuteNonQuery();
                             cmd.Parameters.Clear();

                         }
                            if (odr > 0)
                            {
                                MessageBox.Show("车辆信息记录导入成功,", "提示");
                                file.Close();
                               
                                this.Close();
                             }

                }
                catch (Exception ee)
                {
                    MessageBox.Show(ee.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    file.Close();
                }
            }
            conn.Close();
            conn.Dispose();

已测试通过