Problem saving changes in database table Microsoft Visual Studio 2010

ERROR :

“You cannot save changes that would result in one or more error tables being re-created.You can override this behavior by changing your configuration options…” shown in figure 1

 (figure 1)

SOLUTION TO THIS PROBLEM :

Disable “Prevent saving changes that require the table re-creation” 

Step by step guide :

1. Click on Tools menu and then click on Options shown in figure 2

(figure 2)

2. Once you are in the Options menu , click on Database Tools , click on Tables and Database Designers and then untick Prevent saving changes that require table re-creation shown in figure 3

Read More →

05:18

database, Visual_studio

Easy Steps to Use Laptop as Wi-Fi Hotspot

Easy Steps to Use Windows 8 Laptop as Wi-Fi Hotspot

There are 3 ways to flip your laptop equipped with Microsoft Windows 8 into a Wi-Fi hotspot. One amongst them needs that you just dig into the command prompt, a task several feel unwilling or unprepared to handle.

Here’s what you’ve have to do, based on Easy Steps to Use Windows 8 Laptop as Wi-Fi Hotspot.

Things that you may ought to share your net with different Wi-Fi Devices:

a) A working net connection
b) An in-built or External WiFi adapter that supports the sharing ability for net connection
c) A laptop

Finding out: that whether or not your Wi-Fi card

supports sharing

Let’s conclude that whether or not your WiFi card supports sharing or not for this head to search and open up CMD within the administrator mod. For gap CMD in administrator mode you would like to right click it so open the cmd in “Administrator Mode“.

After you have got opened cmd write the subsequent command and appearance for the factor mentioned within the screen shot that whether or not it’s written affirmative or no. It it’s affirmative then you can prolong “It means you can alter the hotspot and might share your net connection.”

Command to envision Sharing Compatibility of WiFi network for windows 8

Command: netsh wlan show drivers

Check sharing ability of the WiFi card

Creating The Wi-Fi Hotspot

Don’t shut the cmd as you are planning to use cmd once more. Following is that the program line to make the hotspot, set the password and name it as you would like too.

netsh wlan set hostednetwork mode=allow ssid=mywifi key=abcd

The higher than is that the command to make the hotspot. Replace “mywifi” with the specified network name and replace “abcd” with the specified arcanum which is able to be utilized by the others to attach to the hotspot.

Creating the hotspot in windows 8

Press the enter and hotspot will be created.

Starting the Wi-Fi Created Hotspot in Windows 8

Now you would like to begin the hotspot, once more you are require the cmd and also the cmd should run within the administrator mode. Write the subsequent command within the cmd to begin the higher than created hotspot.

Command: netsh wlan begin hostednetwork

Enabling WiFi hotspot in windows 8

Press enter and also the hotspot are created and can be ascertainable by the opposite devices similarly.

Sharing the operating net reference to the windows

eight Wi-Fi hotspot

All Right, everything has been done and currently you simply ought to offer your laptop’s net connection’s access to the created hotspot, so any user connected to the hotspot can have the net access additionally. For this reason you may ought to open the windows networking and sharing center.

Windows 8 searching the network and sharing center

Open up the network and sharing center, so head to “Change adapter settings” on the highest left pane. Click that to open. Here you may see your created hotspot affiliation and the affiliation that you would like to be shared with the hotspot for the net sharing. The created hotspot affiliation has the star with the name. You would like to open the properties of the affiliation that you would like to be shared with the hotspot.

Networking adapters windows 8

Right click and open the properties of the affiliation that has {the net|the web|the net} access and is that the original internet affiliation of the laptop computer, whether or not it’s a dialup, native space network or something like that. Head to the sharing tab within the properties so tick the “Allow different network users to attach through this computer’s internet connection” and within the drop below, choose the hotspot affiliation that is “Local space affiliation *21”, so hit ok. Re-dial the affiliation as an alternative reconnect the net affiliation if required.

Sharing net reference to hotspot

