Looping through all rows of the DataTable

Here is the working example of looping through all rows of the DataTable. You can download the code and simply run it by placing to your IIS root folder.

Let me explain you looping through all rows of the DataTable step wise.

Download

 Download source code for Looping through all rows of the DataTable

Namespace to Use


using System.Data;

Steps


First lets place an asp:Literal control on your page. This control will be used to write the rows values as a string. (You may use asp:Label control too but literal best suits when you need to write raw html from server side)


Now get the data into DataTable using any of the DataSource. In this example I have used one .xml file.

Finally, write ForEach loop and manipulate the rows in whatever way you want.


Following is the function that will loop through the DataTable and print the data as displayed into the picture above.

 private void LoadDataTable()

    {

        string str = string.Empty;

        string path = Server.MapPath("~/GridData.xml");

        int i = 0;

        DataSet dSet = new DataSet();

        dSet.ReadXml(path);

        DataTable dTable = dSet.Tables[0];

        foreach (DataRow dRow in dTable.Rows)

        {

            i++;

            str += "ROW " + i.ToString() + " : <b>Name: </b>" + dRow["FirstName"].ToString() + " " + dRow["LastName"].ToString() + ", <b>Address: </b>"+ dRow["Address"].ToString() +", <b>Profession: </b>" + dRow["Profession"].ToString() + "<br />";

        }

        litText.Text = str;

    }

In the above function, I am declaring one dataset and getting data from .xml file using ReadXml method. Storing that datatable into a local DataTable variable. Then writing ForEach loop to loop through all the rows of the DataTable and storing into the string variabbles and finally specifying the .text property of the asp:literal control.

The working example is attached with this article, don't forget to download if you are facing any problem.

If you like this article, subscribe to our RSS Feed. You can also subscribe via email to our Interview Questions, Codes and Forums section.