Abundant Code

You are here: Home / Archives for How to

How to create drop down list in Microsoft Excel ?

by 1 Comment

This article will explain how to create drop down list in Microsoft Excel.

Drop down list is one of the most commonly used ways in excel to allow users to select the items from the predefined list . The drop down list in Excel allows the users to select only the valid entries.

How to create drop down list in Microsoft Excel ?

Follow the below steps to create drop down list in Microsoft Excel

1. Enter the following values in the Column A of the worksheet.

Abundant Code

Programming tutorials

Excel combobox

Excel Dropdownlist

Excel tips and tricks

How to create drop down list in Microsoft Excel ?

2. Use a different worksheet . Select the cell where you want the drop down list to appear. For example , I select “C1”.

3. In the Data Menu , click “Data Validation” Dropdownlist and then click “Data Validation”.

How to create drop down list in Microsoft Excel ?

4. Specify the source of the data for the dropdown list item in the Data Validation Dialog. In the Validation Criteria , select Allow “List” and specify the range of values in the source and click OK.

How to create drop down list in Microsoft Excel ?

5. You should now see the Dropdownlist in the selected cell “C1” .

How to create drop down list in Microsoft Excel ?

How to remove leading zeros from a number in JavaScript?

by Leave a Comment

If you want to remove leading zeros from a number in JavaScript , you can use the parseInt() method.

How to remove leading zeros from a number in JavaScript?

Here’s an example demonstrating how you can use parseInt() function to delete leading zeros.

<!DOCTYPE html>
<html>
   <body>
      <script>
         var number1 = parseInt("034", 10);
         document.write(number1);
      </script>
   </body>
</html>

The output of the above program is

34

How to decode a base64 string in C#?

by Leave a Comment

Here’s a sample code snippet demonstrating how you can easily decode a base64 encoded string in C#.

How to decode a base64 string in C#?

var base64EncodedString;//Fill this with your data.
byte[] byteArray = Convert.FromBase64String(base64EncodedString);
string output = Encoding.UTF8.GetString(byteArray);

How to disable editing of items in a combo box in c#?

by Leave a Comment

When working in Win forms using C# and especially when you use the combo box , you would have noticed that by default the user can edit the values inside during the runtime.

How to disable editing of items in a combo box in c# (win forms) ?

Assuming that the combobox name is combobox1 , here the code to get this behavior.

comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;

How to get the AM or PM value from a DateTime object in C# ?

by Leave a Comment

There are times when you might want to get only the string AM or PM from the DateTime object that you have.

How to get the AM or PM value from a DateTime object in C# ?

You can get this by using the format specifiers in the ToString method as shown in the code snippet.

using System;

namespace AbundantcodeApp
{
    class Program
    {
        static void Main(string[] args)
        {
            var Data = 
                DateTime.Now.ToString("tt", System.Globalization.CultureInfo.InvariantCulture);
            
            Console.WriteLine(Data);
            Console.ReadLine();
        }
    }
}

C# program to print the multiplication table of a given number.

by Leave a Comment

Problem

Write a program in Microsoft Visual C# that takes a number as input and prints its multiplication table.

Solution

using System;

namespace AbundantcodeApp
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Abundantcode.com coding sample");
            int number;
            Console.WriteLine("Enter the Number : ");
            number = int.Parse(Console.ReadLine());
            for (int i = 1; i &lt;= 10; i++)
                Console.WriteLine(number + " x " + i + " = " + number * i);         
            Console.Read();
        }
    }
}

Output

Abundantcode.com coding sample

Enter the Number :

5

5 x 1 = 5

5 x 2 = 10

5 x 3 = 15

5 x 4 = 20

5 x 5 = 25

5 x 6 = 30

5 x 7 = 35

5 x 8 = 40

5 x 9 = 45

5 x 10 = 50

C# Program to swap two numbers without using temporary variable

by Leave a Comment

Problem

Write a program in Visual CSharp to swap two numbers using temporary variable and display the result in the console window.

How to swap two numbers in C# without using temporary variable ?

using System;

namespace AbundantcodeApp
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Abundantcode.com coding sample");
            int number1, number2;
            Console.WriteLine("Enter the First Number : ");
            number1 = int.Parse(Console.ReadLine());
            Console.WriteLine("Enter the Second Number : ");
            number2 = int.Parse(Console.ReadLine());
            number1 = number1 - number2;
            number2 = number1 + number2;
            number1 = number2 - number1;
            Console.WriteLine("First Number is " + number1);
            Console.WriteLine("Second Number is " + number2);
            Console.Read();
        }
    }
}

Output

Abundantcode.com coding sample

Enter the First Number :

45

Enter the Second Number :

67

First Number is 67

Second Number is 45

C# Program to swap two numbers

by Leave a Comment

Problem

Write a program in C# to swap two numbers using temporary variable and display the result in the console window.

How to swap two numbers in C# and display it in the Console ?

using System;

namespace AbundantcodeApp
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Abundantcode.com coding sample");
            int number1, number2, temp;
            Console.WriteLine("Enter the First Number : ");
            number1 = int.Parse(Console.ReadLine());
            Console.WriteLine("Enter the Second Number : ");
            number2 = int.Parse(Console.ReadLine());
            temp = number1;
            number1 = number2;
            number2 = temp;
            Console.WriteLine("First Number is " + number1);
            Console.WriteLine("Second Number is " + number2);
            Console.Read();
        }
    }
}

Output

Abundantcode.com coding sample

Enter the First Number :

25

Enter the Second Number :

87

First Number is 87

Second Number is 25

How to get the column names from a SqlDataReader in C#?

by Leave a Comment

There are times when you might want to connect to a database and then get all the column names that was returned in the SqlDataReader object.

How to get the column names from a SqlDataReader in C#?

Here’s a code snippet demonstrating how to do it.

var slqreaderobj = cmd.ExecuteReader();
var columnnames = Enumerable.Range(0, slqreaderobj.FieldCount).Select(slqreaderobj.GetName).ToList();