The C# DataTable is defined as the class which contains a number of rows and columns for to storing and retrieving the data’s from both the memory and the database; it also represents the grid forms in the UI areas; it’s a C# ADO.NET package class using that class we can add the datas to the datatable, and we will bind the datas in the same both datatable and datagridview controls using the data binding concepts. It also contains the primary key that depends upon the one or more number of columns in the table, and the data collections are only the uniqueness in the rows and columns values.
Normally the datatable class provides the set of methods and properties for CRUD operations and additionally like a copy, remove and clone operations. The datatable class have the methods like to add or remove the rows and columns in the table.
using system; using System.Data; class classname { returntype methodname() { DataTable referencename=new DataTable(); referencename.Columns.Add(); //Adding the columns to the table referencename.Rows.Add(); // Adding the rows to the table ---some logics— } Main() { DataTable referencename=methodname(); ---some logics based on the requirement--- } }
The above codes are the basic syntax for the datatable in the C# language. We can do the Add or Remove operation from both the rows and columns. It has some predefined methods in the datatable for storing and retrieving the datas in the database.
Given below are the examples of C# DataTable:
Code:
using System; using System.Data; public class Example { public static void Main() { DataTable dtable = new DataTable(); dtable.Columns.Add("SNO", typeof(int)); dtable.Columns.Add("Name", typeof(string)); dtable.Columns.Add("City", typeof(string)); dtable.Columns.Add("Date", typeof(DateTime)); dtable.Rows.Add(1, "Siva", "TUP", DateTime.Now); dtable.Rows.Add(2, "Raman", "MAS", DateTime.Now); dtable.Rows.Add(3, "Sivaraman", "TRY", DateTime.Now); dtable.Rows.Add(4, "Kuble", "MDU", DateTime.Now); dtable.Rows.Add(5, "Arun", "Salem", DateTime.Now); dtable.Rows.Add(6, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(7, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(8, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(9, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(10, "sddd", "erf", DateTime.Now); dtable.Rows.Add(1, "Siva", "TUP", DateTime.Now); dtable.Rows.Add(2, "Raman", "MAS", DateTime.Now); dtable.Rows.Add(3, "Sivaraman", "TRY", DateTime.Now); dtable.Rows.Add(4, "Kuble", "MDU", DateTime.Now); dtable.Rows.Add(5, "Arun", "Salem", DateTime.Now); dtable.Rows.Add(6, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(7, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(8, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(9, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(10, "sddd", "erf", DateTime.Now); dtable.Rows.Add(11, "Siva", "TUP", DateTime.Now); dtable.Rows.Add(12, "Raman", "MAS", DateTime.Now); dtable.Rows.Add(13, "Sivaraman", "TRY", DateTime.Now); dtable.Rows.Add(14, "Kuble", "MDU", DateTime.Now); dtable.Rows.Add(1, "Arun", "Salem", DateTime.Now); dtable.Rows.Add(16, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(17, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(18, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(19, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(20, "sddd", "erf", DateTime.Now); dtable.Rows.Add(21, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(22, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(23, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(24, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(25, "sddd", "erf", DateTime.Now); dtable.Rows.Add(26, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(27, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(28, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(29, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(30, "sddd", "erf", DateTime.Now); dtable.Rows.Add(20, "sddd", "erf", DateTime.Now); dtable.Rows.Add(31, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(32, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(33, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(34, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(35, "sddd", "erf", DateTime.Now); dtable.Rows.Add(36, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(37, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(38, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(39, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(40, "sddd", "erf", DateTime.Now); dtable.Rows.Add(41, "sddd", "erf", DateTime.Now); dtable.Rows.Add(42, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(43, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(44, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(45, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(46, "sddd", "erf", DateTime.Now); dtable.Rows.Add(47, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(48, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(49, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(50, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(51, "sddd", "erf", DateTime.Now); int n=0; DataRow[] row; row = dtable.Select("City='Tup'"); n = row.Length; Console.WriteLine(“Welcome Users”); Console.WriteLine(n); } }
Output:
Code:
using System; using System.Data; public class Example { public static void Main() { DataTable dtable = new DataTable(); dtable.Columns.Add("SNO", typeof(int)); dtable.Columns.Add("Name", typeof(string)); dtable.Columns.Add("City", typeof(string)); dtable.Columns.Add("Date", typeof(DateTime)); dtable.Rows.Add(1, "Siva", "TUP", DateTime.Now); dtable.Rows.Add(2, "Raman", "MAS", DateTime.Now); dtable.Rows.Add(3, "Sivaraman", "TRY", DateTime.Now); dtable.Rows.Add(4, "Kuble", "MDU", DateTime.Now); dtable.Rows.Add(5, "Arun", "Salem", DateTime.Now); dtable.Rows.Add(6, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(7, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(8, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(9, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(10, "sddd", "erf", DateTime.Now); dtable.Rows.Add(11, "Siva", "TUP", DateTime.Now); dtable.Rows.Add(12, "Raman", "MAS", DateTime.Now); dtable.Rows.Add(13, "Sivaraman", "TRY", DateTime.Now); dtable.Rows.Add(14, "Kuble", "MDU", DateTime.Now); dtable.Rows.Add(15, "Arun", "Salem", DateTime.Now); dtable.Rows.Add(16, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(17, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(18, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(19, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(20, "sddd", "erf", DateTime.Now); dtable.Rows.Add(21, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(22, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(23, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(24, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(25, "sddd", "erf", DateTime.Now); dtable.Rows.Add(26, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(27, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(28, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(29, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(30, "sddd", "erf", DateTime.Now); foreach (DataRow r in dtable.Rows) { Console.WriteLine("SNO: {0}\t Name : {1} \t City: {2} \t Date: {3} \t ", r[0], r[1], r[2], r[3]); } } }
Output:
Code:
using System; using System.Data; public class Example { public static DataTable demo() { DataTable dtable = new DataTable(); dtable.Columns.Add("SNO", typeof(int)); dtable.Columns.Add("Name", typeof(string)); dtable.Columns.Add("City", typeof(string)); dtable.Columns.Add("Date", typeof(DateTime)); dtable.Rows.Add(1, "Siva", "TUP", DateTime.Now); dtable.Rows.Add(2, "Raman", "MAS", DateTime.Now); dtable.Rows.Add(3, "Sivaraman", "TRY", DateTime.Now); dtable.Rows.Add(4, "Kuble", "MDU", DateTime.Now); dtable.Rows.Add(5, "Arun", "Salem", DateTime.Now); dtable.Rows.Add(6, "Kumar", "Erode", DateTime.Now); dtable.Rows.Add(7, "ghasj", "Tup", DateTime.Now); dtable.Rows.Add(8, "dsfd", "yercaud", DateTime.Now); dtable.Rows.Add(9, "dsdf", "ui", DateTime.Now); dtable.Rows.Add(10, "sddd", "erf", DateTime.Now); return dtable; } public static void Main() { DataTable tables = demo(); foreach (DataRow r in tables.Select()) { if (r["SNO"].ToString().Equals("2")) { tables.Rows.Remove(r); } } Console.WriteLine("Welcome After removing the datas"); foreach (DataRow r1 in tables.Rows) { Console.WriteLine("SNO: {0}\t Name : {1} \t City: {2} \t Date: {3} \t ", r1[0], r1[1], r1[2], r1[3]); } } }
Output:
The datatable class is also used for the other predefined classes and the objects of the tables, and mainly this is coordinated and tied with each other. And also, the application wises the datas to be populated directly from the database. Using the datagrid view, the datas are shown on the user screen.
The above is the detailed content of C# DataTable. For more information, please follow other related articles on the PHP Chinese website!