How to use AutoCompleteBox in silverlight Binding data from service

Priya Linge
13y
7.9k
0
0

Blog

Introduction :

This blog shows how we can display element in AutoCompleteBox in a sorting order in silverlight.

We have one menthod at service side, called GetClientName() here we have clientnames of a client.

Displaying that clientnames in autocompleteBox.

Example :

1. We have one service, Service1.svc.

[OperationContract]
        public List<string> GetClientName(string str)
        {
            string s = str + "%";
            sqlConnection.Open();
            string query = "select ClientName from Client where ClientName like '" + s + "' order by ClientName";
            sqlCommand = new SqlCommand(query, sqlConnection);
            sqlReader = sqlCommand.ExecuteReader();
            while (sqlReader.Read())
            {
                list.Add(sqlReader[0].ToString());
            }
            sqlConnection.Close();
            return list.ToList();
        }

2.In MainPage.Xaml

<Grid x:Name="LayoutRoot" Background="White">
        <Canvas Height="147" HorizontalAlignment="Left" Margin="72,64,0,0" Name="canvas1" VerticalAlignment="Top" Width="264">
            <Canvas.Background>
                <LinearGradientBrush EndPoint="0.5,1" StartPoint="0.5,0">
                    <GradientStop Color="#FF046FFF" Offset="0.768" />
                    <GradientStop Color="Black" Offset="0.991" />
                </LinearGradientBrush>
            </Canvas.Background>
            <sdk:AutoCompleteBox x:Name="MyautoBox" Canvas.Left="55" Canvas.Top="53" Width="150" ItemContainerStyle="{StaticResource myLBStyle}" />
        </Canvas>
    </Grid>

3. MainPAge.cs

public MainPage()
        {
            InitializeComponent();
   // SearchText is the text which is use for filter items in Autocompletebox.itemsource collection.
            GetClientName(MyautoBox.SearchText);
        }
        public void GetClientName(string cname)
        {
            ServiceReference1.Service1Client service = new ServiceReference1.Service1Client();
            service.GetClientNameCompleted += new EventHandler<ServiceReference1.GetClientNameCompletedEventArgs>(service_GetClientNameCompleted);
            service.GetClientNameAsync(cname);
        }
        void service_GetClientNameCompleted(object sender, ServiceReference1.GetClientNameCompletedEventArgs e)
        {
            MyautoBox.ItemsSource = e.Result;
        }

OutPut :

Thanks.