Creating Pie-Chart From Telerik RadChart In Wpf

Drag and Drop A radChart Control in your Xaml file
 <telerik:RadChart Name="radChartDemo" Width="400" Height="400" HorizontalAlignment="Left" VerticalAlignment="Top" />

In Xamal.cs Create User defined method LoadChart() like this-

        private void loadChart()
        {
            DataTable tbl = new DataTable();
            DataColumn col = new DataColumn("Value");
            col.DataType = typeof(int);
            tbl.Columns.Add(col);
            col = new DataColumn("ExcerciseType");
            col.DataType = typeof(string);
            tbl.Columns.Add(col);

            tbl.Rows.Add(new object[] { 30, "ExerciseA" });
            tbl.Rows.Add(new object[] { 60, "ExerciseB" });
            tbl.Rows.Add(new object[] { 10, "ExerciseC" });


            SeriesMapping seriesMapping = new SeriesMapping();
            seriesMapping.SeriesDefinition = new PieSeriesDefinition();

            ItemMapping itemMapping = new ItemMapping();
            itemMapping.DataPointMember = DataPointMember.YValue;
            itemMapping.FieldName = "Value";
            seriesMapping.ItemMappings.Add(itemMapping);

            itemMapping = new ItemMapping();
            itemMapping.DataPointMember = DataPointMember.LegendLabel;
            itemMapping.FieldName = "ExcerciseType";
            seriesMapping.ItemMappings.Add(itemMapping);

            radChartDemo.SeriesMappings.Add(seriesMapping);

            //RadChart1.DefaultSeriesDefinition = new PieSeriesDefinition();
            radChartDemo.ItemsSource = tbl;

        }
call LoadChart() method in Class constructor and you will see a pie chart at runtime.

Creating A Window Service in C#

To Create A window Service Just Go To Your Visual Studio Click On New projects Select Windows Option from Left Side and select Window Service from Right side window

 

When You will Go to Code View You will Find The Code window like

Create A new Class in coding called Window Service which will inherite installer class.

 [RunInstaller(true)]
    public class WindowsServiceInstaller : Installer
    {

        public WindowsServiceInstaller()
        {
            ServiceProcessInstaller serviceProcessInstaller = new ServiceProcessInstaller();
            ServiceInstaller serviceInstaller = new ServiceInstaller();

            //# Service Account Information
            serviceProcessInstaller.Account = ServiceAccount.LocalSystem;
            serviceProcessInstaller.Username = null;
            serviceProcessInstaller.Password = null;

            //# Service Information
            serviceInstaller.DisplayName = "Your Service Name";
            serviceInstaller.StartType = ServiceStartMode.Automatic;

            // This must be identical to the WindowsService.ServiceBase name
            // set in the constructor of WindowsService.cs
            serviceInstaller.ServiceName = "Your Service Name";

            this.Installers.Add(serviceProcessInstaller);
            this.Installers.Add(serviceInstaller);
        }

    }

Create Your user defined method MyMethod() do your stuff there and call it from OnStart() Method.

Now For Installing the service open VS Command Prompt.and go to path where this service exe file is present.it will be in bin\debug folder.

Write The command for Installing InstallUtil /i yourServiceName.exe 

when you will execte this command you will find window like

Now Your Service will be created you can see from service Command from RUN

command for Uninstalling The service InstallUtil /u YourServiceName.exe

 

How To Make a Job In sql Server

Go To Sql serever 2008. For Creating a new job Go to Sql Server Agent and Job folder Right Click on that Click on New job

When You Will Click On New Job You Will Find A window Like-

 

Give The name of job and description of Job.Then Click On Steps Option on left Side Window

 

Click On New Button.You Will find This Window

Just Give Step name.Choose Database From Drop Down Write Your Querry In the command Multiline textbox or call sp From there and ckick on ok.After Clicking On Ok Just select Schedules option from left side you will find this window. click on new.

 

you will find this window

 

Just Set Time And day to run the Job.and click on ok.Your Job Is Completed

 

How To Send EMail From Sql Server

exec msdb.dbo.sp_send_dbmail @profile_name='Profile From which U want To send Mail',
@recipients='Email Id To Which U Want To Send Email',
@subject= 'Your Subject',
@body='Your Message'

Order Of Elements in Hash Table

Remember that a Hashtable represents a collection of key/value pairs that are organized based on the hash code of the key, and when a element is added to the Hashtable it's stored based on the hash code of the key, and the elements don't preserves the order based in their insertion to the Hashtable's "bag".
As we Know that when an element is added to the Hashtable, the element is placed into a bucket based on the hash code of the key. We can get the Hash Code with GetHashCode() method.
If you want that the items contained in a collection always be "sorted" you need to use a SortedList instead a HashTable. If you don need the items sorted then use a HashTable, beacuse it's more faster than a SortedList obtaining a value from their "bag". For ex-


class Program
    {
        static void Main(string[] args)
        {

            Hashtable ht = new Hashtable();
         
            ht.Add("ht01", "DotNetGuts");
            ht.Add("ht02", "EasyTutor.2ya.com");
            ht.Add("ht03", "DailyFreeCode.com");
            Console.WriteLine("\nht01 hash code= " + "ht01".GetHashCode().ToString() + "\n\n" +
                "ht02 hash code= " + "ht02".GetHashCode().ToString() +
                "\n\n" + "ht01 hash code= " + "ht03".GetHashCode().ToString() + "\n\n");
            Console.WriteLine("..........Hash Table Items..............\n");
            foreach (DictionaryEntry entry in ht)
            {
                Console.WriteLine("{0}\t{1}\n", entry.Key, entry.Value);
            }

            Console.ReadKey();
            Console.ReadLine();
        }
}

So If you want that the items contained in a collection always be "sorted" you need to use a SortedList instead a HashTable.

Diffrent Algorithams are used to generate the hash code one of the algorithim is MD5 Hash.


        public static string CalculateMD5Hash(string input)
        {
            // step 1, calculate MD5 hash from input
            MD5 md5 = System.Security.Cryptography.MD5.Create();
            byte[] inputBytes = System.Text.Encoding.ASCII.GetBytes(input);
            byte[] hash = md5.ComputeHash(inputBytes);

            // step 2, convert byte array to hex string
            StringBuilder sb = new StringBuilder();
            for (int i = 0; i < hash.Length; i++)
            {
                sb.Append(hash[i].ToString("X2"));
            }
            return sb.ToString();
        }