Column 'xxxxxx' does not belong to table when Adding a empty row to a datagrid

[ptown]

Hello, I have form that allows me to enter multiple items and perform a batch insert into the DB. I want to add a button, Add Row_Click to add aditional rows without losing the data already in the grid, But I am running into problem

using the Add Row Click and receive the error: Column 'CustomerID' does not belong to table. Please tell me what I am doing wrong?

 

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
       Dim DT As New DataTable
       If (Not Page.IsPostBack) OrElse (Not (TypeOf Session("DT") Is DataTable)) Then

           'Create Empty Datatable
           'DT = CType(gvParts.DataSource, DataTable)
           DT = New DataTable("AddExtraRow")
           'DT.Columns.Add("LN", Type.GetType("System.String"))
           DT.Columns.Add("CustomerID", Type.GetType("System.String"))
           DT.Columns.Add("BarcodeAttached", Type.GetType("System.String"))
           DT.Columns.Add("Barcode", Type.GetType("System.String"))
           DT.Columns.Add("RevisionPart", Type.GetType("System.String"))
           DT.Columns.Add("RevisionDescription", Type.GetType("System.String"))
           DT.Columns.Add("ComponentLoaction", Type.GetType("System.String"))
           DT.Columns.Add("LocationID", Type.GetType("System.String"))
           DT.Columns.Add("Part_SerialNumber", Type.GetType("System.String"))
           DT.Columns.Add("Part_number", Type.GetType("System.String"))
           DT.Columns.Add("UPC", Type.GetType("System.String"))
           DT.Columns.Add("unit_price", Type.GetType("System.String"))
           DT.Columns.Add("PropertyTypeID", Type.GetType("System.String"))
           DT.Columns.Add("ComponentClassification", Type.GetType("System.String"))
           DT.Columns.Add("RecvCondition", Type.GetType("System.String"))
           DT.Columns.Add("Received_Qty", Type.GetType("System.String"))
           DT.Columns.Add("UOI", Type.GetType("System.String"))
           DT.Columns.Add("ConditionCodeID", Type.GetType("System.String"))
           DT.Columns.Add("Time_stamp_Received", Type.GetType("System.String"))
           DT.Columns.Add("Remarks", Type.GetType("System.String"))

           'Store the table in the Session variable
           Session("DT") = DT

           ' Bind the DataGrid to an empty table 
           'gvParts.DataSource = DT
          ' gvParts.DataBind()

       Else
           ' Retrieve the table from the session variable
           DT = CType(Session("DT"), DataTable)
       End If

   End Sub

   Protected Sub AddRow_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles AddRow.Click

       If (IsNumeric(RowCount.Text)) Then
           Dim i As Integer
           For i = 1 To CInt(RowCount.Text)
               Dim DT As New DataTable
               Dim DR As DataRow = DT.NewRow()
               DR("CustomerID") = RowCount.Text
               DT.Rows.Add(DR)

               'Bind & Show New row(s) in grid
               gvParts.DataSource = DT
               gvParts.DataBind()
           Next
       End If

   End Sub

****************************************************

Reference to the form below is created

*************************

 

Receiving Form Example
*****************************
RecivingID______     # of Line Items______ MkGrid

LineNO | Part# | PartSerial# | PartName | Qty | Remarks
---------------------------------------------------------------------------
1.
2.
3.
4
5
Add Extra Rows Click____

 

Place a "Make grid" button next to the # of Line Items. When the user has filled in the number and clicked the button, put something like the following in the button click method.......

 

Create a new datatable and populate a column with the # of Line Items:

Protected Sub MakeGrid_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton1.Click
Dim dt As New Data.DataTable
       dt.Columns.Add(New Data.DataColumn("LineNO"))
       For i As Integer = 1 To tbItems.Text
           Dim dr As Data.DataRow
           dr = dt.NewRow
           dr("LineNO") = i
           dt.Rows.Add(dr)
       Next
       'Bind the DataTable to the DataGrid
       gvParts.DataSource = dt
       gvParts.DataBind()
      

The gridview will need to have six columns. The first one will just be a bound column to the LineNO column of the data table. The following Five columns will be template columns with text boxes :

Note I left out the other fields Template fields to save space.

[highlight=asp]

<asp:GridView ID="gvParts" runat="server" AutoGenerateColumns="False">

<Columns>

<asp:BoundField DataField="PartNo" />

<asp:TemplateField HeaderText="Part #">

<ItemTemplate>

<asp:TextBox ID="part_number" runat="server" />

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

[/highlight]

Then when they submit their form, I want to iterate through the rows of the gridview, getting the textbox values and inputting into database

 

Note I left out the other fields Template fields to save space.

 

Protected Sub AddReceiving_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles AddReceiving.Click

       'Add new received components to the receiving table
       Dim tblReceiving As New partdb.tblReceivingDataTable()
       For Each gvr As GridViewRow In gvParts.Rows
           If gvr.RowType = DataControlRowType.DataRow Then
               
               'Add a new ProductsRow to the Receiving DataTable
               Dim part_number As TextBox = CType(gvr. 


               'Add a new receiving row to the to the ReceivingDataTable
               Dim newReceiving As partdb.tblReceivingRow = tblReceiving.NewtblReceivingRow()

               ' Assign the values from the web page
               newReceiving.Part_number = part_number.Text

               ' Add any "default" values
               newReceiving.Archive = False
               newReceiving.ProcessFlag = False
               newReceiving.time_stamp_entry = Date.Now
               tblReceiving.AddtblReceivingRow(newReceiving)                
           End If
       Next

    End Sub

Edited December 6, 2007 by PlausiblyDamp

[PlausiblyDamp]

In the Form_Load you are declaring the DT variable - this will fall out of scope when the Form_Load method exits. You are then declaring a new variable (that just happens to share the DT name) in the AddRow_Click method.

 

You would probably need to store DT in a session variable or similar so it would survive between postbacks.