Surendra Sharma

Surendra Sharma

Search This Blog

Thursday, November 13, 2014

How to access or connect internet from laptop to mobile

I was just looking a way to share my laptop internet with my android mobile or more specifically I was trying to make my laptop into wifi hotspot.

First I tried to create ad hoc network from control panel but somehow that didn't worked.

Then I thought to take help of some third party utilities to make wifi hotspot.

I googled and tried Connectify but somehow it didn’t worked for me and second thing its paid.

I again googled for some free tool and come up with mHotspot.

I installed it. Filled some basic information into the window and it started to work on my laptop.

The most important think I liked about this tool is its completely free, small size and simple UI.

You can connect any internet connection to your laptop like USB dongle, wifi or wired cable and this app make your laptop into WIFI Hotspot.

Here is a link to download mHotspot.

Once your laptop become WIFI hotspot, turn your mobile wifi ON and connect to laptop hotspot.

If you are unable to access internet even after connecting to Hotspot, here is way to fix the problem.

Huuurrrryyy, now my mobile start to use internet through my laptop.

Thanks mHotspot.

Please leave your comments or share this tip if it’s useful for you.

Tuesday, November 4, 2014

How to directly insert new content item from a specific template in Sitecore

Everything in Sitecore is item. Most important is content items.

There are scenarios when we want to force content editor to insert new content item from a specific template. For example, we want to insert only Country specific pages under World content item as shown below

·         Home
o    World
§  India
§  US
§  China
§  Egypt

How to do it in Sitecore?

For this create two template in Sitecore – for example World and Country with their standard values as shown below

There are no fields in World template. However you can keep any fields if you need.

Select Standard Values of World template -> Select Configure Menu -> Click on Assign under Insert Options section -> from Insert Option window assign Country template -> Ok

Now insert World content item under Home. Under this World item we have option to insert directly country specific items as shown below

Insert some more Country items under World items. So finally we come up with hierarchical structure as shown below

Please leave your comments or share this tip if it’s useful for you.

Friday, October 31, 2014

How to map Visual Studio web project to Sitecore

Once you installed Sitecore then next step is to create and map your Visual Studio Web project to Sitecore.

It’s good to install software in sequence of IIS, SQL Server, Visual Studio and then finally Sitecore.

For this tutorial we will create Welcome page in Visual Studio and show Welcome <Employee Name> message where Employee Name should retrieve from Sitecore Content item. Final screen should look like

My Sitecore instance is running at “C:\inetpub\wwwroot\NewInstance2\Website” and I will create my visual studio project at “D:\MyTestApp”.

So we have all the necessary details. Let’s do mapping now.

Here are steps to map your project with Sitecore.

1.    Create ASP.NET Empty Web Application project in C# having name like “SitecoreWebApp” as below

2.    Delete Web.config file from newly created project.
Add folders like “layouts”, “sublayouts”, “upload” and “xml” to this application.
Add “welcomepage.aspx” page in layouts folder.
Copy “Sitecore.Kernel.dll” from Sitecore instance [i.e. from C:\inetpub\wwwroot\NewInstance2\Website\bin] to project bin directory [i.e. to D:\MyTestApp\SitecoreWebApp\SitecoreWebApp\bin] through file system.
Add reference of this “Sitecore.Kernel.dll” to current project and set its property CopyLocal = false.
After all these steps your solution should look like this

3.    Login to Sitecore and create “Employee” template as below

4.    Also create standard values for this template by selecting Employee Template -> Select Builder Options Menu -> Click Standard Values as below

5.    Enter token in Employee Name field as “$name” so that content item name should filled by default as below

6.    Create Layout having name “welcomepage” as below

7.    Create content item with name “Surendra Sharma” as below. Check Employee Name field filled automatically as per the item name.

8.    Our content is ready but we need layout to display this information. So map this content with layout by selecting content item “Surendra Sharma” -> Presentation Menu menu -> Details -> Click Edit link from Default section -> Select Layout -> Select “Layouts\welcomepage” as below

9.    Now go to Visual Studio project and design and code “welcomepage.aspx” page as below

10. Till this step we mapped everything. It’s time to publish our Web application from Visual Studio. So right click your project from Solution Explorer and select Publish. Create profile and select publish method as “File System”. Select Target Location as your Sitecore instance website folder. In my case it is “C:\inetpub\wwwroot\NewInstance2\Website” as shown below

11. In next step select Release configuration only and uncheck Delete checkbox as shown below

12. After successful publishing, we can Preview the content item. So select “Surendra Sharma” from content tree -> Publish Menu -> select Preview as shown below

13. Your browser should show screen like this

14. Bazinga!!!! Congrats, if you are reading this line, you successfully mapped your project with Sitecore.

Please leave your comments or share this guide if it’s useful for you.

Thursday, October 30, 2014

