求救，为什么我连接的mysql数据库，插入可以正常插入，但是查询的时候却查不到呢？但是手工添加的数据就可以查的到！！！谢谢哪位大哥、大姐帮我一下吧！！！
代码如下：
            string myConnectionString ="DSN=test;UID=root;PWD=123456";

            OdbcConnection MyConn;
            OdbcCommand MyCmd = new OdbcCommand();

            MyConn = new OdbcConnection(myConnectionString);
            MyConn.Open();
            MyCmd.Connection = MyConn;
                    string mysql= "Select * from student where name = '" + name.Text + "'" ;
                
                    MyCmd.CommandText = mysql.ToString();
            
                    OdbcDataReader result = MyCmd.ExecuteReader(CommandBehavior.CloseConnection);

                    int nResultCount = 0;
                
                    while ( result.Read() )
                    {
                        show.AppendText("您查询"+name.Text+"学生的成绩为：");
                        show.AppendText(result.GetString(2));
                        succ = true;
                        ++nResultCount;
                    }