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
Return ' call the database here for the info?
Set(ByVal value As Integer)
' call the update query in here?
Is this the right way to do it? is there a better way? what about performance?
View Complete Post