mysql 查询结果，字符串在.net中变成System.Byte[] 解决方法

System.Text.Encoding.UTF8.GetString((System.Byte[])dt.Rows[i]["StoreName"])

取得结果集的存储过程

CREATE DEFINER = 'root'@'localhost'
PROCEDURE etm_chain.P_StoreClientCount(IN P_CreateMonth VARCHAR(7))
BEGIN DECLARE P_StoreName, P_DataBaseName  VARCHAR(50);
  DECLARE strSql                       TEXT;


  DECLARE curs CURSOR FOR
  SELECT storename
       , databasename
  FROM
    c_store;


  DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET P_DataBaseName = NULL;


  SET strSql = '';
  OPEN curs;
  FETCH curs INTO P_StoreName, P_DataBaseName;


  WHILE P_DataBaseName IS NOT NULL
  DO
    IF ifnull(P_CreateMonth,'') = '' THEN
      SET strSql = concat(strSql, 'select count(*) MemberCount ,''', P_StoreName, ''' as StoreName from ', P_DataBaseName, '.member union ');
    ELSE
      SET strSql = concat(strSql, 'select count(*) MemberCount , ''', P_StoreName, ''' ) as StoreName from ', P_DataBaseName, '.member where date_format(createtime,"%Y-%m")=''', P_CreateMonth, ''' union ');
    END IF;
    FETCH curs INTO P_StoreName, P_DataBaseName;
  END WHILE;
  CLOSE curs;
  SET strSql = concat(strSql, 'select 1,1 from c_store where 1=2;');
 
  SET @P_strSql = strSql;
  PREPARE result FROM @P_strSql;
  EXECUTE result;
END