Before performing any operation on the DataTable you need to add the Following Namespace into your Application.
Using System.Data
Intoduction
DataTable is a Table which has 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