By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,759 Members | 1,227 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,759 IT Pros & Developers. It's quick & easy.

Binding Navigator Question

P: 1
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.
Jan 16 '09 #1
Share this Question
Share on Google+
1 Reply


OuTCasT
100+
P: 374
Have you bound the data dynamically ???

Expand|Select|Wrap|Line Numbers
  1.  
  2. sqlCurrencyManager.EndCurrentEdit()
  3. sqlcon.Open()
  4. Dim sqlUpdate As New SqlCommandBuilder(sqlEmployeeAdapter)
  5. Try
  6. sqlAdapter.Update(sqlDataTable)
  7. Catch sqlExc As SqlException
  8. MessageBox.Show(sqlExc.ToString, "SQL Exception Error!", _
  9. MessageBoxButtons.OK, MessageBoxIcon.Error)
  10. End Try
  11. sqlcon.Close()
  12.  
Jan 29 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.