Monday, August 24, 2009

Enable Data Column readonly properties false in DataTable in C#

When you are getting data from Data Access Layer(DAL) as a DataTable. Here the particular Data Column readonly property is sets a TRUE. Suppose you want to update new values within the Data Column, use the below source code in C#.

public static DataTable CreateDataTable(DataTable dt)
{
foreach (DataRow dr in dt.Rows)
{
dt.Columns["Column Name"].ReadOnly = true;
dr.BeginEdit();
dr["Column Name"] = "New Value";
dr.EndEdit();
if (dr.RowState == DataRowState.Modified)
{ dr.AcceptChanges(); }
}
return dt;
}

No comments:

Post a Comment