Changing Static Themes to Dynamic Themes Using C# With SQL Server

CREATE TABLE [dbo].[PROG_COLOR](
      [colorMainval] [varchar](15) NULL,
      [colorPanalval] [varchar](15) NULL,
) ON [PRIMARY

insert into [PROG_COLOR] ([colorMainval],[colorPanalval])values('#c0c0ff','#8080ff')

public static SqlConnection GetDBConnection()
    {
     SqlConnection conn = new SqlConnection(
     "Data Source=.\\CRMIS;Initial Catalog=PSH;User ID=sa;Password=###ReconcilE123");
     return conn;
    }

Step 11

Now add the following code for the btnMain click event. That will define two variables of string type colorMain and colorPanal; then, it creates the object color from the class ColorDialog that C# built in the class. That object will open the color plate, allowing the user to select the main color. After selecting the color, we must convert the string into type "x" and then save it in the colormain variable.

In the next line, we must get the substring of the colormain and concatenate the "#" sign to it.

In the last line, it will change the color of the button that is selected from the color plate.

Now we must write the same code for the btnpanal click event.

Step 12

Now write the following code for the btnsave click event. It will update the selected color in the database using an updated SQL statement.

Step 13

Now write the following code in the btndef click event. This updates the default color.

Step 14

Now write the following code in the btnSys click event. This updates the System color in the database.

Step 15

Now write the following code in the btnExit click event.

Step 16

Now write the following code in form1 for the btnchange click event. This creates the object of form frmChangeColor and then shows the form.

Step 17

Now write the following code in form1 on the btnExit click event.

Step 18

It's time to write your final code to change your application's color; in our case, this will change the form 1 background and panels colors.

As in the following, we must add one more public static function in the Main class to fetch data from the database.

Write the following code in the form1 MouseClick event. You can use the form load event as well.

After executing the program, you must click on the form; it will show the following results.

On clicking the change button, it will change the color of the form.

Know you must click the save button and click the exit button. Now you must click on form 1 to see the results.

Conclusion

This article taught us how to Change Static themes to Dynamic themes using C Sharp with SQL Server.