HostGator - A Popular Web Hosting

Domain and hosting

This is the website that allow you to host your personal website or your team website. you can find more available  domain name in this website. this is the best website to explore and purchase a domain name.
please, check the link below to see how it work.

Select Data from one Table not in another SQL Server

 Select data from one table not in another SQL Server

Method 1:

SELECT t1.name
FROM table1 t1
LEFT JOIN table2 t2 ON t2.name = t1.name
WHERE t2.name IS NULL

 Method 2:

SELECT name
FROM table2
WHERE name NOT IN
    (SELECT name 
     FROM table1)

Method 3:

SELECT name 
FROM table2 
WHERE NOT EXISTS 
    (SELECT * 
     FROM table2 
     WHERE table1.name = table2.name)

Method 4:

SELECT name
FROM table2
WHERE name NOT IN
    (SELECT name 
     FROM table1)

Method 5:

select id, name from table1
minus
select id, name from table2

Crystal Report - How to fix error Could not load file or assembly

How to fix error:
Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win64_x64\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.

In this tutorial we are going to do in Manual mode:
So, Let go into app.config file:
 

In app.config file
    <startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>

Replace with

    <startup useLegacyV2RuntimeActivationPolicy="true"><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>

This may help you. Thanks

DJI Drone - Coold Drone for Shooting Video

DJI Drone

DJI drone is a professional drone with 4K video recording camera. It packed with long batter life and long distant to remote. It really stably for sport and you can change many lens you want.
check the link below to see it specification and feature.

Auto Shutdown Your PC

Auto Shutdown with Command Prom

If you want to shutdown your personal computer automatically when you are out or far away from your pc for a while, you may consider how can you shutdown your pc in a limited time.

You won't be worry anymore. check the link in below and you will see how to use Command Prom to shutting down your pc automatically.

 

Let see my example below that I want my Computer Auto Force Shutdown in 6000s letter.

1- Hold Window Key + R

2- Type: shutdown -s -f 6000

*Note that: -s mean shutdown local machine; and -f mean forces running applications to close.

ASP.net - Set Gridview Column Width Dynamically in C#, VB.NET

Asp.net - Set Gridview Column Width Dynamically in C#, VB.NET

Check out this code to fix the static web layout to dynamic web layout using Asp.Net and Programming language C# or VB.Net.

http://www.aspdotnet-suresh.com/2013/01/aspnet-set-gridview-column-width.html