" Umut, hiç görmeyen birine gökkuşağını anlatmak kadar zor ve imkansız... "

Categories

-

Asp.net AutoCompleteExtender kullanimi

Google arama çubugunda kelimelerimizi yazmaya basladigimizda bize yazdigimiz kelimeler veya harflerle ilgili sonuçlari giris yaptigimiz kismin altinda ariyor olabilecegimiz kelimeleri veya cumleleri listelemektedir. Asp.net kontrolu olan AutoCompleteExtender kontrolude tam bahsini yaptigim görevi üstlenmektedir. Formumuza bir textbox ekliyoruz ve biz aramaya yapmaya basladigimizda veritabanindan ilgili sonuçlari sorgulayarak karsimiza çikarmaktadir. Kodlarina bakacak olursak eger, Default.aspx.vb kodlarimiz;

Imports System.Data
Imports System.Web.Services
Imports System.Data.SqlClient
Partial Class _Default
    Inherits System.Web.UI.Page
    '
    
    Public Shared Function SearchCustomers(ByVal prefixText As String, ByVal count As Integer) As List(Of String)
        Dim conn As SqlConnection = New SqlConnection
        conn.ConnectionString = ConfigurationManager _
         .ConnectionStrings("database").ConnectionString
        Dim cmd As SqlCommand = New SqlCommand
        cmd.CommandText = "select * from vmarka where misim like @SearchText + '%'"
        cmd.Parameters.AddWithValue("@SearchText", prefixText)
        cmd.Connection = conn
        conn.Open()
        Dim customers As List(Of String) = New List(Of String)
        Dim sdr As SqlDataReader = cmd.ExecuteReader
        While sdr.Read
            customers.Add(sdr("misim").ToString)
        End While
        conn.Close()
        Return customers
    End Function
	
    Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load

    End Sub
End Class

Default.aspx kodlarimiz;

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
   
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
   
<!DOCTYPE html>
   
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
   
    <style type="text/css" >
      .search
      {
          margin: auto;
          border : 1px solid;
          padding :0px;
      }
   
    </style>
   
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
          
    <div>
        <asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>
        <ajaxToolkit:AutoCompleteExtender ID="AutoCompleteExtender1" CompletionListCssClass="search" ServiceMethod="SearchCustomers" Enabled="true" CompletionInterval="0"  TargetControlID="txtSearch" MinimumPrefixLength="2" runat="server"></ajaxToolkit:AutoCompleteExtender>
           
    </div>
    </form>
</body>
</html>

Webconfig dosyamiz ( Veritabani baglantisi )

<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <connectionStrings>
   
   <add name="database" connectionString="Data Source=Veritabani yolumuz; Initial Catalog=Veritabani ismi;
Integrated Security=True;" providerName="System.Data.SqlClient"/>
         
  </connectionStrings>
</configuration>

Örnek uygulamayi buradan indirebilirsiniz.

  • 0
  • 4993
  • 0

- BUNLARIDA GÖZDEN GEÇİREBİLİRSİNİZ -

HENÜZ YORUM YAPILMAMIŞ !

Yorum yazın

HAKKIMDA

KONULARI TAKİP EDİN

SOSYAL AĞLAR

  • Mesajınızı Gonderin