Post
Ask Question
aditya immadi

aditya immadi

  • NA
  • 205
  • 69.7k

my code is not working

Jul 18 2013 5:05 AM
this is the code in aspx age

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

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Untitled Page</title>
    <script src="scripts/jquery-1.8.3.js" type="text/javascript"></script>
    <script src="scripts/jquery-1.8.3.js" type="text/javascript"></script>
<script src="scripts/jquery.autocomplete.js" type="text/javascript"></script>
<script type="text/javascript">
    $(document).ready(function () {
        $("#<%=txtSearch.ClientID%>").autocomplete("Search.ashx", {
            width: 200,
            formatItem: function (data, i, n, value) {
                return "<img style = 'width:50px;height:50px' src= Images/" + value.split(",")[1] + "'/> " + value.split(",")[0];
            },
            formatResult: function (data, value) {
                return value.split(",")[0];
            }
        });
    });
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="txtSearch" runat="server" Width = "195"></asp:TextBox>
</div>
</form>
</body>
</html>

and my .ashx (generics handler) code is

<%@ WebHandler Language="C#" Class="Search" %>
using System;
using System.Data.SqlClient;
using System.Text;
using System.Web;
using System.Configuration;

public class Search : IHttpHandler {
public void ProcessRequest (HttpContext context)
{
    string searchText = context.Request.QueryString["q"];
    SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=apcamp;User ID=sa;Password=123");
    con.Open();
SqlCommand cmd = new SqlCommand("select id,imagename,imagepath from imagespath where imagename Like @Search + '%'", con);
cmd.Parameters.AddWithValue("@Search",searchText);
StringBuilder sb = new StringBuilder();
using(SqlDataReader dr=cmd.ExecuteReader())
{
while(dr.Read())
{
sb.Append(string.Format("{0},{1}{2}",dr["imagename"],dr["imagepath"],Environment.NewLine));
}
}
con.Close();
context.Response.Write(sb.ToString());
}
public bool IsReusable
{
get
{
return false;
}
}
}


i cant get either autocomplete or search results
can any one help me out

Thanks and Regards



Answers (1)