That was it and you are done, the password to attach with the hotspot is that the same that you used whereas fixing hotspot in the cmd. If you can’t still share the net then reason are that firewall or an antivirus is inflicting the matter, attempt disabling the firewall if you trust the person with whom you are sharing the hotspot.

Using these Easy Steps to Use Windows 8 Laptop as Wi-Fi Hotspot you can use WiFi connection on any device like tablet or your mobile phone.

http://www.thegeekyglobe.com/easy-steps-to-use-windows-8-laptop-as-wi-fi-hotspot.html

Read More →

01:50

Network

Free Website Malware and Security Scanner

Free Website Malware and Security Scanner

• http://sitecheck.sucuri.net/
• http://www.quttera.com/website-malware-scanner

Read More →

23:25

Website Security

Coming Soon Templates

http://www.freshdesignweb.com/free-coming-soon-templates.html

Read More →

05:31

Coming_Soon

Creating an Under Construction or Coming Soon page in Magento

When building a website, you may not want random visitors snooping your pages until you are ready for them. Even while some programs allow you to build your site on your local computer and then publish when you are finished, you still may want to test your site on the live server before opening to the public. In this case, you may want to place an "Under Construction" or "Coming Soon" page in place.

The problem lies with how your hosting server looks for the first page of your site, also called the index page. The server looks for pages that are named index.htm, index.html, index.php, and default.htm, in that order. If it finds a file with one of those names, it places that as the landing page of your website. Website design programs most often create an index.html or index.php page. When publishing your site, even for testing, it is likely that the first page will begin to display to the public. This article will guide you on how to create and set up a placeholder page so that you can work on your site in the background.

How to create a custom Under Construction/Coming Soon page

1. Log into cPanel.
2. Enter the File Manager. Be sure to navigate to the root folder for the domain you are working with. If it is the primary domain, use public_html.
3. Click on New File, an icon found in the toolbar at the top of the page.
4. Next, give the file a name. Our example will be named comingsoon.html. Click on the Create New File button to complete its creation. Note this simply creates an empty file.
   
5. Now we need to edit the empty file. Highlight the filename and then click on HTML Editor. This allows you to create the page visually, no coding needed. You can make it as fancy or simple as you wish. In our example we will make it very simple.
   
6. Once you have designed your page, click on the Save button in the upper left of the tool bar. It appears as a floppy disk.
7. Now that you have created the page, you need to set the filen ame as your default for your website. Those instructions are found in our article on How to change your default index page in .htaccess. Below is a screenshot of how the page will display on the web once that is completed.
    

Source  : http://www.inmotionhosting.com/support/edu/cpanel/cpanel-file-manager/coming-soon-page

OR

Step 1 - Create an under Construction HTML page

Create an index.html under construction page
Upload this page to your root magento directory
(you have already made that backup, right>?)

Step 2 - Update your .htaccess file

Add the following line to the top of your .htaccess file in the root directory of your magento installation

DirectoryIndex index.html index.php

Also, upload this file to your root magento directory
(rest assured if anything goes wrong, you’ve got that backup!)
This tells the system to use your index.html file before the index.php, this is essential, otherwise your site will show as usual.

Step 3 - Test your front end and continue working

