C#求助！读取ACCESS中数据写到SQL中，每次都是异常，有代码

Question

        private void ReadAccessData()
        { try
            {try
                {
                    odCommand.Connection = odcConnection;
                    odcConnection.Open();
                    odCommand.CommandText = "select  rd_barcode,rd_name,rd_sex,rd_department,rd_speciality,rd_date_useless from lt_reader";                    //建立读取
                    odrReader = odCommand.ExecuteReader();
                    odrReader.Read();
                }
                catch { MessageBox.Show("not open ACCESS"); }                try
                {                    sqlcmd.Connection = conn;
                    conn.Open();
                }
                catch { MessageBox.Show("not open SQL"); }            if (odrReader.HasRows)
            {
                foreach (System.Data.Common.DbDataRecord s in odrReader)
                {
                    code=odrReader["rd_barcode"].ToString();
                    name = odrReader["rd_name"].ToString();
                    sex = odrReader["rd_sex"].ToString();
                    bumen = odrReader["rd_department"].ToString();
                    zhuanye = odrReader["rd_speciality"].ToString();
                    int pw;
                    str_date = odrReader["rd_date_useless"].ToString();
                    Random rm = new Random();
                    pw = rm.Next(1000,100000);                    if (isoutdate(str_date))
                    {
                        try
                        {   //验证该记录是否已经被插入                           
            string cmdstr = "select  姓名 from 用户信息 where (编号 = '"+code.Trim()+"')";
                            sqlcmd.CommandText = cmdstr;
            sqlreader = sqlcmd.ExecuteReader();
//用户信息  编号 姓名 性别 密码 单位 班级 状态 免费机时
                            if (!sqlreader.Read())
                            {
                                
                                //conn.Close();
                                StringBuilder sb= new StringBuilder();
                                sb.Append("insert into 用户信息(编号,姓名,性别,密码,单位,班级,类型,状态,免费,总计) values('");
                                sb.Append(code.Trim());
                                sb.Append("','");
                                sb.Append(name.Trim());
                                sb.Append("','");
                                sb.Append(sex.Trim());
                                sb.Append("','");
                                sb.Append(pw);
                                sb.Append("','");
                                sb.Append(bumen.Trim());
                                sb.Append("','");
                                sb.Append(zhuanye.Trim());
                                sb.Append("','");
                                sb.Append(str_date.Trim());
                                sb.Append("',");
                                sb.Append("'0',");
                                 sb.Append("10,");
                                sb.Append("'0',)");
                                //string temp1 = sb;
                                //cmdstr = "insert into 用户信息(编号,姓名,性别,密码,单位,班级,类型,状态,余额,免费,总计) values('" + code.Trim() + "','" + name.Trim() + "','" + sex.Trim() + "','" + pw + "','" + bumen.Trim() + "','" + zhuanye.Trim() + "','" + str_date.Trim() + "','','0','10','0',) ";
                                //conn.Open();
                                sqlreader.Close();
                                sqlcmd.CommandText = sb.ToString();
                                
                                //sqlcmd.Connection = conn;
                                sqlcmd.ExecuteNonQuery();
                            
                            }
                        }                        catch { MessageBox.Show("插入SQL异常"); }  每次都是到这里出错不用foreach遍历，没有问题
                    }
                }
                
            }
            else { MessageBox.Show("no rows"); }            //关闭连接
            odrReader.Close();
            odcConnection.Close();
            conn.Close();            }
            catch { MessageBox.Show("读ACCESS异常"); }           }
请各位高手看看问题在哪？？？？？？？？？？？