Using Realtime search

Question

0.00/5 (No votes)

See more:

I am just a beginner,
Want to know how can I use gridview with MS ACCESS for realtime search
Like

SQL

select*From Source where desc like '%textSrch.text%

as an example.

I tried to get the data, but instead of deleting the number of rows it is adding.

Help

Posted 3-Jan-12 3:23am

santosh.giri

Updated 3-Jan-12 3:43am

Anuja Pawar Indore

v2

Add a Solution

Comments

Amir Mahfoozi 3-Jan-12 9:26am

Please provide the filtering part of your code.

3 solutions

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)

Wendelius · Accepted Answer · 2012-01-03T04:45:00

One way to do the filtering is to repopulate the underlying data from the database. However, depending on the situation this may be both time and resource consuming.

Other possibilities are for example:

If you're using for example BindingSource, you can apply a filter on it. This way the data remains the same but only the relevant portion is shown. For more information, see: BindingSource.Filter Property [^]

If you fetch the data into a DataTable from the database you can define a DataView which filters the desired rows from your DataTable and assign that view as your datasource to a grid etc. More information: DataView.RowFilter Property [^]

The expressions you can use are listed in DataColumn.Expression Property [^]

Ganesan Senthilvel · Accepted Answer · 2012-01-03T04:07:00

Populate the search result in grid view using the below code:

C#

protected void Page_Load(object sender, EventArgs e)
{
string strSQLconnection = "Data Source=dbServer;Initial Catalog=testDB;Integrated Security=True";
SqlConnection sqlConnection = new SqlConnection(strSQLconnection);
SqlCommand sqlCommand = new SqlCommand("select * From Source where desc like '%textSrch.text%'", sqlConnection);
sqlConnection.Open(); 

SqlDataReader reader = sqlCommand.ExecuteReader();       

GridView1.DataSource = reader;
GridView1.DataBind();
}

santosh.giri · Accepted Answer · 2012-01-03T05:12:00

Thanx for helping,
It was not much hard, I did by self using this

C#

private void textBox1_TextChanged(object sender, EventArgs e)
{
 Conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Database.mdb";
            string txt;
            txt = "%" + textBox1.Text + "%";
            string query = "Select keys, desc from source where desc like '"+txt+"'";
            OleDbDataAdapter da = new OleDbDataAdapter(query, Conn);
            
            OleDbCommandBuilder cmd = new OleDbCommandBuilder(da);
            DataTable dt = new DataTable();
            da.Update(dt);
            da.Fill(dt);

            BindingSource bn = new BindingSource();
            bn.DataSource = dt;

            dataGridView1.DataSource = bn;
}

and it is working fine...

Using Realtime search

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0