DataView or DataTable question

[DBC User]

I have a dataset with one table and I want to change one coumn value
to a fixed constant. Is it possible to do it without iterating through
each row?
Thanks.

 

[ClayB]

One thing you could try is to set the Expression property on that
column to be the constant.

datatable1.Columns["Col2"].Expression = "1888.1";

=====================
Clay Burch
Syncfusion, Inc.

 

[DBC User]

One thing you could try is to set the Expression property on that
column to be the constant.

datatable1.Columns["Col2"].Expression = "1888.1";

=====================
Clay Burch
Syncfusion, Inc.

This is what I am trying to replace to a single command

foreach (DataRow dr in rsDS.Tables[0].Rows)
{
dr[DataBaseNames.LocationName] = "1888.1";
}

If I use Expression I get an error message "Missing operand after
'Site' operator.

Thanks.

 

[sloan]

Why is there a period in this
DataBaseNames.LocationName
?


foreach (DataRow dr in rsDS.Tables[0].Rows)
{
if (null!= dr["mycolumnname"])
{
dr["mycolumnname"] = "1888.1";
}
}




with non strongly typed datasets, you need to always check for null
..........

One thing you could try is to set the Expression property on that
column to be the constant.

datatable1.Columns["Col2"].Expression = "1888.1";

=====================
Clay Burch
Syncfusion, Inc.

This is what I am trying to replace to a single command

foreach (DataRow dr in rsDS.Tables[0].Rows)
{
dr[DataBaseNames.LocationName] = "1888.1";
}

If I use Expression I get an error message "Missing operand after
'Site' operator.

Thanks.

 

[ClayB]

Is this the code you tried to set the Expression property of your
column?


rsDS.Tables[0].Columns[DataBaseNames.LocationName].Expression =
"1888.1";

====================
Clay Burch
Syncfusion, Inc.

 

[DBC User]

Is this the code you tried to set the Expression property of your
column?

rsDS.Tables[0].Columns[DataBaseNames.LocationName].Expression =
"1888.1";

====================
Clay Burch
Syncfusion, Inc.

Yes thats what I am trying and I am getting the site error I posted
earlier.
Thanks,