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
Post a Comment