Add, Edit, Delete Operations on DataTable in C#

Before perform any operation on DataTable you need to add Following Namespace into your Application

Using System.Data

Intoduction

DataTable is a Table which having rows and columns.

using System;

using System.Data;

 

namespace OperationOnDataTable

{

    class Program

    {

        static void Main(string[] args)

        {

            // Initializes a new instance of the System.Data.DataTable class with the specified table name.

            DataTable tempTable = new DataTable();

            // Add columns in DataTable

            tempTable.Columns.Add("ID");

            tempTable.Columns.Add("NAME");

            // Add New Row in dataTable

            DataRow newrow = tempTable.NewRow();

            newrow[0] = 0;

            newrow[1] = "Avinash";

            tempTable.Rows.Add(newrow);

            // Add Another New Row in dataTable

            newrow = tempTable.NewRow();

            newrow[0] = 1;

            newrow[1] = "Kavita";

            tempTable.Rows.Add(newrow);

            //Now table is ready

            Console.WriteLine("Origenal table");

            for (int i = 0; i < tempTable.Rows.Count; i++)

            {

                Console.WriteLine(tempTable.Rows[i][0].ToString() + "--->" + tempTable.Rows[i][1].ToString());

            }

            // if you want edit data form TataTable

            Console.WriteLine("\nModified table");

            for (int i = 0; i < tempTable.Rows.Count; i++)

            {

                if (tempTable.Rows[i][1].ToString() == "Kavita")

                {

                    tempTable.Rows[i][1] = "gare";

                }

                Console.WriteLine(tempTable.Rows[i][0].ToString() + "--->" + tempTable.Rows[i][1].ToString());

            }

            // if you want delete row form TataTable

            Console.WriteLine("\nAfter deleting row from table");

            for (int i = 0; i < tempTable.Rows.Count; i++)

            {

                if (tempTable.Rows[i][1].ToString() == "gare")

                {

                    tempTable.Rows[i].Delete();

                }

            }

            for (int i = 0; i < tempTable.Rows.Count; i++)

            {

                Console.WriteLine(tempTable.Rows[i][0].ToString() + "--->" + tempTable.Rows[i][1].ToString());

            }

            Console.ReadLine();

        }

    }

}

********** OUTPUT *********

Origenal table

0--->Avinash
1--->Kavita

Modified table
0--->Avinash
1--->gare

After deleting row from table

0--->Avinash