如何从数据库中的JSON中选择并显示为文本

我在oracle和visual.vb之间建立了连接 我在其中执行了关于coracvle的程序 它为我重新运行json 我想将jsons参数显示为.net中的文本

Dim conn As New OracleConnection(constr.ConnectionString)
Dim cmdd As New OracleCommand
If conn.State = ConnectionState.Closed Then conn.ConnectionString = constr.ConnectionString
cmdd.Connection = conn
Try
    cmdd.CommandText = "procedure_here"
    cmdd.CommandType = CommandType.StoredProcedure
    cmdd.Parameters.Add("I_CODE", OracleType.Number).Value = ViewState("Code")
    cmdd.Parameters.Add("old_id", OracleType.Number).Value = old_id
    cmdd.Parameters.Add("new_id", OracleType.Number).Value = new_id
    Dim Paramout As New OracleClient.OracleParameter


    Paramout.Direction = ParameterDirection.Output
    Paramout.DbType = DbType.Int16
    Paramout.ParameterName = "ResultCode"
    cmdd.Parameters.Add(Paramout)
    If conn.State = ConnectionState.Closed Then conn.Open()
    cmdKartex.ExecuteNonQuery()

    returnValue = JsonConvert.SerializeObject(ParameterDirection.Output)

    Return returnValue
评论