Syntax of Rowfilter in DataView In C#

Question

5.00/5 (1 vote)

See more:

Hi,

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
             dv = ds.Tables["Employee"].DefaultView;
             dv.RowFilter = "Deptno=" + comboBox1.SelectedItem;
             dataGridView1.DataSource = dv;
        }

Can Anybody tell me what is the error in the above code.
I am getting error "Cannot find column [System.Data.DataRowView]."

Thanks,
Thiru

Posted 26-Jul-11 18:33pm

Donthi Thirupathi Reddy

Updated 19-Jan-21 8:16am

Add a Solution

6 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

m@dhu · Answer 1 · 2011-07-26T18:54:00

Solution 1

The message is self explanatory. It cannot find the column name. Make sure your select query has the column name.

Posted 26-Jul-11 18:54pm

m@dhu

TnTinMn · Answer 2 · 2013-05-02T13:19:00

Quote:
dv.RowFilter = "Deptno=" + comboBox1.SelectedItem;

I suspect that comboBox1 is bound to a datatable; then the SelectedItem will be type System.Data.DataRowView.

The implict conversion of comboBox1.SelectedItem to a string will yield "Deptno=System.Data.DataRowView".

Try:

dv.RowFilter = "Deptno=" + ((DataRowView)ComboBox1.SelectedItem).Row("Your Desired Column").ToString()

ayuu · Answer 3 · 2013-05-02T21:50:00

Solution 4

write just

dv.RowFilter = "Deptno=" + comboBox1.SelectedItem.toString();

Posted 2-May-13 21:50pm

ayuu

CH Guravaiah · Answer 4 · 2013-05-02T04:56:00

Solution 2

C#

dv = ds.Tables["Employee"].DefaultView;
             dv.RowFilter = "Deptno=" + comboBox1.SelectedItem;
             dataGridView1.DataSource = dv.DefaultView;

Posted 2-May-13 4:56am

CH Guravaiah

vin aroar · Answer 5 · 2015-01-16T18:54:00

Solution 5

Hi
You must pass dv.RowFilter = "Deptno= '"+ comboBox1.SelectedItem +"' ";

Posted 16-Jan-15 18:54pm

vin aroar

Member 15050522 · Answer 6 · 2021-01-19T08:16:00

dv = ds.Tables["Employee"].DefaultView;
dv.RowFilter = "Deptno=" + comboBox1.SelectedText;
dataGridView1.DataSource = dv;

or

dv = ds.Tables["Employee"].DefaultView;
dv.RowFilter = "Deptno=" + comboBox1.GetItemText(comboBox1.SelectedItem);
dataGridView1.DataSource = dv;

Syntax of Rowfilter in DataView In C#

6 solutions

Solution 1

Solution 3

Solution 4

Solution 2

Solution 5

Solution 6

Add your solution here

Preview 0

Syntax of Rowfilter in DataView In C#

6 solutions

Solution 1

Solution 3

Solution 4

Solution 2

Solution 5

Solution 6

Add your solution here

Preview 0

Existing Members

...or Join us