Loading

desiging advanced search

faraz akram

16y2.1k.NET

hi,
i want to develop a serch sereen in C# using dataset windows application
for instance i have a datagrid wth a text box when i enter 1 the datagrid shld be filled by numbers starting from 1 or when i enter 123 it shld be filled dynamically with numbers starting from 123.
the action shld be done on dataentry on text box
regards

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mahesh Chand16y ago
You can also use a DataView class. Here is an example. Look at RowFilter property. This is where you want to add your condition something like this. I am not sure about exact syntax but close enough.
string keyword = TextBox1.Text;
"ColumnName LIKE %'+keyword+'%"
DataView view = new DataView();

view.Table = DataSet1.Tables["TableName"];
view.RowFilter = keyword;
DataGrid1.DataSource = view;
0
Mahesh Chand16y ago
On TextBox's TextChanged event hander, you can fillter your DataSet and rebind DataSet to DataGrid.
I think you can do something like this:
string filter = "ColumnName LIKE %keyword%";
DataRow[] foundRows = dataSet1.Tables["TableName"].Select(filter);

DataGrid.DataSource = foundRows;

0