save colors in DB

[nickske80]

Hello everybody,

I am planning to add a feature to my program where I want the user to be able to choose some colors and fonts for his forms.
(background, color of the fonts, ...)

I use a access DB to save everything.
But I can 't seem to store a color in a DB and retrieve it so it can be used again as a color.

What kind of datatype should I use?

Any help would be appreciated.

To search or to post - that is the question.
To search first and to post later. THAT is the answer.

 

[nomi2000]

Hi
You can save both Font and Color as string and then later can use as
e.g
button1.Font = new Font ("Courier", 10, FontStyle.Bold);
button1.backColor=StringToColor("Red&quot

Public Function StringToColor(ByVal s As String) As Color
Return CType(TypeDescriptor.GetConverter(Type.GetType(Color)).ConvertFromString(s), Color)
End Function

Regards
Nouman

Nouman Zaheer
Software Engineer
MSR

 

[nickske80]

thanx for the reply nomi.

But vb.net doesn 't seem to know the 'TypeDescriptor' - object.

Is there any way i can add it to my project?



To search or to post - that is the question.
To search first and to post later. THAT is the answer.

 

[nomi2000]

You have to import
Imports System.ComponentModel
For StringToColor to run
also the correct syntax for StringToColor is
Public Function StringToColor(ByVal s As String) As Color
Return CType(TypeDescriptor.GetConverter(GetType(Color)).ConvertFromString(s), Color)
End Function

Regards
Nouman


Nouman Zaheer
Software Engineer
MSR