I tried your code for Autocomplete without Webservice and didn't work on my page. When I tried it on a new project it works fine but on my project it does not. I have other controls on the page but that shouldn't stop it from working right?
Attached is my code
Could you please take a look and tell me what is wrong with it?
<%@ Page Title="" Language="VB" MasterPageFile="~/intranet.master" AutoEventWireup="false" CodeFile="warehouse.aspx.vb" Inherits="warehouse" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
<style type="text/css">
.style1
{
width: 150px;
}
.style2
{
width: 330px;
}
.loading
{
background-image: url(images/loader.gif);
background-position: right;
background-repeat: no-repeat;
}
</style>
<script type="text/javascript">
function OnClientPopulating(sender, e) {
sender._element.className = "loading";
}
function OnClientCompleted(sender, e) {
sender._element.className = "";
}
</script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<table style="width:100%;">
<tr>
<td class="subtitles">
Create Warehouse Receipt</td>
</tr>
<tr>
<td>
<asp:SqlDataSource ID="SDSShippers" runat="server"
ConnectionString="<%$ ConnectionStrings:shipITsoftConn %>"
SelectCommand="select shipperid, shippername
from usr_app_shippers
where shipperstatus=@shipperstatus
order by case when shippername = (select companyname from usr_app_company) then '0' else shippername end">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="shipperstatus" Type="Byte" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SDSConsignees" runat="server"
ConnectionString="<%$ ConnectionStrings:shipITsoftConn %>"
SelectCommand="SELECT [consigneename], [consigneeid] FROM [usr_app_consignees] WHERE ([consigneestatus] = @status) ORDER BY [consigneename]">
<SelectParameters>
<asp:Parameter Name="status" DefaultValue="1" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SDSTransporters" runat="server"
ConnectionString="<%$ ConnectionStrings:shipITsoftConn %>"
SelectCommand="SELECT [transporterid], [transportername] FROM [usr_app_transporters] WHERE ([active] = @active) ORDER BY [transportername]">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="active" Type="Byte" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SDSDeliverytypes" runat="server"
ConnectionString="<%$ ConnectionStrings:shipITsoftConn %>"
SelectCommand="SELECT [deliverytypeid], [deliverytypename] FROM [usr_app_deliverytypes] WHERE ([active] = @active) ORDER BY [deliverytypename]">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="active" Type="Byte" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SDSTransportationtypes" runat="server"
ConnectionString="<%$ ConnectionStrings:shipITsoftConn %>"
SelectCommand="SELECT [transportationtypeid], [transportationtypename] FROM [usr_app_transportationtypes] WHERE ([active] = @active) ORDER BY [transportationtypename]">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="active" Type="Byte" />
</SelectParameters>
</asp:SqlDataSource>
<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
</asp:ScriptManager>
</td>
</tr>
<tr>
<td>
<table style="width:100%;">
<tr>
<td class="style1">
</td>
<td class="style2">
</td>
<td class="style1">
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
Shipper</td>
<td class="style2">
<asp:DropDownList ID="ddShipperid" runat="server" DataSourceID="SDSShippers"
DataTextField="shippername" DataValueField="shipperid">
</asp:DropDownList>
</td>
<td class="style1">
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
Consignee</td>
<td class="style2">
<asp:TextBox ID="txtConsignee" runat="server" Width="200px"></asp:TextBox>
<cc1:AutoCompleteExtender ServiceMethod="GetConsignees"
MinimumPrefixLength="2"
CompletionInterval="100" EnableCaching="false" CompletionSetCount="10"
TargetControlID="txtConsignee" ID="AutoCompleteExtender1" runat="server" FirstRowSelected = "false"
OnClientHiding="OnClientCompleted" OnClientPopulated="OnClientCompleted" OnClientPopulating="OnClientPopulating">
</cc1:AutoCompleteExtender>
<asp:Button ID="butNewconsignee" runat="server" Text="New"
UseSubmitBehavior="False" />
</td>
<td class="style1">
Receipt Date</td>
<td>
<asp:TextBox ID="txtReceiptdate" runat="server" Width="100px"></asp:TextBox><cc1:CalendarExtender
ID="CalendarExtender1" runat="server" TargetControlID="txtReceiptdate">
</cc1:CalendarExtender>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtReceiptdate" CssClass="error"
ErrorMessage="Receipt Date is required">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="style1">
Transportation Type</td>
<td class="style2">
<asp:DropDownList ID="ddTransportationtype" runat="server"
DataSourceID="SDSTransportationtypes" DataTextField="transportationtypename"
DataValueField="transportationtypeid">
</asp:DropDownList>
</td>
<td class="style1">
Delivery Type</td>
<td>
<asp:DropDownList ID="ddDeliverytype" runat="server"
DataSourceID="SDSDeliverytypes" DataTextField="deliverytypename"
DataValueField="deliverytypeid">
</asp:DropDownList>
</td>
</tr>
<tr>
<td class="style1">
</td>
<td class="style2">
</td>
<td class="style1">
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
</td>
<td class="style2">
</td>
<td class="style1">
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
</td>
<td class="style2">
</td>
<td class="style1">
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
</td>
<td class="style2">
</td>
<td class="style1">
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
<asp:Button ID="Button1" runat="server" Text="Create Receipt"
UseSubmitBehavior="False" />
</td>
<td class="style2">
</td>
<td class="style1">
</td>
<td>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
</td>
</tr>
</table>
</asp:Content>
and Code behind:
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Collections.Generic
Imports System.Configuration
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports Autocomplete
Partial Class warehouse
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
txtReceiptdate.Text = Today
End If
End Sub
Protected Sub butNewconsignee_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles butNewconsignee.Click
Response.Redirect("newconsignee.aspx")
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim myParameter As SqlParameter
myConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("shipITsoftConn").ConnectionString)
myCommand = New SqlCommand()
myCommand.Connection = myConnection
myCommand.CommandText = "usr_sp_new_shipment"
myCommand.CommandType = CommandType.StoredProcedure
myParameter = myCommand.CreateParameter()
myParameter.ParameterName = "@userid"
myParameter.Direction = ParameterDirection.Input
myParameter.SqlDbType = SqlDbType.VarChar
myParameter.Size = 20
myParameter.Value = Session("gUserid")
myCommand.Parameters.Add(myParameter)
myParameter = myCommand.CreateParameter()
myParameter.ParameterName = "@shipperid"
myParameter.Direction = ParameterDirection.Input
myParameter.SqlDbType = SqlDbType.Int
myParameter.Value = ddShipperid.SelectedValue
myCommand.Parameters.Add(myParameter)
myParameter = myCommand.CreateParameter()
myParameter.ParameterName = "@consigneeid"
myParameter.Direction = ParameterDirection.Input
myParameter.SqlDbType = SqlDbType.Int
myParameter.Value = txtConsignee.Text
myCommand.Parameters.Add(myParameter)
myParameter = myCommand.CreateParameter()
myParameter.ParameterName = "@transportationtypeid"
myParameter.Direction = ParameterDirection.Input
myParameter.SqlDbType = SqlDbType.Int
myParameter.Value = ddTransportationtype.SelectedValue
myCommand.Parameters.Add(myParameter)
myParameter = myCommand.CreateParameter()
myParameter.ParameterName = "@deliverytypeid"
myParameter.Direction = ParameterDirection.Input
myParameter.SqlDbType = SqlDbType.Int
myParameter.Value = ddDeliverytype.SelectedValue
myCommand.Parameters.Add(myParameter)
myParameter = myCommand.CreateParameter()
myParameter.ParameterName = "@receiptdate"
myParameter.Direction = ParameterDirection.Input
myParameter.SqlDbType = SqlDbType.Date
myParameter.Value = txtReceiptdate.Text
myCommand.Parameters.Add(myParameter)
myParameter = myCommand.CreateParameter()
myParameter.ParameterName = "@shipmentid"
myParameter.Direction = ParameterDirection.Output
myParameter.SqlDbType = SqlDbType.Int
myCommand.Parameters.Add(myParameter)
myConnection.Open()
myCommand.ExecuteNonQuery()
Response.Redirect("contents.aspx?sid=" + CStr(myCommand.Parameters("@shipmentid").Value))
End Sub
<System.Web.Script.Services.ScriptMethod(), _
System.Web.Services.WebMethod()> _
Public Shared Function GetConsignees(ByVal prefixText As String, ByVal count As Integer) As List(Of String)
Dim conn As SqlConnection = New SqlConnection
conn.ConnectionString = ConfigurationManager.ConnectionStrings("Conn").ConnectionString
Dim cmd As SqlCommand = New SqlCommand
cmd.CommandText = "select consigneename from usr_app_consignees where consigneename like @SearchText + '%'"
cmd.Parameters.AddWithValue("@SearchText", prefixText)
cmd.Connection = conn
conn.Open()
Dim consignees As List(Of String) = New List(Of String)
Dim sdr As SqlDataReader = cmd.ExecuteReader
While sdr.Read
consignees.Add(sdr("consigneename").ToString)
End While
conn.Close()
Return consignees
End Function
End Class
