LookUpEdit to search for any word contains then list

using (SqlConnection con = new SqlConnection(constr))
{
using (SqlDataAdapter sda = new SqlDataAdapter("SELECT CustomerId, ContactName FROM Customers", con))
{
//Fill the DataTable with records from Table.
DataTable dt = new DataTable();
sda.Fill(dt);
//Insert the Default Item to DataTable.
DataRow row = dt.NewRow();
row[0] = "";
row[1] = "";
dt.Rows.InsertAt(row, 0);
//Assign DataTable as DataSource to combobox
cbCustomers.DataSource = dt;
cbCustomers.DisplayMember = "ContactName";
cbCustomers.ValueMember = "CustomerId";
//Set AutoCompleteMode.
cbCustomers.AutoCompleteMode = AutoCompleteMode.Suggest;
cbCustomers.AutoCompleteSource = AutoCompleteSource.ListItems;
}
}

Hi Nguyen:

please try this code:

XAML:

<Grid>
<Grid.RowDefinitions>
<RowDefinition Height="*"/>
<RowDefinition Height="9*"/>
Grid.RowDefinitions>
<StackPanel Orientation="Horizontal">
<Label Content="Search Text:"/>
<TextBox x:Name="TxtSearchText" Width="150" TextChanged="TxtSearchText_TextChanged"/>
StackPanel>
<ListView Grid.Row="2" Margin="5" x:Name="PersonLst">
<ListView.View>
<GridView>
<GridViewColumn Header="First Name" DisplayMemberBinding="{Binding FirstName}" Width="124"/>
<GridViewColumn Header="Last Name" DisplayMemberBinding="{Binding LastName}" Width="124"/>
GridView>
ListView.View>
ListView>
Grid>

C#:

public partial class MainWindow : Window
{
Regex regex;
public MainWindow()
{
InitializeComponent();
ObservableCollection Persons = new ObservableCollection()
{
new Person(){FirstName = "Marvin", LastName = "Guo"},
new Person(){FirstName = "Angel", LastName = "Xu"},
new Person(){FirstName = "Amy", LastName = "Peng"},
new Person(){FirstName = "Jimmy Yang", LastName = "Yang"},
new Person(){FirstName = "Jim", LastName = "Yang"},
};
PersonLst.ItemsSource = Persons;
}
private void TxtSearchText_TextChanged(object sender, TextChangedEventArgs e)
{
FindListViewItem(this.PersonLst);
}
public void FindListViewItem(DependencyObject obj)
{
for (int i = 0; i < VisualTreeHelper.GetChildrenCount(obj); i++)
{
ListViewItem lv = obj as ListViewItem;
if (lv != null)
{
HighlightText(lv);
}
FindListViewItem(VisualTreeHelper.GetChild(obj as DependencyObject, i));
}
}
private void HighlightText(Object itx)
{
if (itx != null)
{
if (itx is TextBlock)
{
regex = new Regex("(" + TxtSearchText.Text + ")", RegexOptions.IgnoreCase);
TextBlock tb = itx as TextBlock;
if (TxtSearchText.Text.Length == 0)
{
string str = tb.Text;
tb.Inlines.Clear();
tb.Inlines.Add(str);
return;
}
string[] substrings = regex.Split(tb.Text);
tb.Inlines.Clear();
foreach (var item in substrings)
{
if (regex.Match(item).Success)
{
Run runx = new Run(item);
runx.Background = Brushes.Blue;
tb.Inlines.Add(runx);
}
else
{
tb.Inlines.Add(item);
}
}
return;
}
else
{
for (int i = 0; i < VisualTreeHelper.GetChildrenCount(itx as DependencyObject); i++)
{
HighlightText(VisualTreeHelper.GetChild(itx as DependencyObject, i));
}
}
}
}
}
public class Person
{
public string FirstName { get; set; }
public string LastName { get; set; }
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh6y ago
Accepted answer
using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter("SELECT CustomerId, ContactName FROM Customers", con))
        {
            //Fill the DataTable with records from Table.
            DataTable dt = new DataTable();
            sda.Fill(dt);

            //Insert the Default Item to DataTable.
            DataRow row = dt.NewRow();
            row[0] = "";
            row[1] = "";
            dt.Rows.InsertAt(row, 0);

            //Assign DataTable as DataSource to combobox
            cbCustomers.DataSource = dt;
            cbCustomers.DisplayMember = "ContactName";
            cbCustomers.ValueMember = "CustomerId";

            //Set AutoCompleteMode.
            cbCustomers.AutoCompleteMode = AutoCompleteMode.Suggest;
            cbCustomers.AutoCompleteSource = AutoCompleteSource.ListItems;
        }
    }
