longitude and latitude based on user location

Question

 

Hi

 

Table 

 

Latitute Longitute

28.4880351 77.0621916

29.9990351 77.121916

28.4880353 77.0621916

26.1110351 78.123916

 

and suppose search on  

Latitute Longitute

28.4880351 77.0621916

 

 

with in 5 km 

 

 

how to return sql table column value longitude and latitude based on user location in sql with distance limit

 

example

 

suppose user Latitute '28.4880351' and Longitute is '77.0621916' and want to return all lat and lan from my table with in 5 km radius 

 

 

Thanks and Regards

Sharad Gupta 

Answer 1

code 128 can be generated in many kinds of platforms,just take this guide for code 128 in asp.net for example.
besides,as for barcode reader you may refer to reader in .net.

Answer 2

check the sample codes on drawing code 128 in c#:
REImage reImage = REFile.OpenImageFile("c:/Sample.png", new PNGDecoder());

Linear barcode = new Linear();//create a barcode

barcode.Type = RasterEdge.Imaging.Barcode.Creator.BarcodeType.CODE128;//select barcode type

barcode.Data = "123456789";//set barcode data
barcode.X = 1.0F;//set x
barcode.Y = 60.0F;//set y
barcode.Resolution = 96;//set resolution
barcode.Rotate = Rotate.Rotate0;//set rotate

barcode.DrawBarcode(reImage, 300, 450);//draw barcode on REImage with location x and y

REFile.SaveImageFile(reImage, "c:/code128.png", new PNGEncoder());

Answer 3

First , you need figure out which app. you want to use?
For instance, generate code128 in asp.net:

1. Install ASP.NET Barcode Control;
2. Add ASP.NET Barcode Control onto your .NET Visual Studio Toolbox;
3. Copy "linear.aspx" and "linear.aspx.cs" to the folder where your aspx pages are generating barcodes;
4. Drag and drop the WebLinearBarcode control into the Forms;
5. Run the website and you will see a barcode image generated;
6. More Code 128 Setting see below.

 
Then, you just copy the C# to your peoject to decode it!

Hope it helps!

Answer 4

You need to add the DLL to your VS 2010 toolbox as a common control, then drag and drop it to form to generate Code 128. Here is sample of generating Code 128 in Winforms apps. Hope do help to you.

Answer 5

We searched a lot and ended up using leadtools barcode module, which helped us to write and read different barcode types (including code 128).

For more information, see the following page:

http://www.leadtools.com/help/leadtools/v175/dh/ba/leadtools.barcode~leadtools.barcode.barcodereader.html

Answer 6

Hi

Are you trying to print the barcode on a specific printer?

Barcode Labels printers have barcodes on-board you just need to send the correct parameters down i.e. x y cordinates, barcode type, density etc.

Regards

Rob

Barcolde Label Answers

Answer 7

Take a look here
Barcode Generator
Barcode Scanner

may helps you.