storing and retrieving colors with database, C# windows forms application

c# database winforms colors color-picker
jello picture jello · Feb 16, 2010 · Viewed 15.5k times · Source

I'm making a windows application with C#. I'm using the color dialog box for the user to select a color. I'd like to store that color in a database, and be able to retrieve it later on, and be able to use that color in the user interface.

What approach would you suggest to me?

Answer

Chase Florell picture Chase Florell · Feb 16, 2010

The best way will be to store the hex color in a database field nvarchar(7) ... the input would be #ffffff as an example. varchar(6) would work just as well, and take up less space in your DB. Just be sure to append the # in your code.

Since you need to convert it to/from a control color, you can use System.Drawing.ColorTranslator.FromHtml(someHexColor)

// Hex to Control Color
var myColor = "#[color from database]";
var myControlColor = System.Drawing.ColorTranslator.FromHtml(myColor);

// Control Color to Hex
var colorBlue = System.Drawing.Color.Blue;
var hexBlue = System.Drawing.ColorTranslator.ToHtml(colorBlue);

Related questions

C# Inserting Data from a form into an access Database

I started learning about C# and have become stuck with inserting information from textboxes into an Access database when a click button is used. The problem I get is during the adding process. The code executes the Try... Catch part …

Read More
Make DbDataReader start reading again from the beginning of the result set

How to make dr.Read(); start reading again from the beginning if a condition is satisfied? Something like: SqlDataReader dr = command.ExecuteReader(); for(int i=0; dr.Read() ; i++){ if(condition ){ //let dr.Read() start reading from the beginning } }

Read More
Is there any framework for Windows Forms, DB driven application development/prototyping?

I'm writing simple database driven application, 80% of functionality is CRUD operations on about 15 tables. Coming from web development background I figured I can cover almost all of these CRUD cases with Rails scaffolding or say Django admins. So I started …

Read More