column.expression

[EmilH]

Hi.

The following line gives me exception 'Cannot find column Motherboard'
(where ;Motherboard = itemsLB.SelectedItem.ToString())

itemsTable.Columns["Name"].Expression = itemsLB.SelectedItem.ToString();

Thanks.

Emil

[EmilH]

I changed the line to this:
itemsTable.Columns["Name"].Expression = "Name = '" +
itemsLB.SelectedItem.ToString() + "'";

I get an exception of Circular reference. How can I filter the table for a
criteria?

"EmilH" <em*****@yahoo.comwrote in message
news:uK**************@TK2MSFTNGP03.phx.gbl...

Hi.

The following line gives me exception 'Cannot find column Motherboard'
(where ;Motherboard = itemsLB.SelectedItem.ToString())

itemsTable.Columns["Name"].Expression = itemsLB.SelectedItem.ToString();

Thanks.

Emil

[Jesse Houwing]

"EmilH" <em*****@yahoo.comwrote in message

news:uK**************@TK2MSFTNGP03.phx.gbl...

>Hi.

The following line gives me exception 'Cannot find column Motherboard'
(where ;Motherboard = itemsLB.SelectedItem.ToString())

itemsTable.Columns["Name"].Expression = itemsLB.SelectedItem.ToString();

* EmilH wrote, On 4-5-2007 10:04:

I changed the line to this:
itemsTable.Columns["Name"].Expression = "Name = '" +
itemsLB.SelectedItem.ToString() + "'";

I get an exception of Circular reference. How can I filter the table

for a

criteria?

You basically have two options here:

1) Use a Dataview
Dataview dv = new DataView(itemsTable, "Name = \"" +
itemsLB.SelectedItem.ToString(),"");

2) User Table.Select() to get the rows that match the criteria:
DataRow[] rows = itemsTable.Select(Name = \"" +
itemsLB.SelectedItem.ToString());

The Expression Property you're working with is not used to filter a
table, but to dynamically create a fieldvalue based on other data in the
table.

Jesse Houwing

[EmilH]

Thanks Jesse!
"Jesse Houwing" <je***********@nospam-sogeti.nlwrote in message
news:%2*****************@TK2MSFTNGP05.phx.gbl...

>"EmilH" <em*****@yahoo.comwrote in message
news:uK**************@TK2MSFTNGP03.phx.gbl...

>>Hi.

The following line gives me exception 'Cannot find column Motherboard'
(where ;Motherboard = itemsLB.SelectedItem.ToString())

itemsTable.Columns["Name"].Expression = itemsLB.SelectedItem.ToString();

* EmilH wrote, On 4-5-2007 10:04:

I changed the line to this:
itemsTable.Columns["Name"].Expression = "Name = '" +
itemsLB.SelectedItem.ToString() + "'";

I get an exception of Circular reference. How can I filter the table

for a

criteria?

You basically have two options here:

1) Use a Dataview
Dataview dv = new DataView(itemsTable, "Name = \"" +
itemsLB.SelectedItem.ToString(),"");

2) User Table.Select() to get the rows that match the criteria:
DataRow[] rows = itemsTable.Select(Name = \"" +
itemsLB.SelectedItem.ToString());

The Expression Property you're working with is not used to filter a table,
but to dynamically create a fieldvalue based on other data in the table.

Jesse Houwing