public static void Test()

        {

            MySqlConnection myconn = null;

            MySqlCommand mycom = null;

            MySqlDataAdapter myrec = null;

            myconn = new MySqlConnection("server = 192.168.1.221;user id = pms; password=Zkhz123456; database=zentao;");

            myconn.Open();

            mycom = myconn.CreateCommand();

            mycom.CommandText = "SELECT `zt_user`.`account` AS `account`,`zt_user`.`realname` AS `realname` FROM `zt_user` AS `zt_user` WHERE `zt_user`.`realname` LIKE CONCAT('%','宋','%')";

            MySqlDataAdapter adap = new MySqlDataAdapter(mycom);

            DataSet ds = new DataSet();

            adap.Fill(ds);

        }