selvi subramanian

NA
799
572.5k

what error in this ajax

May 10 2014 6:05 AM

my source code is

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

$(document).ready(function()

{

SearchText();

});

function SearchText()

{

$(".autosuggest").autocomplete

(

{

source: function(request, response)

{

$.ajax

(

{

type: "POST",

contentType: "application/json; charset=utf-8",

url: "Default.aspx/GetAutoCompleteData",

data: "{'username':'" + document.getElementById('TextBox1').value + "'}",

dataType: "json",

success: function(data)

{

response(data.d);

error: function(result)

{

alert("Type More Alphabet To search...");

}

});

}

});

}

</script>

</head>

<body>

<div>

<asp:TextBox ID="TextBox1" runat="server" class="autosuggest"></asp:TextBox>

</div>

</form>

</body>

</html>

my code is

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data.SqlClient;

using System.Drawing;

using System.Web.Services;

using System.Text;

public partial class _Default : System.Web.UI.Page

{

string s = ConfigurationManager.AppSettings["s"].ToString();

SqlConnection con = new SqlConnection();

SqlCommand cmd = new SqlCommand();

SqlDataAdapter da = new SqlDataAdapter();

DataSet ds = new DataSet();

protected void Page_Load(object sender, EventArgs e)

{

}

[WebMethod]

public static List<string> GetAutoCompleteData(string username)

{

List<string> result = new List<string>();

//using (SqlConnection con = new SqlConnection("data source=softech; initial catalog=emart; user id=sa; password=soft"))

using (SqlConnection con = new SqlConnection("data source=SELVI-PC\\SQLEXPRESS; Initial Catalog=bramandam;Integrated Security=True;"))

{

using (SqlCommand cmd = new SqlCommand("select DISTINCT Section from EmpReg where Section LIKE @SearchText+'%'", con))

{

con.Open();

cmd.Parameters.AddWithValue("@SearchText", username);

SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())

{

result.Add(dr["Section"].ToString());

}

return result;

}

My error is

Server Error in '/Ajax' Application.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

  <%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
   <system.web>
       <compilation debug="true"/>
   </system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]    _Default..ctor() +29    ASP.default_aspx..ctor() +13    __ASP.FastObjectFactory_app_web_r2w_az_x.Create_ASP_default_aspx() +20    System.Web.Compilation.BuildResultCompiledType.CreateInstance() +32    System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +119    System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +33    System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +40    System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) +160    System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +93    System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

Version Information: Microsoft .NET Framework Version:2.0.50727.4984; ASP.NET Version:2.0.50727.4971

Answers (2)

insert data using ajax

Https is blocking Ajax Cascading Dropdown content