Filter int32 filed in RadGridView according to textbox

Emad Ahmed

I have a main form frmInnovation that contains a textbox txtInnovationID, and I have a Telerik RadGridView on the form TableSituations with a column InnovationNameID of type int32.
What I want to do is to filter the RadGridView on form load according to the txtInnovationID.

TableSituation.InnovationNameID = txtInnovationID

I use this code to filter strings, but how to modify to filter int32.

BindingSource bs = new BindingSource();
bs.DataSource = TableSituations.DataSource;
bs.Filter = TableSituations.Columns[2].HeaderText.ToString() + " LIKE '%" + txtInnovationID.Text + "%'";
TableSituations.DataSource = bs.DataSource;

I need also to change the code from "LIKE" to "Equals".

2 Replies

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

Bryian Tan9y ago
Accepted answer
Can you do something like this?
bs.Filter = TableSituations.Columns[2].HeaderText.ToString() + " = " + int.Parse(txtInnovationID.Text);
Emad Ahmed9y ago
Thanks @Brian, it works like charm

Another question:
If I want to apply multi filter how to do?
I used this method but not working
BindingSource bs2 = new BindingSource();
            bs2.DataSource = TableReplies.DataSource;
            bs2.Filter = TableReplies.Columns[1].HeaderText.ToString() + " = " + int.Parse(InnovationID.Text) AND TableReplies.Columns[3].HeaderText.ToString() + " = " + int.Parse(CompetitionNameID.Text);
            TableReplies.DataSource = bs2.DataSource;