How to remove columns after particular columns in datatable

Question

I want to remove columns from data table after particular columns.I have used Remove method but this is delete the '(Lead Time (WEEKS)))' columns i want to remove after the '(Lead Time (WEEKS)))' columns. How to do it I have used below code.     for (int i = 0; i < ds.Tables.Count; i++) { for (int j = 0; j < ds.Tables[i].Columns.Count; j++) { if (ds.Tables[i].Rows[7][j].ToString().Trim().Contains(Lead Time (WEEKS))) { int y = j; if (ds.Tables[i].Rows[7][y + 1].ToString().Trim() ==  || ds.Tables[i].Rows[7][y + 1].ToString().Trim() != ) { int y1 = y + 1;  ds.Tables[i].Columns.RemoveAt(y1); } } } }

Ananth G · Answer

refer this code DataSet ds = new DataSet(); DataTable objDt = new DataTable(); objDt.Columns.Add( A1 ); objDt.Columns.Add( Lead Time (WEEKS) ); objDt.Columns.Add( A3 ); objDt.Columns.Add( A4 ); objDt.Columns.Add( A5 ); objDt.Rows.Add(          ); ds.Tables.Add(objDt); for ( int i = 0; i { for ( int j = 0; j { if (ds.Tables[i].Columns.Contains( Lead Time (WEEKS) )) { int indexValue = ds.Tables[i].Columns[ Lead Time (WEEKS) ].Ordinal; for ( int k = ds.Tables[i].Columns.Count - 1; k > indexValue - 1; k--) { ds.Tables[i].Columns.RemoveAt(i); } } } }

Manas Mohapatra · Answer

Try with below code.. DataTable dataTable; // Removing columns dataTable.Columns.Remove( Lead Time (WEEKS) ); dataTable.Columns.RemoveAt(columnIndex); // Reordering the columns after remopving dataTable.Columns[ Qty ].SetOrdinal(0); dataTable.Columns[ Unit ].SetOrdinal(1); Note: Try not to put space in DataTable column name. Note: Try not to put space in DataTable column name.

Salman · Answer

Hi. I have this datatable. DataTable dt = new DataTable(); dt.Columns.Add(PrimaryRateId typeof(int)); dt.Columns.Add(Primary typeof(bool)); dt.Columns.Add(RateNumber typeof(int)); dt.Columns.Add(RateAmount typeof(decimal)); dt.Columns.Add(DuplicateId typeof(int)); dt.AcceptChanges(); and suppose i want to remove DuplicateId Column from my dt then dt .Columns.Remove(DuplicateId); thanks.