How to search A DataTable in c#

Question

0.00/5 (No votes)

See more:

When i execute this nothing happens
the datagridview does not update

C#

public void Search() 
{
   OleDbCommand ocm = new OleDbCommand("SELECT Firstname FROM students WHERE Firstname LIKE '% Hello %' ", conn);
   conn.Open(); 
   ocm.ExecuteNonQuery(); 
   conn.Close(); 
}

Posted 10-Jan-13 22:16pm

Member 9430088

Updated 22-Mar-23 4:26am

Sandeep Mewara

v2

Add a Solution

4 solutions

Add a Solution

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

Pete O'Hanlon · Answer 1 · 2013-01-10T22:34:00

ExecuteNonQuery is designed to issue commands like INSERT, DELETE or UPDATE. It's not intended for use in SELECTs. What you could do, is use ExecuteDataReader like this:

C#

private List<string> names = new List<string>();
public void Search() 
{
  using (OleDbCommand ocm = new OleDbCommand("SELECT Firstname FROM students WHERE Firstname LIKE '% Hello %' ", conn))
  {
    conn.Open(); 
    OleDbDataReader reader = ocm.ExecuteDataReader(); 
    while (reader.Read())
    {
      names.Add(reader[0]);
    }
    conn.Close(); 
  }
}

nhquynam · Answer 2 · 2013-01-10T22:44:00

Solution 2

You can use DataAdapter to get table from database :

C#

conn.Open();
OleDbDataAdapter ad = new OleDbDataAdapter("", conn);
DataTable dt = new DataTable();
ad.Fill(dt);
gridView.DataSource = dt;

Posted 10-Jan-13 22:44pm

nhquynam

Updated 11-Jan-13 1:59am

v4

Comments

Member 9430088 11-Jan-13 5:25am

sorry its still not working

wanglovesong · Answer 3 · 2013-01-11T16:49:00

Hi.You can refer to the following code.

C#

public void Search()
 {
   using (OleDbConnection con = new OleDbConnection(constring))
   {
      con.Open();
      OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT Firstname FROM students WHERE Firstname LIKE '% Hello %' ", con);
      DataTable tb = new DataTable();
      adapter.Fill(tb);
      dataGridView1.DataSource = tb;
   }
}

If you have any question,please contact me.

hisham elmsry · Answer 4 · 2023-03-22T04:26:00

Solution 4

LINQ-To-DataSet (which i prefer):

var filtered = tb.AsEnumerable()
    .Where(r => r.Field<String>("CREATOR").Contains(searchstring));
ADO.NET(DataTable.Select):

DataRow[] filteredRows = tb.Select("CREATOR LIKE '%" + searchstring + "%'");
ADO.NET(DataView.RowFilter):

 tb.DefaultView.RowFilter = "CREATOR LIKE '%" + searchstring + "%'";

Posted 22-Mar-23 4:26am

hisham elmsry

Comments

Dave Kreskowiak 22-Mar-23 13:53pm

You didn't understand the question, from 10 years ago.

How to search A DataTable in c#

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

How to search A DataTable in c#

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us