how to iterate Data Table

I have below DataTable with 2 columns (AttrName and DataType) ,

AttrName	DataType
Company_ID	Decimal(15,0)
Company_Name	Varchar(500)

 

I am preparing an XML schema base on above data so I need to iterate the above DataTable and need string like below,

Please help me how can I iterate and make string like below…

string str = string.Empty;

 

        str += "<xsd:element name=\"Company_ID\" type=\"xsd:decimal\" />";

        str += "<xsd:element name=\"Company_Name\" type=\"xsd:string\" />";

 

You can use the following loop to fetch the column names:

// Get the column names and their types.
for (int j=0; j< dvColumns.Count; j++)
{
// Get the name of the column.
drvCols = dvColumns[j];
sColName = drvCols.Row.ItemArray[3].ToString();

later you can concatenate the other xsd elements to the existing column names.

Thanks

If you want to loop through a DataTable, here's one way of doing it:

foreach (DataRow dataRow in DataTable1.Rows) {

    foreach (DataColumn dataColumn in DataTable1.Columns) {

      string val = dataRow[dataColumn].ToString();

   }

}