I have a SQL Table with 2 columns, a type and a value, how can I set something up where the property is the type and the value can be set by the user? Do I basically just go through every item in the table (only 20 rows) and make a property for each one such as:
Public Shared Property SettingsRow1() As Integer
Get
Return ' call the database here for the info?
End Get
Set(ByVal value As Integer)
' call the update query in here?
End Set
End Property
Is this the right way to do it? is there a better way? what about performance?
...
Go to the complete details ...