Dynamic properties via CallByName

[aas4mis]

Is it possible to assign control properties from a SQL Server table? This is the closest i've been able to come. It errors out due to the fact i'm passing a string and not the correct property type. Any way to implicitly convert the string to the correct property type? Possibly be getting the correct type from the "Name" value? Just thinking out loud.

As always, thanks to the scripts community for your help (I mean bytes. :) )

    Private Sub btnButton3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnButton3.Click
        Dim conString = ConfigurationManager.ConnectionStrings("conStringDFRE")
        Dim con As New SqlConnection(conString.ConnectionString)
 
        Dim dsProperties As New DataSet
        Dim sdaProperties As New SqlDataAdapter("SELECT Name, Value FROM tbl_Control_Records", con)
 
        sdaProperties.Fill(dsProperties, "tbl_Control_Records")
 
        con.Close()
 
        Dim Name As String
        Dim Value As String
 
        'BackColor
        Name = dsProperties.Tables(0).Rows(0).ItemArray(0)
        'DarkBlue
        Value = dsProperties.Tables(0).Rows(0).ItemArray(1)
 
        'MsgBox("Name: " & Name & vbCrLf & "Value: " & Value)
        'txtTextBox1.BackColor = DarkBlue
 
        'This does not work
         CallByName(txtTextBox1, Name, CallType.Set, Value)
        'This works!
         CallByName(txtTextBox1, Name, CallType.Set, DarkBlue)
 
 
    End Sub
 

[aas4mis]

I've also tried the following. Same issue, need to get property type and cast before inserting "Value".

Any words of wisdom would be appreciated. Thanks!

        'Doesn't work
        txtTextBox1.GetType().GetProperty(Name).SetValue(txtTextBox1, Value, Nothing)
        'Works
        txtTextBox1.GetType().GetProperty(Name).SetValue(txtTextBox1, DarkBlue, Nothing)
 

[Rabbit]

The Color.FromName method of the System.Drawing namespace let's create a color structure from a string.

[aas4mis]

Thanks Rabbit, I'm not at my work pc at the moment. Do most objects have a FromName method? My sql table will be feeding a lot of properties if so.

[Rabbit]

I'm not sure if all of the objects have it. I just looked up the structure on the online documentation and browsed the methods that were available.

[Frinavale]

What does the CallByName method do??

You need to set the value with the right Type.
If you are setting the Foreground of the TextBox, then you need to supply the Foreground property with the correct type (a Color).

This means that you have to know what type of object needs to be created to set the property and you need to populate that object with the value stored in the database.

-Frinny