C# filter listview using textbox

cfilterlistviewtextbox

I have listview that is getting data from sql database .. I want to search by text entered in textbox and show the result after clicking a button and hide the records that doesn't match

here's my approach

plz help

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Inventory_Manager_Pro
{
public partial class Modify : Form
{

    public SqlConnection cn = new SqlConnection("Data Source=10.0.0.13;Initial Catalog=INVENTDB;Persist Security Info=True;User ID=sa;Password=farespila010A@;Encrypt=False");


    public Modify()
    {
        InitializeComponent();
    }

    private void populate()
    {
        listView1.Items.Clear();

        SqlCommand cm = new SqlCommand("SELECT * FROM lapdev", cn);

        try
        {

            SqlDataReader dr = cm.ExecuteReader();
            while (dr.Read())
            {

                ListViewItem it = new ListViewItem(dr["fillingcode"].ToString());
                it.SubItems.Add(dr["username"].ToString());
                it.SubItems.Add(dr["branch"].ToString());
                it.SubItems.Add(dr["department"].ToString());
                it.SubItems.Add(dr["agency"].ToString());
                it.SubItems.Add(dr["computername"].ToString());
                it.SubItems.Add(dr["lapmodel"].ToString());
                it.SubItems.Add(dr["lapserial"].ToString());
                it.SubItems.Add(dr["assetnumber"].ToString());
                it.SubItems.Add(dr["os"].ToString());
                it.SubItems.Add(dr["winlicense"].ToString());
                it.SubItems.Add(dr["office"].ToString());
                it.SubItems.Add(dr["officelicense"].ToString());
                it.SubItems.Add(dr["hddsize"].ToString());
                it.SubItems.Add(dr["processor"].ToString());
                it.SubItems.Add(dr["ram"].ToString());
                it.SubItems.Add(dr["macadress"].ToString());
                it.SubItems.Add(dr["ipadress"].ToString());

                listView1.Items.Add(it);

            }

            dr.Close();
            dr.Dispose();
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
        }

    }

    private void Modify_Shown(object sender, EventArgs e)
    {
        try
        {
            cn.Open();
            populate();
        }
        catch (SqlException ex)
        {
            MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
            Application.ExitThread();
        }
    }

    private void button1_Click(object sender, EventArgs e)
    {
listView1.Items.Clear(); // clear list items before adding 
    listView1.Items.AddRange(Items.Where(i=>string.IsNullOrEmpty(textBox1.Text)||i.Name.StartsWith(textBox1.Text))
        .Select(c => new ListViewItem(c.Name)).ToArray());

    }

    private void textBox1_TextChanged(object sender, EventArgs e)
    {



    }

    private void button2_Click(object sender, EventArgs e)
    {

    }

}

}

Best Answer

In your pupolate method do this:

    private void populate()
    {
        listView1.Items.Clear();
        SqlCommand cm;
        if(textBox1.Text == "")
           cm = new SqlCommand("SELECT * FROM lapdev", cn);
        else
            cm = new SqlCommand("SELECT * FROM lapdev WHERE YourField='" + textBox1.Text + "'", cn);


        try
        {

            SqlDataReader dr = cm.ExecuteReader();
            while (dr.Read())
            {

                ListViewItem it = new ListViewItem(dr["fillingcode"].ToString());
                it.SubItems.Add(dr["username"].ToString());
                it.SubItems.Add(dr["branch"].ToString());
                it.SubItems.Add(dr["department"].ToString());
                it.SubItems.Add(dr["agency"].ToString());
                it.SubItems.Add(dr["computername"].ToString());
                it.SubItems.Add(dr["lapmodel"].ToString());
                it.SubItems.Add(dr["lapserial"].ToString());
                it.SubItems.Add(dr["assetnumber"].ToString());
                it.SubItems.Add(dr["os"].ToString());
                it.SubItems.Add(dr["winlicense"].ToString());
                it.SubItems.Add(dr["office"].ToString());
                it.SubItems.Add(dr["officelicense"].ToString());
                it.SubItems.Add(dr["hddsize"].ToString());
                it.SubItems.Add(dr["processor"].ToString());
                it.SubItems.Add(dr["ram"].ToString());
                it.SubItems.Add(dr["macadress"].ToString());
                it.SubItems.Add(dr["ipadress"].ToString());

                listView1.Items.Add(it);

            }

            dr.Close();
            dr.Dispose();
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
        }

    }

and in your button click event:

    private void button1_Click(object sender, EventArgs e)
    {
         //listView1.Items.Clear(); // clear list items before adding 
         populate();
         //you type what you want in textbox then click button.
    }

you dont even need to call clear on button click because populate method already takes care of that.

Related Solutions

Java – How to filter a Java Collection (based on predicate)

Java 8 (2014) solves this problem using streams and lambdas in one line of code:

List<Person> beerDrinkers = persons.stream()
    .filter(p -> p.getAge() > 16).collect(Collectors.toList());

Here's a tutorial.

Use Collection#removeIf to modify the collection in place. (Notice: In this case, the predicate will remove objects who satisfy the predicate):

persons.removeIf(p -> p.getAge() <= 16);

lambdaj allows filtering collections without writing loops or inner classes:

List<Person> beerDrinkers = select(persons, having(on(Person.class).getAge(),
    greaterThan(16)));

Can you imagine something more readable?

Disclaimer: I am a contributor on lambdaj

C# – Should ‘using’ directives be inside or outside the namespace

There is actually a (subtle) difference between the two. Imagine you have the following code in File1.cs:

// File1.cs
using System;
namespace Outer.Inner
{
    class Foo
    {
        static void Bar()
        {
            double d = Math.PI;
        }
    }
}

Now imagine that someone adds another file (File2.cs) to the project that looks like this:

// File2.cs
namespace Outer
{
    class Math
    {
    }
}

The compiler searches Outer before looking at those using directives outside the namespace, so it finds Outer.Math instead of System.Math. Unfortunately (or perhaps fortunately?), Outer.Math has no PI member, so File1 is now broken.

This changes if you put the using inside your namespace declaration, as follows:

// File1b.cs
namespace Outer.Inner
{
    using System;
    class Foo
    {
        static void Bar()
        {
            double d = Math.PI;
        }
    }
}

Now the compiler searches System before searching Outer, finds System.Math, and all is well.

Some would argue that Math might be a bad name for a user-defined class, since there's already one in System; the point here is just that there is a difference, and it affects the maintainability of your code.

It's also interesting to note what happens if Foo is in namespace Outer, rather than Outer.Inner. In that case, adding Outer.Math in File2 breaks File1 regardless of where the using goes. This implies that the compiler searches the innermost enclosing namespace before it looks at any using directive.

Best Answer

Related Solutions

Java – How to filter a Java Collection (based on predicate)

C# – Should ‘using’ directives be inside or outside the namespace

Related Topic