ASP.NET

27-May-11 21:28

Luckily, I was working on this very problem today:

HTML

<html>
<head>
	<title>jQuery Auto-Complete Using Google Maps API</title>
	<script type="text/javascript" src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.4.2.min.js"></script>
	<script type="text/javascript" src="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.10/jquery-ui.min.js"></script>
	<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script>
	<script type="text/javascript">
		$(document).ready(function () {
			
			// Used to store functions.
			function AutoCompleteSample() {
			}
			
			// Accepts an auto-complete term and responds with results.
			AutoCompleteSample.handleAutocompleteRequest = function (request, response) {
				var geocoder = new google.maps.Geocoder();
				geocoder.geocode({address: request.term}, function(results, status) {
					response($.map(results, function(item) {
						return {
							label: item.formatted_address,
							value: item.formatted_address,
							latitude: item.geometry.location.lat(),
							longitude: item.geometry.location.lng()
						};
					}));
				});
			};
			
			// Returns a function that handles an auto-complete response.
			AutoCompleteSample.create_handleFoundLocation = function () {
				return function (event, ui) {
					var lat = ui.item.latitude;
					var lon = ui.item.longitude;
					var location = new google.maps.LatLng(lat, lon);
					alert(location);
				};
			};
			
			// Setup auto-complete for the below textbox.
			$("#txtAddress").autocomplete({
				// This function gets auto-complete results based on what the user types.
				source: AutoCompleteSample.handleAutocompleteRequest,
				// This function gets called when the user selects a result.
				select: AutoCompleteSample.create_handleFoundLocation()
			});
			
		});
	</script>
	<style type="text/css">
		/* You will want to add some style rules here to make the auto-complete list look pretty. */
	</style>
</head>
<body>
	<input type="text" id="txtAddress" />
</body>
</html>

That JavaScript is highlighted strangely in the above PRE block, so here is the JavaScript by itself (i.e., without the HTML):

JavaScript

$(document).ready(function () {
	
	// Used to store functions.
	function AutoCompleteSample() {
	}
	
	// Accepts an auto-complete term and responds with results.
	AutoCompleteSample.handleAutocompleteRequest = function (request, response) {
		var geocoder = new google.maps.Geocoder();
		geocoder.geocode({address: request.term}, function(results, status) {
			response($.map(results, function(item) {
				return {
					label: item.formatted_address,
					value: item.formatted_address,
					latitude: item.geometry.location.lat(),
					longitude: item.geometry.location.lng()
				};
			}));
		});
	};
	
	// Returns a function that handles an auto-complete response.
	AutoCompleteSample.create_handleFoundLocation = function () {
		return function (event, ui) {
			var lat = ui.item.latitude;
			var lon = ui.item.longitude;
			var location = new google.maps.LatLng(lat, lon);
			alert(location);
		};
	};
	
	// Setup auto-complete for the below textbox.
	$("#txtAddress").autocomplete({
		// This function gets auto-complete results based on what the user types.
		source: AutoCompleteSample.handleAutocompleteRequest,
		// This function gets called when the user selects a result.
		select: AutoCompleteSample.create_handleFoundLocation()
	});
	
});

Here is some documentation:

jQuery UI Autocomplete
Google Maps JavaScript API V3

Call Intemediary page while loading page

Prachi Mhatre27-May-11 10:17

Prachi Mhatre

27-May-11 10:17

I have a two forms i.e Form1 and Form2.When I submiting Form1 it will redirect to Form2.But Form2 was taking time while loading
So I want while loading Form2 one page will display.So after Form2 loads that page will not display.
Kindly check the site of cleartrip.com and search for flights.While searching flights one page is displaying and after that
the flight details page will display...
I want to show the waiting page... while in background actual page is loading....
How can I do this in ASP.NET...?
Please help me on this...

AspDotNetDev27-May-11 10:40

27-May-11 10:40

Sounds like you want a splash screen (demo). Or you could try a progress bar.

Prachi Mhatre28-May-11 9:53

Prachi Mhatre

28-May-11 9:53

actually I have an html page on which progress bar is there... I want to display that html page while loading the second page(i.e Form2)... Kindly check site cleartrip.com... and click on search flights... In that after clicking on search flights on page is displayed... like loading... and after that flight details page is displayed ... I want to display like that...

AspDotNetDev28-May-11 10:43

28-May-11 10:43

Ah, so I don't think you actually want to display an intermediate page while the desination page is loading (e.g., loading JavaScript files, CSS files, and so on). My guess is you are doing some sort of database query that makes the desination page take a long time to load. In that case, when you nagivate to the intermediate page, do the database queries there. Once the database queries have completed, stored them in a temporary table or a session variable to cache them, then redirect the user to the destination page (which will then load the data from the cache).

Also, that would basically be the same as showing a splash screen on your destination page while the page loads. That's the route I recommend you take. You basically show an image (or progress bar or whatever) and when your page has finished loading, you hide the splash screen (which reveals your actual page).

Prachi Mhatre28-May-11 12:14

Prachi Mhatre

28-May-11 12:14

actually requirement is to display html page only.... not the image...
Please help me .... how can I do that in ASP.NET....?

AspDotNetDev28-May-11 12:16

28-May-11 12:16

I just told you, but you seem to just be focusing on that last part of my message. Read my message again.

Also, anything you can display in an HTML page you can also display as a splash screen. It can have images, DIV's, text, tables, whatever.

Documents in SQL Server database

Aptiva Dave27-May-11 7:51

27-May-11 7:51

