how to search the dataset for specific data

Question

I just wanted to ask how to search dataset for specific data because I want to search summary for specific keywords and bind it to repeater I have where expression and it is not working ``` string keyword = "where summary like %"+ txtbKeyword.Text +"%" ; DataSet ds = new DataSet(); int selectedTopicID = Convert.ToInt32(ddlTopics.SelectedValue); int selectedSkillID = Convert.ToInt32(ddlSkills.SelectedValue); int selectedTypeID = Convert.ToInt32(ddlTypes.SelectedValue); ds = Resoursce.Search_Resource(selectedTopicID, selectedSkillID, selectedTypeID); lbl_totalResult.Text = ds.Tables[0].Rows.Count.ToString(); rp_resList.DataSource = ds.Tables[0].Select(keyword); rp_resList.DataBind(); ``` System.Data.SyntaxErrorException was unhandled by user code ``` HResult=-2146232032 Message=Syntax error: Missing operand after 'summary' operator. Source=System.Data StackTrace: at System.Data.ExpressionParser.Parse() at System.Data.DataExpression..ctor(DataTable table, String expression, Type type) at…

Accepted Answer

You could use the DataTable.Select() method. http://msdn.microsoft.com/en-us/library/t5ce3dyt.aspx

Microsoft's example:

```
  // Presuming the DataTable has a column named Date. 
  string expression = "Date = '1/31/1979' or OrderID = 2";
  // string expression = "OrderQuantity = 2 and OrderID = 2";

// Sort descending by column named CompanyName. 
  string sortOrder = "CompanyName ASC";
  DataRow[] foundRows;

// Use the Select method to find all rows matching the filter.
  foundRows = table.Select(expression, sortOrder);
```

how to search the dataset for specific data

Solution

Problem