mysql 存儲過程調用_mysql-VS2010+MYSQL存儲過程調用出錯

VS2010+MYSQL，

連接字符串

server=**.***.***.**; user id=*; password=*; database=*; pooling=false;charset=gb2312

和Database=*;Data Source=**.***.***.**;User Id=*;Password=*;pooling=false;CharSet=utf8;port=3306

都試過，只要存儲過程查詢結果一用到case when，ifnull，CONCAT這些去處理，那麼在工具中調用該

存儲過程(CALL TEST())沒問題，但是在c#代碼中就報錯，錯誤內容為：指定的索引鍵不在字典中。

請教下大神們這是咋回事呢

於 System.Collections.Generic.Dictionary`2.get_Item(TKey key)

於 MySql.Data.MySqlClient.CharSetMap.GetChararcterSet(DBVersion version, String CharSetName)

於 MySql.Data.MySqlClient.NativeDriver.GetFieldMetaData41()

於 MySql.Data.MySqlClient.NativeDriver.GetFieldMetaData()

於 MySql.Data.MySqlClient.NativeDriver.ReadColumnMetadata(Int32 count)

於 MySql.Data.MySqlClient.MySqlDataReader.NextResult()

於 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

於 MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

於 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

於 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

於 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

於 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

DataSet ds = new DataSet();

MySqlCommand cmd = new MySqlCommand(stroeProcedure, Connection);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddRange(values);

MySqlDataAdapter da = new MySqlDataAdapter(cmd);

da.Fill(ds);

connection.Close();在da.Fill(ds)這就報錯了。。。

SQL 如下，只要用到case when和concat，代碼調用時就報這個錯誤

SELECT C.ORDER_NO ,-- CONCAT(C.ORDER_CANCEL_REASON,'') AS aa-- ,case when C.status=1 then '申請取消'

else 'N/A'

end AS "status"

FROM AREA_T A,GROUP_BUYING_T B,ORDER_T C,PAY_TYPE_T D

WHERE A.AREA_ID = C.AREA_ID

AND B.GROUP_BUYING_ID = C.GROUP_BUYING_ID

AND C.PAY_TYPE_ID=D.PAY_TYPE_ID

AND C.ORDER_NO=V_ORDER_NO