Surendra Sharma

Surendra Sharma

Search This Blog

Wednesday, August 7, 2013

How to show any place by latitude and longitude in ASP.NET

Recently I come across one requirement where I have to show the place on google place using latitude and longitude in ASP.NET webform.
         
         
Solution:-

Our objective is

User enter latitude and longitude as below




Where 27.175114, 78.042154 are latitude and longitude of Tajmahal J

Webpage should display Tajmahal on Google Map as below

         
To know how to get Latitude and Longitude of any place in Google maps? Please Visit here
         
Google team already developed API for map and its functionality. These API works with JQuery or Javascript.

How to work with Google API in ASP.NET?

·         First we need two javascript file. You don’t need to download these file

Map functionality - http://maps.google.com/maps/api/js?sensor=false
JQuery - https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js

·         So its declaration in ASPX page is as below

<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>     

·         Get the latitude and longitude from user or file or database and create one point of this latitude and longitude on map [Like X,Y co-ordinates in graph in mathematics]

myLatLng = new google.maps.LatLng(lat, lng);

·         Set different option of maps like zoom level, alignment of point in map, map type, navigation control as

var mapOptions = {
                    zoom: 15,
                    center: myLatLng,
                    mapTypeId: google.maps.MapTypeId.ROADMAP,
                    navigationControl: true
                };

·         Finally create map object with all specified optins and show in DIV as below

map = new google.maps.Map(document.getElementById("map_canvas"), mapOptions);
                                     
Here is complete code. Just copy and paste below HTML in ASPX file


<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>Google Map</title>
   
    <script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script>
    <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>

    <script type="text/javascript">

        $(document).ready(function() {

            $("#btnShow").click(function() {

                var lat = document.getElementById("txtLat").value;
                var lng = document.getElementById("txtLng").value;

                myLatLng = new google.maps.LatLng(lat, lng);

                //set the map options
                var mapOptions = {
                    zoom: 15,
                    center: myLatLng,
                    mapTypeId: google.maps.MapTypeId.ROADMAP,
                    navigationControl: true
                };

                //create the map object
                map = new google.maps.Map(document.getElementById("map_canvas"), mapOptions);

                return false;
            });
        });
    </script>

</head>
<body>
    <form id="form1" runat="server">
    <table width="40%" align="center"
       
        style="border: thin solid #000000; font-family: Verdana; font-size: small;">
        <tr>
            <td>
                <asp:Label ID="lblLat" runat="server" Text="Enter Latitude"></asp:Label>
            </td>
            <td>
                <asp:TextBox ID="txtLat" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td>
                <asp:Label ID="lblLng" runat="server" Text="Enter Longitude"></asp:Label>
            </td>
            <td>
                <asp:TextBox ID="txtLng" runat="server"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td colspan="2" align="center">
                <asp:Button ID="btnShow" runat="server" Text="Show Place" />
            </td>
        </tr>
    </table>
    <br />
   
    <table align="center" >
        <tr>
            <td>
                <div id="map_canvas" style="width: 700px; height: 500px;">
                </div>
            </td>
        </tr>
    </table>
    </form>
</body>
</html>



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

How to get latitude and longitude of any place in Google maps?

        
Recently I come across one requirement where I have to show the place on google map using Latitude and Longitude on ASP.NET webform. But the first question I want to know that how can I get latitude and longitude of any place
         
Solution:-
         

Find any place

1. Right click on any desire location on map and click on "What's here?"

2. You will get latitude and longitude of that position in Search textbox as shown in below figure



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

Monday, August 5, 2013

A module is not a valid type

How to fix error “Compile Error: A module is not a valid type” in VB?





Solution:-

This type of error occurred when you are trying to include old version of VB files or VB is unable to recognize the module.

How to fix it?

Copy the code of that particular module, suppose name is “Segmentation.cls”, in notepad file.

Select and Right click file “Segmentation.cls” -> Remove “Segmentation.cls”



Select and Right click Project -> Add -> Class Module -> New -> Select Class Module -> Open


Copy the code from notepad and paste to this new class module file. Save this with same filename “Segmentation.cls”.

Here file content should start with “Option Explicit”.
Content before this line should be commented or removed as below
'Attribute VB_Name = "Segmentation"
'VERSION 1.0 CLASS
'BEGIN
'  MultiUse = -1  'True
'End
Option Explicit

Select class module file in Project Explorer and change its Name property to “Segmentation” i.e. same as file name as below




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

Friday, August 2, 2013

Cycle Clipboard Ring - Secrets of Visual Studio

Least known but yet most powerful facility of Visual Studio is Cycle Clipboard Ring option.

What is Cycle Clipboard Ring?

Can you copy 10 different items in notepad and now paste all 10. You Can’t. L
What you can paste is only last copied item.

But visual studio allows you to paste last 16 copied items. J




In above image, I want to COPY all red arrow lines from bottom to top i.e. from line 132 to 108

Once copied, now I can paste all these items anywhere in Visual studio editors by using Cycle Clipboard Ring.

This option is available in Edit -> Cycle Clipboard Ring or Ctrl + Shift + V
Hold Ctrl + Shift and Press V again and again [Don’t release Ctrl + Shift]




It’s like a circular stack, after pasting last item you should get first item again as below

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

Wednesday, July 31, 2013

How to visit any particular line of code in Visual Studio

If there are lots of lines of code in a single code file and your colleagues told you to look piece of code at particular line number or any error occurred at specific line number.

How do you visit to that line of code?

By just scrolling ... that’s history

Solution :->

Some couple of handy ways to visit to particular line number in Visual studio
·         You can display line number at left side of code editor from Tools -> Options -> Text Editor -> All Languages -> Enabled Line numbers option. It should display line numbers in code editor as shown below




·         Visual Studio always display line number , column number and character position of cursor in status bar of visual studio as shown in above image

·         You also have facility to directly visit to any line number from Edit -> Go To... or press Ctrl + G as shown below


·         Use bookmarks to directly visit any particular line numbers

·         Use scroll bar to visit to particular line

·         Use keyboard Page Up or Page Down button

·         Use UP or DOWN arrow keys to navigate


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

Tuesday, July 30, 2013

How to get distinct values from column in Excel

If you have repetitive entries in excel column as below


How to get distinct values from column in Excel sheet.


Solution:-

Select column and click on Data -> Remove Duplicates
You should get output as below




Please leave your comment if it’s useful for you.

Monday, July 29, 2013

How to show more than 10 projects in Visual Studio recent project list

During working in Visual Studio (VS), we can view most recently used project in "Recent Projects" list.
However VS shows only 10 recent projects.

If we are working on multiple projects then how to show more than 10 projects in recent project list?

Solution:-

Open Visual Studio -> Go to Tools -> Options -> General -> modify value of "items shown in recently used lists".

Generally I make it 20.


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