How to add new DataRow into DataTable

Question

I have a DataGridView binded to a DataTable  DataTable binded to database   I need to add a DataRow to the DataTable  I m trying to use the following code   dataGridViewPersons BindingContext table  EndCurrentEdit    DataRow row   table NewRow     for  int i   0  i  lt  28  i          row i    i ToString        But it doesn t work  DataGridView has never been added a new row  Please  tell me  how can I fix my code    Thank you in advance

User · Answer

You have to add the row explicitly to the table  table Rows Add row

User · Answer

Creating a new row with the structure of the table   DataTable table   new DataTable    DataRow row   table NewRow    table Rows Add row       Giving values to the columns of the row this row is supposed to have 28 columns    for  int i   0  i  lt  28  i          row i    i ToString

User · Answer

I found dotnetperls examples on DataRow very helpful  Code snippet for new DataTable from there   static DataTable GetTable            Here we create a DataTable with four columns      DataTable table   new DataTable        table Columns Add  Weight   typeof int        table Columns Add  Name   typeof string        table Columns Add  Breed   typeof string        table Columns Add  Date   typeof DateTime            Here we add five DataRows      table Rows Add 57   Koko    Shar Pei   DateTime Now       table Rows Add 130   Fido    Bullmastiff   DateTime Now       table Rows Add 92   Alex    Anatolian Shepherd Dog   DateTime Now       table Rows Add 25   Charles    Cavalier King Charles Spaniel   DateTime Now       table Rows Add 7   Candy    Yorkshire Terrier   DateTime Now        return table

User · Answer

If need to copy from another table then need to copy structure first   DataTable copyDt   existentDt Clone    copyDt ImportRow existentDt Rows 0

User · Answer

You can try with this code - based on Rows Add method  DataTable table   new DataTable    DataRow row   table NewRow    table Rows Add row     Link   https   msdn microsoft com en-us library 9yfsd47w aspx

User · Answer

GRV DataSource   Class1 DataTable              GRV DataBind     Class1 GRV Rows e RowIndex  Delete            GRV DataSource   Class1 DataTable          GRV DataBind

User · Answer

This works for me   var table   new DataTable    table Rows Add

User · Answer

try table Rows add row   after your for statement

[c#] How to add new DataRow into DataTable?

Examples related to c#

Examples related to datagridview

Examples related to datatable

Examples related to datarow