Add new row in a data table

Hi, I have a DataBoundGrid bound to a datatable: dtblParts, and in it I display the following columns: CategoryID, PartID, Price and Quantity. Price column gets populated based on my selection in CategoryID and PartID. What I want now is that when I put in a value for Quantity a TotalPrice to be calculated and displayed somewhere on the form. To do that I do have a routine that checks the number of rows datatable has. Here is the problem: the number of rows is: 0. This is the way I initiate a "New part " operation: dtblParts.rows.Clear dtblParts.rows.AddNew grdParts.DataSource = dtblParts grdParts.Refresh The grid display a new row since the EnableAddNew = True but the datatable behind it does not have any rows. Unless I click on the next row and back in the previous row, I don't get a new row in the data table.

> Hi, > I have a DataBoundGrid bound to a datatable: dtblParts, and in it I display the following columns: CategoryID, PartID, Price and Quantity. Price column gets populated based on my selection in CategoryID and PartID. What I want now is that when I put in a value for Quantity a TotalPrice to be calculated and displayed somewhere on the form. To do that I do have a routine that checks the number of rows datatable has. Here is the problem: the number of rows is: 0. > > This is the way I initiate a "New part " operation: > > dtblParts.rows.Clear > dtblParts.rows.AddNew > grdParts.DataSource = dtblParts > grdParts.Refresh > > The grid display a new row since the EnableAddNew = True but the datatable behind it does not have any rows. Unless I click on the next row and back in the previous row, I don't get a new row in the data table. What does > dtblParts.rows.AddNew do? It is not a member of DataTable.Rows, is it. Normally to add a row, you would use code like Dim dr as DataRow = dataTable1.NewRow() ...populate dr ... dataTable1.Rows.Add(dr)