how to make datatable as static

Question

bind data table if record is deleted or updated in database e.g if(database[table]!=datatable) { re bind datatable } else { load erailer binded table }

Gokhul Varman · Answer

How about with DynamicObject : public static class DataTableX { public static IEnumerable AsDynamicEnumerable( this DataTable table) { // Validate argument here.. return table.AsEnumerable().Select(row => new DynamicRow(row)); } private sealed class DynamicRow : DynamicObject { private readonly DataRow _row; internal DynamicRow(DataRow row) { _row = row; } // Interprets a member-access as an indexer-access on the // contained DataRow. public override bool TryGetMember(GetMemberBinder binder out object result) { var retVal = _row.Table.Columns.Contains(binder.Name); result = retVal ? _row[binder.Name] : null ; return retVal; } } } You could also try overriding TrySetMember if you wish to make the dynamic-row writable. Usage : DataTable table = ... var dynamicTable = table.AsDynamicEnumerable(); var firstRowsNameField = dynamicTable.First().Name; if you try this you can get a solution.