BindingNavigator lock when app is played

[MarioRammy]

Hi i've i've connected my SQL server to my VB.net app. I want to be able to insert into the tables but when i run the app the BindingNavigator is Shaded gray and is also inactive!

Any ideas? i've run through the attributes but i cant see anything that could cause it to be inactive

 

[MarioRammy]

Problems inserting into SQL Server

I'm using the binding tools to such as BindingNavigator and then i bound a text box to a field in my DB. This generated the following code:


Private Sub addJob_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'AppleDataSet1.Construction' table. You can move, or remove it, as needed.
Me.ConstructionTableAdapter.Fill(Me.AppleDataSet1.Construction)

End Sub

This did not work however so i moved the code behind a button i had on the form but this also did not work.

Any ideas?

 

[jmcilhinney]

If the BindingNavigators buttons are greyed out then the most likely reason is that you haven't set its BindingSource property.

 

[cjard]

Hi i've i've connected my SQL server to my VB.net app. I want to be able to insert into the tables but when i run the app the BindingNavigator is Shaded gray and is also inactive!

Any ideas? i've run through the attributes but i cant see anything that could cause it to be inactive

Nav is shaded out when ther eis no nav to be performed.. i.e. your local datatable contains 0 or 1 records