How to install multiple web instances of Sitecore on single machine

If you want to work on multiple Sitecore projects then it’s a tricky situation to install and run multiple Sitecore instances on the same machine.

If you don’t know how to install Sitecore, then please refer my previous article on it from here.

First install as many sitecore instances you want. At my machine I installed 3 instances of Sitecore as NewInstance1, NewInstance2 and NewInstance3.

I had used same License.xml file during installation of all instances.

After installation, my IIS and SQL Server should look like this

For each instance, there are 3 databases.

·         If you want to browse and run all instances at the same time then there must be valid entry in “hosts” file at “C:\Windows\System32\drivers\etc” for each instance as shown below

If you did not find any such entry in Hosts file then make it manually.

Please leave your comments or share this tip if it’s useful for you.

Wednesday, October 29, 2014

Installation guide for Sitecore through Setup

This article refer to installation of Sitecore by using Setup.

Before installing Sitecore, make sure you installed IIS, SQL Server and Visual Studio respectively.

You must have Sitecore Setup EXE like “Sitecore 7.2 rev. xxxxxx.exe” and licence.xml file.
Here is complete guide 

·         Double click on Sitecore Setup EXE. Click Next on Welcome wizard.

·         Select ‘New Instance’

·         Accept license agreement.

·         Select Complete installation type.

·         Enter Instance Name

·         Browse License file.

·         Enter SQL Server credentials. This steps should create three database with prefix NewInstance3 like “NewInstance3Sitecore_Web”.
If you want to change prefix then select “Advanced…” button in the same screen and change “Database Prefix”.

·         Select sitecore installation path.

·         Select Web Site name that should be created in IIS.

·         Finally click Install and wait for setup to proceed.

·         If you get this screen then congratulation you installed sitecore successfully. Check Launch Sitecore box.

·         Once you click on Finish button, you should get

·         If you are not getting welcome sitecore screen then check entry in “hosts” file at “C:\Windows\System32\drivers\etc”. There must be entry for new instance like “            NewInstance3”. If any such entry is not found then then do it manually.

Please leave your comments or share this guide if it’s useful for you.

Monday, October 27, 2014

How to inherit templates in Sitecore

During working with templates in Sitecore, there are situations when you want to implement inheritance mechanism. So here is simple way to do it.

Suppose we want to create “Slide” template having header and footer. In programming terms every Slide should get inherit from Header and Footer. So we will create two template like “Header” and “Footer” as below

After header and footer, we will create “Slide” template as below

As every slide contains header and footer, so let’s assign “Header” and “Footer” template.
Select “Slide” template -> Click on Content tab -> Assign “Header” and “Footer” template from “__Base Template” fields as below

You can verify this association from “Inheritance” Tab of “Slide” Template as below

Now whenever you will create content item of “Slide” template, you will get fields with sections of Footer, Header and Slide and as below

Please leave your comments or share this technique if it’s useful for you.

Monday, October 6, 2014

How to convert column values in date in Excel

Recently I come across with interesting situation.

My friend called me and ask for technical help. I thought he wants to ask something in .NET or SQL Server as I am working with these technologies. But my surprise he asked me something interesting question related with Microsoft Excel.

Here is the problem

His COBOL program is generating excel file which contains month, day and year columns. He wants complete date column by applying just the excel formula in generated sheet.

Solution :

I had not any Internet connection at that time so I opened Excel in my Laptop.

Just created with text column for Month, day, Year and Final date in blank Excel file and started to play with available functions in Excel.

Microsoft already paid attention with these kind of situation by providing Date() function.


=DATE(year, month, day)

Just pass cell details in parameters and you will get the desired result as shown below.


= DATE(E3, C3, D3)

Please leave your comments or share this tip if it’s useful for you.

Monday, September 8, 2014

Form 28 / Form no. 28 / No Objection Certificate (NOC)

Recently I want NOC from RTO for moving my vehicle. For that one need form 28. If it’s a state wise transfer then you need 3 copies of Form 28 for inter-state, we require 4 copies.

RTO in India is the perfect example of mismanagement. RTO Employees are worst and local agents are best. But I tried to get NOC from my own.

First problem I faced to get form 28. RTO office has form 28 copies but all are in Marathi. If you demand for English one then RTO employees show you the route of Xerox shop where shop guys selling it in 4 Rs.

You can even download form 28 from RTO website, but the worst thing is that it’s a 3 page PDF while actual form is only 2 pages which should be printed on both side of paper.

Here is scanned copy of form 28 that I got from Xerox guy.  Download it free and take a print. That’s it. No need to pay 4 Rs. to those greedy people.

Please leave your comments or share this if it’s useful for you.

Friday, September 5, 2014

Asa Kyo

This is my second poem 'Asa Kyo'

