C#

using System.ServiceProcess;
using System.Configuration.Install;
using System.Collections;

            /// <summary>
            /// TODO: Is the service is existed and return true or false.
            /// </summary>
            /// <param name=" NameService ">Name of the windows service.</param>
            /// <returns>If the service is existed then return true,or return false.</returns>
            private bool isServiceIsExisted(string NameService) 
            {
                ServiceController[] services = ServiceController.GetServices();
                foreach (ServiceController s in services) 
                {
                    if (s.ServiceName.ToLower() == NameService.ToLower()) 
                    {
                        return true;
                    }
                }
                return false;
            }

            /// <summary>
            /// TODO: Install windows service.
            /// </summary>
            /// <param name="stateSaver">Collection(default is Null)</param>
            /// <param name="filepath">Full path of the windows service file</param>
            private void InstallmyService(IDictionary stateSaver, string filepath)
            {
                AssemblyInstaller AssemblyInstaller1 = new AssemblyInstaller();
                AssemblyInstaller1.UseNewContext = true;
                AssemblyInstaller1.Path = filepath;
                AssemblyInstaller1.Install(stateSaver);
                AssemblyInstaller1.Commit(stateSaver);
                AssemblyInstaller1.Dispose();
            }
            /// <summary>
            /// TODO: Uninstall windows service.
            /// </summary>
            /// <param name="filepath">Full path of the windows service file</param>
            private void UnInstallmyService(string filepath)
            {
                AssemblyInstaller AssemblyInstaller1 = new AssemblyInstaller();
                AssemblyInstaller1.UseNewContext = true;
                AssemblyInstaller1.Path = filepath;
                AssemblyInstaller1.Uninstall(null);
                AssemblyInstaller1.Dispose();
            }

/// <summary>
/// TODO: Start windows service.
/// </summary>
/// <param name="name">The name of windows service.</param>
/// <returns>If success return true,or return false.;</returns>
private bool StarmyService(string name)
{
    ServiceController sc = new ServiceController(name);
    if (sc.Status == ServiceControllerStatus.Stopped || sc.Status == ServiceControllerStatus.StopPending
            )
    {
        sc.Start();
        sc.WaitForStatus(ServiceControllerStatus.Running, new TimeSpan(0, 0, 10));
    }
    else
    {
    }
    sc.Close();
    return true;
}

/// <summary>
/// TODO: Stop windows service.
/// </summary>
/// <param name="name">The name of windows service.</param>
/// <returns>If success return true,or return false.;</returns>
private bool StopmyService(string name)
{
    ServiceController sc = new ServiceController(name);
    if (sc.Status == ServiceControllerStatus.Running ||
        sc.Status == ServiceControllerStatus.StartPending)
    {
        sc.Stop();
        sc.WaitForStatus(ServiceControllerStatus.Stopped, new TimeSpan(0, 0, 10));
    }
    else
    {
    }
    sc.Close();
    return true;
}

/// <summary>
/// TODO: Is the windows service running.
/// </summary>
/// <param name="name">The name of windows service.</param>
private bool IsRunning(string name)
{
    bool IsRun = false;
    if (!isServiceIsExisted(name)) // this function was named previously.
    {
        return false;
    }
    ServiceController sc = new ServiceController(name);
    if (sc.Status == ServiceControllerStatus.StartPending ||
        sc.Status == ServiceControllerStatus.Running)
    {
        IsRun = true;
    }
    sc.Close();

    return IsRun;
}

<br />
using System;<br />
using System.Collections.Generic;<br />
using System.Text;<br />
using System.Diagnostics;<br />
using System.Runtime.InteropServices;<br />
<br />
namespace hook<br />
{<br />
    class Program<br />
    {<br />
        private const int WH_KEYBOARD_LL = 13;<br />
        private const int WM_KEYDOWN = 0x0100;<br />
        private static LowLevelKeyboardProc _proc = HookCallback;<br />
        private static IntPtr _hookID = IntPtr.Zero;<br />
<br />
        static void Main()<br />
        {<br />
            _hookID = SetHook(_proc);<br />
            Application.Run();<br />
            UnhookWindowsHookEx(_hookID);<br />
<br />
        }<br />
<br />
        private static IntPtr SetHook(LowLevelKeyboardProc proc)<br />
        {<br />
            using (Process curProcess = Process.GetCurrentProcess())<br />
            using (ProcessModule curModule = curProcess.MainModule)<br />
            {<br />
                return SetWindowsHookEx(WH_KEYBOARD_LL, proc, GetModuleHandle(curModule.ModuleName), 0);<br />
            }<br />
        }<br />
<br />
        private delegate IntPtr LowLevelKeyboardProc(int nCode, IntPtr wParam, IntPtr lParam);<br />
<br />
        private static IntPtr HookCallback(int nCode, IntPtr wParam, IntPtr lParam)<br />
        {<br />
            if ((nCode >= 0) && (wParam == (IntPtr)WM_KEYDOWN))<br />
            {<br />
                int vkCode = Marshal.ReadInt32(lParam);<br />
                if (((Keys)vkCode == Keys.LWin) || ((Keys)vkCode == Keys.RWin))<br />
                {<br />
                    Console.WriteLine("{0} blocked!", (Keys)vkCode);<br />
                    return (IntPtr)1;<br />
                }<br />
            }<br />
            return CallNextHookEx(_hookID, nCode, wParam, lParam);<br />
        }<br />
<br />
        [DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = true)]<br />
        private static extern IntPtr SetWindowsHookEx(int idHook, LowLevelKeyboardProc lpfn, IntPtr hMod, uint dwThreadId);<br />
<br />
        [DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = true)]<br />
        private static extern bool UnhookWindowsHookEx(IntPtr hhk);<br />
<br />
        [DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = true)]<br />
        private static extern IntPtr CallNextHookEx(IntPtr hhk, int nCode, IntPtr wParam, IntPtr lParam);<br />
<br />
        [DllImport("kernel32.dll", CharSet = CharSet.Auto, SetLastError = true)]<br />
        private static extern IntPtr GetModuleHandle(string lpModuleName);<br />
<br />
    <br />
    <br />
    }<br />
}<br />
<br />

obarahmeh wrote:

SecondDataTable= FirstDataTable;

Microsoft SQL Server 2008 Management Objects
X64 Package (SharedManagementObjects.msi) - 3895 KB

c:\Program Files\Microsoft SQL Server\100\SDK\Assemblies

d@nish wrote:

Just make sure you have correct files.