C#写入数据到mysql数据库,这段代码哪里有问题?请教各位!在线等待达人!
代码如下:/// <summary>
        /// 写入到数据库
        /// </summary>
        static private void WriteToDb(List<Player> players)
        {
            string source = "DSN=MySqlOperation";
            OdbcConnection conn = null;
            OdbcCommand cmd = null;
            
            try
            {
                conn = new OdbcConnection(source);
                conn.Open();
                cmd = conn.CreateCommand();                foreach (Player p in players)
                {
                    string sqlStr = @"INSERT
                                  INTO nbaPlayers
                                  VALUES(?EnglishName,?ChineseName,?Team,?Birthday,?Height,?Weight,?ComeFrom,?Career)";                    OdbcParameter para_0 = new OdbcParameter("?EnglishName", OdbcType.VarChar, 50);
                    para_0.Value = p.EnglishName;
                    cmd.Parameters.Add(para_0);                    OdbcParameter para_1 = new OdbcParameter("?ChineseName", OdbcType.VarChar, 50);
                    para_1.Value = p.ChineseName;
                    cmd.Parameters.Add(para_1);                    OdbcParameter para_2 = new OdbcParameter("?Team", OdbcType.VarChar, 50);
                    para_2.Value = p.Team;
                    cmd.Parameters.Add(para_2);                    OdbcParameter para_3 = new OdbcParameter("?Birthday", OdbcType.VarChar, 50);
                    para_3.Value = p.Birthday;
                    cmd.Parameters.Add(para_3);                    OdbcParameter para_4 = new OdbcParameter("?Height", OdbcType.VarChar, 50);
                    para_4.Value = p.Height;
                    cmd.Parameters.Add(para_4);                    OdbcParameter para_5 = new OdbcParameter("?Weight", OdbcType.VarChar, 50);
                    para_5.Value = p.Weight;
                    cmd.Parameters.Add(para_5);                    OdbcParameter para_6 = new OdbcParameter("?ComeFrom", OdbcType.VarChar, 50);
                    para_6.Value = p.ComeFrom;
                    cmd.Parameters.Add(para_6);                    OdbcParameter para_7 = new OdbcParameter("?Career", OdbcType.Int);
                    para_7.Value = p.Career;
                    cmd.Parameters.Add(para_7);                    cmd.CommandText = sqlStr;
                    cmd.ExecuteNonQuery();                }
            }
            catch(Exception excpt)
            {
                //MessageBox.Show(excpt.Message);
                Console.WriteLine(excpt.Message);
            }
            finally
            {
                conn.Close();
                Console.WriteLine("------------over----------");
            }
        }谢谢大家!