Kyo tere bare me mai din bhr sochta hu,
Kyo tere liye mai din-raat aanhe bhrta hu,
Kyo tere liye mai din rat bin pani machli sa tdpta hu,
Kyo tujh pe duniya ka sara pyar lutane ko jee chahta hai,
Kyo hr pl ek teri hi kmi mhsus hoti hai,
Kyo tujhe pa lene ke bavjud tujhe khone ka dr lga rhta hai,
Kyo ye mera dil ek tera hi hona chahta hai,
Kyo subh se sham, sham se subh ek tera hi dil pe phra rhta hai,
Kyo ek tere sath hi jeene ki dil mera dua mangta hai,
Kyo ye mera mn ek tere liye hi bekrara rhta hai,
Mai na janu ye kya hai, ye kyo hai,
Agar pyar yhi hai , to mujhe ye hua hai, tujh se, Anu se,
Or tu hi mera pyar hai, tu hi mera pyar hai.


I started to write a poem ( Kavita ) for my dear one.
Let me know about my first attempt to write a poem in Hindi. Your suggestions are welcome for motivation.

Registan Ki tpti dhoop me thndi chanv ka ahsas si lgti tum,
Bhtke smndr me kinara lgane vali kshti si lgti tum,
Ucche aasman me timtimate tare si lgti tum,
Badlo se brse pani ki phli fuhar si lgti tum,
Gulista ke ghne drkhto ki hriyali si lgti tum,
Thnd me grmi ka ahsas si lgti tum,
Andhere me ummid ki roshni ka ahsas si lgti tum,
Chmn ke phulo ki tbssum si lgti tum,
Driya ke bhte pani ki kl-kl ki aavaj si lgti tum,
Pahado pe Uncche jhrno ke trnnum si lgti tum,
Mujhe mere hi hone ka ahsas si krati tum,

Mere khud ka 'Anu' ke ho jane ki khvaish puri si krati tum.

My Shayaris - II

1.    Koi h jisko hum yaad karte hai ...
koi hai jisse milne ki rb se fryad krte hai..
jld vo mil jaye to jindgee svr jaye,
uske bina ek ek pl jeena mushkil hai

2.    koi mere mhboob ko mere naam ka chirag la de,
koi mere mhboob ko mere naam ka chirag la de,
ki mai uski yaado ka gulam bn chuka hu

3.    Bandhan rishtoo ka nhi..ahsas ka hota h
Jaha ahsas hota h vhi pyar hota h

4.    tere pyar me mera koi thikana nhi rha hai,
pta koi puchta hai to hm teri gliyan btate hai

5.    Aaine ki jrurt nhi hai mujhe,
Aaine ki jrurt nhi hai mujhe,
hmare liye to hmare dilbr ki aakhen hi kafi hai.

6.    tu mere baichen dil ka sukun hai,
tu mere baichen dil ki aarzoo hai,
tere bina na mera koi mukkml jahan,
jeene ki mere sirf tu hi jrrut hai

Thursday, August 14, 2014

Sybase IQ error Syntax error near 'SET' on line

Many times you may get Sybase IQ error like Syntax error near 'SET'. Suppose if I am trying to execute below statements

SET TEMPORARY OPTION Temp_Extract_Column_Delimiter =',';
SET TEMPORARY OPTION Temp_Extract_Row_Delimiter = '';
SET TEMPORARY OPTION Temp_Extract_Name1='\\\\XYZServer\\Backup\\test.txt';
SELECT column1, column2, column3 FROM tblTest
SET TEMPORARY OPTION Temp_Extract_Name1='';

Then Sybase IQ display below error

ERROR[42000][Sybase][ODBC Driver][Sybase IQ]Syntax error near 'SET' on line 5


It simply means end SELECT query with semicolon “;”.
Every statement in Sybase IQ should be end with semicolon.

SELECT column1, column2, column3 FROM tblTest;
SET TEMPORARY OPTION Temp_Extract_Name1='';

Please leave your comments or share this tip if it’s useful for you.

Wednesday, August 6, 2014

How to show multiple messages in alert box in JavaScript?

An alert box is used to pop up the information where user has to click “OK”.

alert("This is single line message.");

Generally we are showing single line message in alert box. But do you know how to show multiple message in single alert box?

Trick is to use “\n” after every message to separate one message with other like

alert('-1. Tajmahal in India. \n\n-2. Pyramids in Egypt. \n\n-3. Great wall of China.');

Here I want separation of two lines between each message, so I used “\n\n”.

So finally it should look like this

Please leave your comments or share this tip if it’s useful for you.

Tuesday, July 22, 2014

column Id is constrained to be unique. value is already present

If you are working with dataset in .NET and facing error as "column Id is constrained to be unique. value is already present."
Then simply set

datasset.EnforceConstraints = false;

It does not check the constraints at .net side. When you are going to update dataset records into database, all constraints fire at database level.

Please leave your comments or share this tip if it’s useful for you.