I write the code behind my form in wpf
Private CustomerData As New CustomerDataSet2
Private taCust As New CustomerDataSet2TableAdapters.CustomerTableAdapter ' CustomerDataSetTableAdapters.CustomerTableAdapter
Private taManager As New CustomerDataSet2TableAdapters.TableAdapterManager
Private View As CollectionView
Private Sub Window1_Loaded(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Handles Me.Loaded
Me.taCust.Fill(Me.CustomerData.Customer)
Me.taManager.CustomerTableAdapter = taCust
MsgBox(Me.taCust.Connection.ConnectionString)
Me.DataContext = Me.CustomerData.Customer
Me.View = CollectionViewSource.GetDefaultView(Me.CustomerData.Customer)
End Sub
Private Sub btnFirst_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnFirst.Click
Me.View.MoveCurrentToFirst()
End Sub
Private Sub btnPrevious_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnPrevious.Click
If Me.View.CurrentPosition > 0 Then
Me.View.MoveCurrentToPrevious()
End If
End Sub
Private Sub btnNext_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnNext.Click
If Me.View.CurrentPosition < Me.View.Count - 1 Then
Me.View.MoveCurrentToNext()
End If
End Sub
Private Sub btnLast_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnLast.Click
Me.View.MoveCurrentToLast()
End Sub
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnDelete.Click
If Me.View.CurrentPosition > -1 Then
Dim row = CType(Me.View.CurrentItem, System.Data.DataRowView).Row
row.Delete()
End If
End Sub
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnAdd.Click
Dim row = Me.CustomerData.Customer.NewCustomerRow
row.LastName = "[New]"
Me.CustomerData.Customer.AddCustomerRow(row)
Me.View.MoveCurrentToLast()
End Sub
Private Sub btnRevert_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnRevert.Click
If Me.CustomerData.HasChanges Then
If MessageBox.Show("Are you sure you want to lose all your changes?", Me.Title, MessageBoxButton.YesNo) = MessageBoxResult.Yes Then
Me.CustomerData.RejectChanges()
End If
End If
End Sub
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnSave.Click
Try
If Me.CustomerData.HasChanges Then
If Me.taManager.UpdateAll(Me.CustomerData) > 0 Then
MsgBox("Saved.")
End If
End If
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
Now I need to bind each textbox control with it's field.
It's not success
I am use like this
<TextBox Height="28" Name="txtCustomerID" Width="Auto" IsReadOnly="True" Text="{Binding Path=CustomerID, Mode=OneWay}"/>
<TextBox Height="28" Name="txtLastName" Width="Auto" Text="{Binding Path=LastName}"/>
<TextBox Height="28" Name="txtFirstName" Width="Auto" Text="{Binding Path=FirstName}"/>
<TextBox Height="28" Name="txtCity" Width="Auto" Text="{Binding Path=City}"/>
<TextBox Height="29" Name="Pictrues_locaTextBox" Text="{Binding Path=pictrues_loca, Mode=TwoWay, ValidatesOnExceptions=true, NotifyOnValidationError=true}" Width="167" />
How I can do it correctly by programming code ?
http://weblogs.asp.net/nmarun/archive/2009/12/02/using-icommand-silverlight-4.aspx
Arun