Adding a column to a datatable and populating column with default value

Try this with DataRow.EndEdit:

           For i As Integer = 0 To m_MissingDocsTable.Rows.Count - 1
                Dim dr As DataRow = m_MissingDocsTable.Rows(i)
                dr("Status") = "Print"
                dr.EndEdit()
            Next


Bob

Try

            dcStatus.DefaultValue = "Print"

just before

            m_MissingDocsTable.Columns.Add(dcStatus)

Roger

Grid still returning Null for "Status" Column

   Dim dcStatus As New DataColumn("Status", GetType(String))
            m_MissingDocsTable.Columns.Add(dcStatus)

            For i As Integer = 0 To m_MissingDocsTable.Rows.Count - 1
                Dim dr As DataRow = m_MissingDocsTable.Rows(i)
                dr("Status") = "Print"
                dr.EndEdit()
            Next

            Me.gridMissingDocs.DataSource = MissingDocsTable

I added a message box to see what the Value is  and it does return "Print"

 Dim dcStatus As New DataColumn("Status", GetType(String))
            m_MissingDocsTable.Columns.Add(dcStatus)

            For i As Integer = 0 To m_MissingDocsTable.Rows.Count - 1
                Dim dr As DataRow = m_MissingDocsTable.Rows(i)
                dr("Status") = "Print"
                dr.EndEdit()
            Next
            MessageBox.Show(MissingDocsTable.Rows(0)("Status"))
            Me.gridMissingDocs.DataSource = MissingDocsTable

Do you have a DataGridTableStyle defined?  Are you mapping to the column?

Bob

The Setting of the Default Value worked but why does MessageBox show "Print" but the datagrid shows "Null"

I was going to add a TableStyle after I knew the information is correct.  

I added the tablestyle and it still return null

Forget the dv.Table line.  That was just me experimenting to see if a dataview made any difference.

Roger

just a question

you are adding a column to table  m_MissingDocsTable

but you use a different table for the grid ?

Me.gridMissingDocs.DataSource = MissingDocsTable