Search using like query in datatable.

Question

Hi I am having the Datatable which has the Rows like Follow. component/header/publicationMeta/publication/section component/header/publicationMeta/publication/number component/header/publicationMeta/publication/page component/header/publicationMeta/publication/lpage i want to search the row which is end with section or number using like query in datatable. i give the inuput in textbox. Can any one answer my question. Thanks in Advance.

Dharmraj Thakur · Answer

You can make query like... lets assume you have a data in dt object then you have to fire select command with following condition. DataTable dt=getDataTableFromDb(); DataRow[] dr = dt.Select( fieldName like '%section' );

Karthi Keyan · Answer

@Dharmaraj Thanks Boss. i Did.