+2
suhel jamadar6y ago
it means in database table there are more or less colun than you are trying to insert thorugh Store procedure.
check your Id column is identity (auto incremented)

How to check???
0
Mageshwaran R6y ago
Hi Nguyen:
please try this code:

XAML:
<Grid>
    <Grid.RowDefinitions>
        <RowDefinition Height="*"/>
        <RowDefinition Height="9*"/>
    Grid.RowDefinitions>
    <StackPanel Orientation="Horizontal">
        <Label Content="Search Text:"/>
        <TextBox x:Name="TxtSearchText" Width="150" TextChanged="TxtSearchText_TextChanged"/>
    StackPanel>
    <ListView Grid.Row="2" Margin="5" x:Name="PersonLst">
        <ListView.View>
            <GridView>
                <GridViewColumn Header="First Name" DisplayMemberBinding="{Binding FirstName}" Width="124"/>
                <GridViewColumn Header="Last Name" DisplayMemberBinding="{Binding LastName}" Width="124"/>
            GridView>
        ListView.View>
    ListView>
Grid>
C#:
public partial class MainWindow : Window
    {
        Regex regex;

        public MainWindow()
        {
            InitializeComponent();

            ObservableCollection Persons = new ObservableCollection()
            {
                new Person(){FirstName = "Marvin", LastName = "Guo"},
                new Person(){FirstName = "Angel", LastName = "Xu"},
                new Person(){FirstName = "Amy", LastName = "Peng"},
                new Person(){FirstName = "Jimmy Yang", LastName = "Yang"},
                new Person(){FirstName = "Jim", LastName = "Yang"},
            };

            PersonLst.ItemsSource = Persons;
        }

        private void TxtSearchText_TextChanged(object sender, TextChangedEventArgs e)
        {
            FindListViewItem(this.PersonLst);
        }

        public void FindListViewItem(DependencyObject obj)
        {
            for (int i = 0; i < VisualTreeHelper.GetChildrenCount(obj); i++)
            {
                ListViewItem lv = obj as ListViewItem;
                if (lv != null)
                {
                    HighlightText(lv);
                }
                FindListViewItem(VisualTreeHelper.GetChild(obj as DependencyObject, i));
            }
        }

        private void HighlightText(Object itx)
        {
            if (itx != null)
            {
                if (itx is TextBlock)
                {
                    regex = new Regex("(" + TxtSearchText.Text + ")", RegexOptions.IgnoreCase);
                    TextBlock tb = itx as TextBlock;
                    if (TxtSearchText.Text.Length == 0)
                    {
                        string str = tb.Text;
                        tb.Inlines.Clear();
                        tb.Inlines.Add(str);
                        return;
                    }
                    string[] substrings = regex.Split(tb.Text);
                    tb.Inlines.Clear();
                    foreach (var item in substrings)
                    {
                        if (regex.Match(item).Success)
                        {
                            Run runx = new Run(item);
                            runx.Background = Brushes.Blue;
                            tb.Inlines.Add(runx);
                        }
                        else
                        {
                            tb.Inlines.Add(item);
                        }
                    }
                    return;
                }
                else
                {
                    for (int i = 0; i < VisualTreeHelper.GetChildrenCount(itx as DependencyObject); i++)
                    {
                        HighlightText(VisualTreeHelper.GetChild(itx as DependencyObject, i));
                    }
                }
            }
        }
    }

    public class Person
    {
        public string FirstName { get; set; }

        public string LastName { get; set; }
    }
+1