I have a sql server database table that contains documents that need to be downloaded from an internal site. The files are uploaded as varbinary(max) and I have the mime type for the file saved in the database (which will only be word and pdf, plus some wordperfect, files). Can someone let me know how I can pull those down from the database when a user needs to view the file? I'm already saving images in the database and I am able to pull those down using a http handler. Would that be the same process for this?

Not Active27-May-11 8:10

Not Active

27-May-11 8:10

Aptiva Dave wrote:
Would that be the same process for this?

Without knowing what your current process is that would be difficult to say.

Since an image is sent over the wire and rendered on the page it doesn't need additional processing. However, the file is on demand, when a user clicks a link it needs to be retrieved from the database and sent so a HTTPHandler would be necessary to process the request.

I know the language. I've read a book. - _Madmatt

Aptiva Dave27-May-11 8:25

27-May-11 8:25

and that is what I was kind of thinking. The way I am using the handler for images is that I point an image control's navigate URL to the handler ("www.mysite.com/ShowImage.ashx?ID=23"), which I can also use as a link for an image and pull up just fine as well. I couldn't find any good tutorials on the net that explained how docs were downloaded, just how they were uploaded. thanks.

Aptiva Dave27-May-11 9:57

27-May-11 9:57

So I tried implementing the same logic used to get images from the database, but instead of displaying the file my browser wants to open a file called DisplayResume.ashx.
Here is the code I used in my event Handler:

<%@ WebHandler Language="VB" Class="displayResume" %>

Imports System
Imports System.Web
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Imports util

Public Class displayResume : Implements IHttpHandler
    
    Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest
        Dim appID As Integer
        Dim mimeType As String
        If Not context.Request.QueryString("ID") Is Nothing Then
            'place ID in the the appID variable
            appID = context.Request.QueryString("ID").ToString
            'get the mimetype for the file from table
            mimeType = getMimeType(appID.ToString)
            If Not mimeType Is Nothing Then
                context.Response.ContentType = mimeType
                Dim strm As Stream = getResume(appID)
                Dim buffer As Byte() = New Byte(4095) {}
                Dim byteSeq As Integer = strm.Read(buffer, 0, 4096)
                
                Do While byteSeq > 0
                    context.Response.OutputStream.Write(buffer, 0, byteSeq)
                    byteSeq = strm.Read(buffer, 0, 4096)
                Loop
            Else
                Throw New ArgumentException("Can't retrieve MIME Type")
            End If
        Else
            Throw New ArgumentException("No Parameter specified")
        End If
    End Sub
    
    ''' <summary>
    ''' Gets the mime type for the resume from the database
    ''' </summary>
    ''' <param name="appID">appID for the resume we are looking for</param>
    ''' <returns>mimetype string</returns>
    ''' <remarks></remarks>
    Public Function getMimeType(ByVal appID As String) As String
        Dim rdrMime As SqlDataReader = GetReader("select mimeType from resumes where appID =" & appID)
        Dim mimetype As String = Nothing
        Try
            While rdrMime.Read
                mimetype = rdrMime("mimeType").ToString
            End While
        Catch ex As Exception
            Return Nothing
        Finally
            rdrMime.Close()
        End Try
        
        Return mimetype
    End Function
    
    ''' <summary>
    ''' gets the binary format of the file from the database
    ''' </summary>
    ''' <param name="ID">appID that is pointing to the resume file</param>
    ''' <returns>binary representation of the resume file</returns>
    ''' <remarks></remarks>
    Public Function getResume(ByVal ID As Integer) As Stream
        Dim strConnection As String = ConfigurationManager.ConnectionStrings("connectionString").ToString
        Dim conn As SqlConnection = New SqlConnection(strConnection)
        Dim sql As String = "Select theFile from Resumes where appID = " & ID
        Dim cmd As SqlCommand = New SqlCommand(sql, conn)
        Try
            conn.Open()
            Dim file As Object = cmd.ExecuteScalar
            Return New MemoryStream(CType(file, Byte()))
        Catch ex As Exception
            Return Nothing
        Finally
            conn.Close()
            conn.Dispose()
        End Try
    End Function
    Public ReadOnly Property IsReusable() As Boolean Implements IHttpHandler.IsReusable
        Get
            Return False
        End Get
    End Property

End Class

Not Active27-May-11 10:11

Not Active

27-May-11 10:11

Did you add the required settings in the web.config file?

I know the language. I've read a book. - _Madmatt

Aptiva Dave27-May-11 10:29

27-May-11 10:29

What setting would that be? I never have made any changes for displaying images before.

Not Active27-May-11 12:08

Not Active

27-May-11 12:08

I'm sorry, you were writing and http handler, I thought you knew you need to add it the web.config file also.

http://support.microsoft.com/kb/308001[^]

I know the language. I've read a book. - _Madmatt

Aptiva Dave31-May-11 8:51

Protect XML from outside access in asp.net

31-May-11 8:51

Okay. I've never had to do that with my images, so i guess I never knew to add anything to the web config. I'm still confused as to what I need to set the path and type to in the add section under httpHandlers.

Prasanta_Prince26-May-11 21:04

Prasanta_Prince

26-May-11 21:04

How to Protect XML from outside access in asp.net.
I have use

<configuration>
<location path="Login.xml">
<system.web>
<authorization>
<deny users="*"/>
</authorization>
</system.web>
</location>
</configuration>

But it doesn`t work online.

Re: Protect XML from outside access in asp.net

AspDotNetDev26-May-11 21:47

26-May-11 21:47

I'm pretty sure that's a setting you should be setting on the folder containing the XML file on the web server. Alternatively, you can embed the XML file in your application's DLL, which will make it inaccessible to the client side. Or you could store it in a database.