jQuery AutoComplete Plugin in ASP.Net and Oracle Database

manirul2...

SOLVED CLOSED ACTIVE ANSWERED
User: manirul26
Posted: on Apr 23, 2012 07:22 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 4967

<%@ WebHandler Language="C#" Class="Search_Auto" %>

using System;
using System.Web;
using System.Data.OracleClient;
using System.Configuration;
using System.Text;

public class Search_Auto : IHttpHandler {
    
    public void ProcessRequest (HttpContext context) {
        string prefixText = context.Request.QueryString["q"];
        using (OracleConnection conn = new OracleConnection())
        {
            conn.ConnectionString = ConfigurationManager
                    .ConnectionStrings["Oracle_Itech"].ConnectionString;
            
            
        //conn = WebConfigurationManager.ConnectionStrings["Oracle_Itech"].ConnectionString;
  
            
            using (OracleCommand cmd = new OracleCommand())
            {
                cmd.CommandText = "select xaccdesc from plmster where " +
                "xaccdesc like @TextBox2 + '%'";
                cmd.Parameters.AddWithValue("@TextBox2", prefixText);
                cmd.Connection = conn;
                StringBuilder sb = new StringBuilder();
                conn.Open();
               
                using (OracleDataReader sdr = cmd.ExecuteReader())
                {
                    while (sdr.Read())
                    {
                        sb.Append(sdr["xaccdesc"])
                            .Append(Environment.NewLine);
                    }
                }
                conn.Close();
                context.Response.Write(sb.ToString());
            }
        }
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }

}
i use this link 
http://www.aspsnippets.com/Articles/Using-jQuery-AutoComplete-Plugin-in-ASP.Net.aspx

error is here
  using (OracleDataReader sdr = cmd.ExecuteReader())

Download FREE API for Word, Excel and PDF in ASP.Net

manirul2...

0 7

Reply
User: manirul26
Replied: on May 08, 2012 02:53 AM
Report

I USE THIS

$(document).ready(function() {

$("#<%=txtSearch.ClientID%>").autocomplete('Search_Auto.ashx');

});

</script>

</head>

<body>

<div>

<asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>

</div>

</form>

</body>

</html>

===================

<%@ WebHandler Language="C#" Class="Search_Auto" %>

using System;

using System.Web;

using System.Data.OracleClient;

using System.Configuration;

using System.Text;

using System.Web.Configuration;

public class Search_Auto : IHttpHandler {

public void ProcessRequest (HttpContext context) {

string prefixText = context.Request.QueryString["q"];

// string strConn = WebConfigurationManager.ConnectionStrings["Oracle_Itech"].ConnectionString;

string strConn;

strConn = WebConfigurationManager.ConnectionStrings["Oracle_Itech"].ConnectionString;

// strConn = WebConfigurationManager.ConnectionStrings["Oracle_Itech"].ConnectionString.ToString();

OracleConnection Conn = new OracleConnection(strConn);

Conn.Open();

string sqltitle = "select XACCDESC from plmster where XACCDESC like '" + prefixText + "%'";

StringBuilder sb = new StringBuilder();

OracleCommand com = new OracleCommand(sqltitle, Conn);

OracleDataReader reader; //= com.ExecuteReader();

reader = com.ExecuteReader();

while (reader.Read())

{

sb.Append(reader["XACCDESC"])

.Append(Environment.NewLine);

}

Conn.Close();

context.Response.Write(sb.ToString());

}

public bool IsReusable {

get {

return false;

}

NOT WORKING WHEN I USED MANUALLY like 'c%' ITS COMMING

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

jQuery AutoComplete Plugin in ASP.Net and Oracle Database

Company

Explore

Follow us

Contact Us