在C#里面代码如下:
foreach (DictionaryEntry myDE in SQLStringList)
{
string cmdText = myDE.Key.ToString().Split('|')[0];
OracleParameter[] cmdParms = (OracleParameter[])myDE.Value;
PrepareCommand(cmd, conn, trans, cmdText, cmdParms);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
然后转成在VB.NET里面写遇到下面问题:
For Each myDE As DictionaryEntry In SQLStringList
Dim cmdText As String = myDE.Key.ToString().Split("|")(0)
Dim cmdParms() As OracleParameter = myDE.Value //这里myDE.Value为Object对象,包含键/值对的值
PrepareCommand(cmd, conn, trans, cmdText, cmdParms)
Dim val As Integer = cmd.ExecuteNonQuery()
cmd.Parameters.Clear()
Next
问题就是在VB.NET里面怎样把myDE.Value强制转化为OracleParameter() ??求大神指教!!
------解决思路----------------------
Dim cmdParms As OracleParameter() = DirectCast(myDE.Value, OracleParameter())