在MySql裡面查詢有記錄，但是調用程式執行就沒有記錄

1、Select * From chuang_AgentInfo Where UserName='成都'  --在MySql工具裡面查詢有記錄

2、以下代碼查詢上面語句，沒有記錄table.row.count為0
MySqlCommand thisCommand = new MySqlCommand();
thisCommand.CommandTimeout = 0;

// make sure connection is open
MySqlConnection con = new MySqlConnection(vStrConn);
try
{
    con.Open();
    thisCommand.Connection = con;
thisCommand.CommandText = SQL;

    MySqlDataAdapter thisAdapter = new MySqlDataAdapter();
    thisAdapter.SelectCommand = thisCommand;
    DataTable table = new DataTable();
    thisAdapter.Fill(table);
    return table;
}

3、以上代碼查詢 Select * From chuang_AgentInfo 有記錄，可以查到。