Your frontend should now show the under construction / maintenance page.
To continue working on your site, simply navigate to your frontend and add /index.php
e.g.
www.yourdomainname.com - goes to the under construction HTML page
www.yourdomainname.com/index.php - goes to your website for development purposes
Once everything is backup and running, simply add a hash (#) to the command line in your htaccess file:
#DirectoryIndex index.html index.php

Source : http://www.voodish.co.uk/articles/magento-under-construction-maintenance-page/

Read More →

05:26

Magento

How to change your default Index page in htaccess in Magento-Cpanel

The server looks for specifically named files as the first page of your website, also known as the index page. The default order of index file names our particular servers look through is index.htm, index.html, index.php, and finally default.htm. You can change the name of the index file your account looks for by altering the .htaccess file. Perhaps you want to have a specific custom name for your index file or maybe you are migrating from another host and the index page is named differently. This way your internal links will not be broken by renaming the index file.

What is an htacces file?

The .htaccess file is a hidden text file within your hosting account that can be very powerful. It is designed so that you can modify it to change the behavior of your website that normally would take higher access beyond your account. It acts as a liaison between your domain and the server and can perform many functions.
Learn more about htaccess

Changing your default index file via htaccess

1. First, you will need to log into your cPanel to access the htaccess file.
2. Find the Files category and click on the File Manager icon.
   
3. A popup box will appear. For the primary domain, click on the Web Root radio button. For addon domains, click on the dropdown and find your desired addon domain name. Be sure the checkbox next to Show Hidden Files is checked. Click the Go button to enter the File Manager.
   
4. You should now be in the root folder of the domain you chose. Look for the .htaccess file and right click on it. This brings up a menu. Find and click on the Edit option. If you get a popup box, simply find and click the Edit button in the lower right corner to continue to the editor.
   
5. You are now in the htaccess editor. Paste the following code at the top of the page to configure your desired index page. In our example below, we decided to make the index page of our folders named first.html.
   
   #Alternate default index page
   DirectoryIndex first.html
   You can also list more than one file in the configuration. The file will be read left to right and check for them in that order. In this example, we add index.htm, index.html, and index.php to the list. First the server will check for first.html, if it does not find a file with that name, it continues to index.htm and so on.
   #Alternate default index pages
   DirectoryIndex first.html index.htm index.html index.php
6. Be sure to hit the Save Changes button in the upper right corner to save your new htaccess configuration.

Souce From : http://www.inmotionhosting.com/support/website/htaccess/htaccess-change-index-page

Read More →

05:24

Magento

Display Website with Menu Structure on Google Result Page

• http://www.websitemagazine.com/content/blogs/posts/archive/2011/08/23/google-s-extended-sitelinks-exposed.aspx
• http://www.hochmanconsultants.com/articles/sitelinks.shtml
• https://www.google.com/webmasters/tools/home 

Google’s new extended Sitelinks are sending Webmasters scrambling to find out how they too can secure more virtual real estate on the world’s most popular search engine – now estimated at well over 60-percent market share. So, are there any tricks to making sure your site is returned with the highly coveted extended Sitelink? Yes, there are. Let’s expose the secrets to getting extended Sitelinks.

It is difficult to know what signals Google uses in its Sitelinks algorithm, but a close inspection of the search result pages for queries which return an extended Sitelinks – and a thorough look at the Google Webmaster Guidelines – do provide us an opportunity to make some reasonable assumptions. There are in fact several signals that websites should consider addressing if the allure of extended Sitelinks is too much to ignore.

KNOW THE MOST POPULAR SITE SECTIONS

Based on the current research, it seems that whether Google includes Sitelinks is heavily dependent upon the behavior of users. Since search results page listings include tracking info, Google can/could easily determine which pages or categories of your site are most frequently visited. Thanks to this click stream data, Google is able to improve its search results and give users direct access to the sections of your Web property which are of the greatest interest or importance. Google generates sitelinks automatically but with a little strategic thinking, it is possible (somewhat) to influence extended sitelinks. If you don't already know the most popular sections of your website, it's time to dig into your website analytics.

THE NAVIGATION IMPERATIVE

Perhaps most noteworthy within the Webmaster Guidelines is the recommendation to make a site with a clear hierarchy and text links. If Google cannot understand what sites or individual sub-pages are about, it is unlikely that extended Sitelinks will appear. To increase the likelihood of extended Sitelinks appearing for your site on important queries, consider rethinking navigation.

For example, consider refining the navigation to include but a handful of the most important links. Fewer navigation choices will help you funnel users to specific destinations, and giving Google enough click stream data to make some choices on your site’s behalf. Take a look at Apple.com’s navigation, and then at the extended sitelinks Google has returned on the search results pages, and tell me that there is no correlation between navigation links and the sitelinks that returned.

PAGE TITLES & PAGE NAMES PROVIDE CLEAR SIGNALS

Google needs not look very far for perhaps the strongest signal of a page’s worthiness to be included in Sitelinks. SEOs should focus much of their energy on the quality of page titles (keeping them brief but accurate) and doing the same for the actual file names of pages as both are strong signals that specific pages are of importance. Take a look at the Ameritrade example below. See how the titles are short in length? That is certainly one good indicator. But dig deeper into the “Rates & Fees” Sitelink and you’ll see that the page itself is named ratesfees.html. If the aim is to obtain extended Sitelinks, considering a site’s naming conventions (titles and pages) is a vitally important task.

ANCHOR TEXT OF INTERNAL AND EXTERNAL LINKS

Another opportunity is to ensure that the internal links within your site and external links pointing to your site from third-party websites use an appropriate keyword anchor text. The aim should be to identify which pages are most representative of the site in question, and to set about acquiring a mixture of links with the keyword or key phrase anchor text you want to have your site appear with extended Sitelinks.

Extended Sitelinks are obviously a new addition to the search results pages of Google, so expect development to continue over the next several months and years. As it stands today, the sites of well known (established) brands are those which are receiving the extended Sitelinks. Take the necessary steps today to acquire extended sitelinks and you will likely be pleased at the virtual real estate you secure on the search results pages.

- See more at: http://www.websitemagazine.com/content/blogs/posts/archive/2011/08/23/google-s-extended-sitelinks-exposed.aspx#sthash.HjP7hhM9.dpuf

Read More →

05:24

Google, SEO

How to remove a watermark from a PDF file With Software And Command Prompt?

I thought this would be a simple task, but it turned out the other way. The watermark is the very same (overlapping, but transparent) image on every single page. I created the PDF file myself (so no copyright worries here) using PDFCreator 0.9.8. I have already tried my friend's Adobe Acrobat Pro, but it didn't work. It tries to remove it, but it can't. I tried to remove header/footer, etc., but the watermark just won't disappear.  For image-based watermarks, there are several tools that promise their automatic removal. For example: We PDF Watermark Remover PDF Watermark Remover SoftOrbits PDF Logo Remover All of these are free to try, but require a license to actually produce the desired output. A less time-consuming solution would be to "manually" remove the watermark. We need: A tool to (un)compress and fix PDF streams (Pdftk). A text editor capable of replacing regular expressions (Notepad++, version 6.0 or higher). Steps Download Pdftk and extract pdftk.exe and libiconv2.dll to %windir%\System32, a directory in the path or any other location of your choice. Download and install Notepad++. PDF streams are usually compressed using the DEFLATE algorithm. This saves space, but it makes the PDF file illegible. The command pdftk original.pdf output uncompressed.pdf uncompress uncompresses all streams, so they can be modified by a text editor. Open uncompressed.pdf with Notepad++ to reveal the structure of the watermark. In this specific case, every page begins with the block q 9 0 0 9 2997 4118.67 cm BI /CS/RGB /W 1 /H 1 /BPC 8 ID Ÿ®¼ EI Q and nearly 4,000 blocks just like this one. This particular block sets only one (/W 1 /H 1) of the watermark's pixels. Scrolling down until the pattern changes reveals that the watermark's stream is 95,906 bytes long (counting newlines). The exact same stream is repeated on every page of the PDF file. Press Ctrl + H and set the following: Find: q 9 0 0 9 2997 4118\.67 cm.{95881} Replace: (blank) Match case: checked Wrap around: checked Regular expression: selected . matches newline: checked  The regular expression q 9 0 0 9 2997 4118\.67 cm.{95881} matches the first line of the above block (q 9 0 0 9 2997 4118.67 cm) and all following 95,881 characters, i.e., the watermark's stream. Clicking Replace All removes it from all pages of the PDF file. The watermark has now been removed, but the PDF file has errors (the streams' lengths are incorrect) and it's uncompressed. The command pdftk uncompressed.pdf output nowatermark.pdf compress takes care of both. uncompressed.pdf is no longer needed. You can delete it. The result is the same PDF without the watermark (and about half the size).

Read More →

03:16

PDF

PDF Password Remover Online

• Visit this http://smallpdf.com/unlock-pdf Website and upload your PDF to the Site.

Read More →

03:08

PDF