Searching database through textbox and show the result in a listview

Question

0.00/5 (No votes)

See more:

When i put a text into a textbox using textchanged event the listview shows data repeatedly .

What I have tried:

i have already used this code below here ,

C#

string name = textboxsearch.Text;
if (textboxsearch.Text != "")
{
    con.Open();
    string str = "select * from all_record where title like'" + name + "%'";
    OleDbCommand cmd = new OleDbCommand(str, con);
    OleDbDataReader dr = cmd.ExecuteReader();
    if (dr.Read())
    {
        dr.Close();                    
        OleDbDataReader dr1 = cmd.ExecuteReader();
        while (dr1.Read())
        {
            listView1.Visible = true;
            ListViewItem item = new ListViewItem(dr1["title"].ToString());
            item.SubItems.Add(dr1["last_name"].ToString());
            item.SubItems.Add(dr1["Age"].ToString());
            listView1.Items.Add(item);
        }
        dr1.Close();
    }
    else
    {
        listView1.Visible = false;
        listView1.Items.Clear();
    }
    con.Close();
}
else
{
    listView1.Visible = false;
    listView1.Items.Clear();
}

Posted 26-Aug-16 2:30am

Member 12704984

Updated 26-Aug-16 3:48am

Richard MacCutchan

v2

Add a Solution

Comments

Richard MacCutchan 26-Aug-16 8:39am

Why do you create two OleDbDataReader objects?

Richard MacCutchan 26-Aug-16 8:46am

Most likely because the TextChanged event gets fired for every character that is typed. You need some way of ensuring that you only call this code when the user has stopped typing.

Member 12704984 26-Aug-16 9:27am

Richard u correct , have you any solution ?

Richard MacCutchan 26-Aug-16 9:42am

You need to choose a different event (maybe LostFocus), or find some other way to determine when you have all the text. Much depends on the requirements of the application.

Member 12704984 26-Aug-16 9:51am

viewed all events .

Richard MacCutchan 26-Aug-16 10:38am

Is that supposed to tell me something?

$*Developer - Vaibhav*$ 26-Aug-16 9:25am

Or you can add your code TextBox_Leave event

Member 12704984 26-Aug-16 9:28am

I already tried there but also same result .

$*Developer - Vaibhav*$ 26-Aug-16 9:45am

For your ref :

http://www.c-sharpcorner.com/uploadfile/9a3ae2/using-listview-control-windows-form-application3/

Member 12704984 26-Aug-16 9:50am

this isn't kind of my solution.

Richard Deeming 26-Aug-16 10:06am

Everything you wanted to know about SQL injection (but were afraid to ask) | Troy Hunt[^]
How can I explain SQL injection without technical jargon? | Information Security Stack Exchange[^]
Query Parameterization Cheat Sheet | OWASP[^]

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Answer 1 · 2016-08-26T03:48:00

try this
two datareaders is not necessary. and its good to clear the values initially on the event call, so that duplicates wont be there.

C#

string name = textboxsearch.Text;

      listView1.Visible = false;
      listView1.Items.Clear();
      if (name != "")
      {

          con.Open();
          string str = "select * from all_record where title like'@name%'";
          OleDbCommand cmd = new OleDbCommand(str, con);
          cmd.Parameters.Add("@name",name);
          OleDbDataReader dr1 = cmd.ExecuteReader();
              while (dr1.Read())
              {
                  listView1.Visible = true;
                  ListViewItem item = new ListViewItem(dr1["title"].ToString());
                  item.SubItems.Add(dr1["last_name"].ToString());
                  item.SubItems.Add(dr1["Age"].ToString());
                  listView1.Items.Add(item);
              }
              dr1.Close();
           con.Close();
       }

      }

refer this regarding sql injection[^]