Dealing with Dynamic Databases/Datasets ** Resolved **

[Carnifex]

I have set up an application to use a dynamic database in where it only knows 1 table and 2 primary keys exist (When the database is much larger than this). It's loading the database and values correctly, however, I need to allow another external component to communicate with the dataset.

I would like to use Properties as they are the most intuitive feature to use. However, you are unable to pass parameters to a property. (You can pass 1 to a get, but the set already has it's parameter taken by the value being passed to it)

So properties won't work here.

One option is having 2 seperate functions. GetValue, SetValue. Which are easy enough to implement but I view as being messy.

Are there any other options?

[Pirate]

If your functions in a class obj , Did you try using Consturctors if this would help you ?

[Carnifex]

Hmm. Don't think this will help too much, might have to resort to using functions due to the complexity of finding data based on passed values.

[Edneeis]

A property can have parameters on both get/set:

Public Class PropTest
 
    Private _Names() As String = {"Ed", "Cookie", "Mike"}
 
    Public Property Name(ByVal index As Integer) As String
        Get
            Return _Names(index)
        End Get
        Set(ByVal Value As String)
            _Names(index) = Value
        End Set
    End Property
 
End Class
 
'syntax
        Dim pt As New PropTest
        pt.Name(1)="YourNameHere"
        MessageBox.Show(pt.Name(1))

[Carnifex]

Thanks Edneeis, worked a charm, didn't even think about the parthensis beside the property name. duh.