Binding Navigator Question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dorkboy
    New Member
    • Jan 2009
    • 1

    Binding Navigator Question

    Hi all,

    I am a newbie using VB.net in VS 2008.

    I took over a vb.net winform application that has a binding navigator in it.

    The users wanted to add 2 new fields to the form. I added the new fields to the SQL Server 2005 database. I refreshed the Data Source tab in the project. It recognizes the 2 new fields.

    I dragged them onto the form.

    When I go to add a record through the application, it does NOT save these 2 new fields. I check the properties for these 2 new fields under "Data Bindings" and it shows under the "Text" property the correct Binding Source and column name.

    Can any one help me with what I am doing wrong? I need to store these 2 new fields to the table.

    Thanks in advance.
  • OuTCasT
    Contributor
    • Jan 2008
    • 374

    #2
    Have you bound the data dynamically ???

    Code:
     
    sqlCurrencyManager.EndCurrentEdit()
    sqlcon.Open()
    Dim sqlUpdate As New SqlCommandBuilder(sqlEmployeeAdapter)
    Try
    sqlAdapter.Update(sqlDataTable)
    Catch sqlExc As SqlException
    MessageBox.Show(sqlExc.ToString, "SQL Exception Error!", _
    MessageBoxButtons.OK, MessageBoxIcon.Error)
    End Try
    sqlcon.Close()

    Comment

    Working...