How to fill DataTable using C#.Net

How to fill DataTable using C#.Net

Solution:

  // declare myTable
            DataTable myTable = new DataTable();

            //define columns along with their properties
            myTable.Columns.Add("ID", typeof(int));
            myTable.Columns.Add("Name", typeof(string));
            myTable.Columns.Add("Father name", typeof(string));
            myTable.Columns.Add("Gender", typeof(string));
            myTable.Columns.Add("Date of Registration", typeof(DateTime));

            //Add data into rows
            myTable.Rows.Add(1, "Hafiz Imtenan Elahi", "Haji Faqir Muhammad ", "Male", DateTime.Now);
            myTable.Rows.Add(2, "Hafiz Muhamad Umar Hayat", "Haji Faqir Muhammad ","Male", DateTime.Now);
            myTable.Rows.Add(3, "Muahammad Hashir", "Hafiz Imtenan Elahi", "Male", DateTime.Now);




            
            
            //get data from imaginary table(myTable) in console

            for (int i = 0; i < myTable.Rows.Count;i++ )
            {
                //print myTable row wise
                Console.Write("\t" + myTable.Rows[i]["ID"].ToString());//Rows[0]["ID"]= [rows][columns]
                Console.Write("\t" + myTable.Rows[i]["Name"].ToString());
                Console.Write("\t" + myTable.Rows[i]["Father name"].ToString());
                Console.Write("\t" + myTable.Rows[i]["Gender"].ToString());
                Console.Write("\t" + myTable.Rows[i]["Date of Registration"].ToString());


                Console.WriteLine("");

               
            }
   //get data from imaginary table(myTable) in windows Form
 dataGridView1.DataSource = myTable;


Comments