Search in the DataTable

[NewToAspDotNet]

Hi, How can i search in all columns of a table for a word that the user types in a textbox? some code pls? :doh:

[N a v a n e e t h]

DataTable have a Select() method which allows you to filter DataTable and returns DataRow array.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

[il_masacratore]

Aproximately: ... DataTable dt = ... string sText = txtInput.Text; foreach(datacolumn in dt.columns) { if( typeof(datacolumn) == string ) { DataRow[] oRows = dt.Select(DataColumn.Name + " = " + sText); if( oRows.Count > 0 ) { //Do wat you have to do } } }

Visit my blog at http://dotnetforeveryone.blogspot.com