How to check if columnname = 'xyz"' skip adding to xml in the for loop using C# console Application

Question

I reading the all xml data from db I want skip some columns how to skip some columns while reading in for loop Is there any way possible to skip

Reading from row node=1 using XMLElement
foreach (DataColumn col in dt.Columns)
{
   rowelement.Add(get(col.ColumnName,dr[col.ColumnName].ToString())); 
}

Answer 1

I'm not sure but may be you want something like this

foreach (DataColumn col in dt.Columns)
{
  if(!col.ColumnName.ToLower().Equals("xyz"))
   {
     rowelement.Add(get(col.ColumnName,dr[col.ColumnName].ToString())); 
   }
}

or may be if you have more columns to skip, then you can take them in List.

List<string> columnToSkipped=new List<string>{ "col1", "col2", "col3" };

then use your condition like this

   if(!columnToSkipped.Contains(col.ColumnName.ToLower()))
   {
      rowelement.Add(get(col.ColumnName,dr[col.ColumnName].ToString())); 
   }

Answer 2

In C# we have a nice keyword continue. It does precisely what you need. Usage is very simple.

foreach (DataColumn col in dt.Columns)
{
   if (someCondition) continue; // this skips the current iteration and proceeds with the loop

   rowelement.Add(get(col.ColumnName,dr[col.ColumnName].ToString())); 
}