Public Class Form1
Private Sub ClientesBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
'Me.Validate()
'Me.ClientesBindingSource.EndEdit()
'Me.TableAdapterManager.UpdateAll(Me.AgendaTelefonica2012DataSet)
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: esta línea de código carga datos en la tabla 'AgendaTelefonica2012DataSet.Clientes' Puede moverla o quitarla según sea necesario.
Me.ClientesTableAdapter.Fill(Me.AgendaTelefonica2012DataSet.Clientes)
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Me.ClientesBindingSource.MoveFirst()
End Sub
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Me.ClientesBindingSource.MoveLast()
End Sub
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
Me.ClientesBindingSource.MoveNext()
End Sub
Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
Me.ClientesBindingSource.MovePrevious()
End Sub
Private Sub AgregarContactoToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AgregarContactoToolStripMenuItem.Click
Me.ClientesBindingSource.AddNew()
End Sub
Private Sub ActualizarToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ActualizarToolStripMenuItem.Click
Me.ClientesTableAdapter.ActualizarCliente(CelularTextBox.Text, CelularReferenciaTextBox.Text, TelefonoFijoTextBox.Text, NombreTextBox.Text, ProveedorDeTextBox.Text, CorreoElectronicoTextBox.Text, WebTextBox.Text, DireccionTextBox.Text)
Me.ClientesTableAdapter.Fill(Me.AgendaTelefonica2012DataSet.Clientes)
End Sub
Private Sub EliminarToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles EliminarToolStripMenuItem.Click
Me.ClientesTableAdapter.EliminarCliente(CelularTextBox.Text)
Me.ClientesTableAdapter.Fill(Me.AgendaTelefonica2012DataSet.Clientes)
End Sub
Private Sub GuardarToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles GuardarToolStripMenuItem.Click
Try
Me.ClientesTableAdapter.InsertarCliente(CelularTextBox.Text, CelularReferenciaTextBox.Text, TelefonoFijoTextBox.Text, NombreTextBox.Text, ProveedorDeTextBox.Text, CorreoElectronicoTextBox.Text, WebTextBox.Text, DireccionTextBox.Text)
Me.ClientesTableAdapter.Fill(Me.AgendaTelefonica2012DataSet.Clientes)
Catch ex As Exception
MsgBox("Error al guardar" & ex.Message)
End Try
End Sub
Private Sub BuscarToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BuscarToolStripMenuItem.Click
Me.ClientesTableAdapter.FillBy(Me.AgendaTelefonica2012DataSet.Clientes, CelularTextBox.Text)
End Sub
Private Sub CelularTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles CelularTextBox.KeyPress
If Char.IsNumber(e.KeyChar) Then
e.Handled = False
ElseIf Char.IsControl(e.KeyChar) Then
e.Handled = False
ElseIf Char.IsSeparator(e.KeyChar) Then
e.Handled = False
Else
e.Handled = True
End If
'Codigo para cambiar con la tecla enter
If Asc(e.KeyChar) = 13 Then
CelularReferenciaTextBox.Focus()
End If
End Sub
Private Sub CelularReferenciaTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles CelularReferenciaTextBox.KeyPress
If Asc(e.KeyChar) = 13 Then
TelefonoFijoTextBox.Focus()
End If
End Sub
Private Sub NombreTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles NombreTextBox.KeyPress
If Asc(e.KeyChar) = 13 Then
ProveedorDeTextBox.Focus()
End If
End Sub
Private Sub ProveedorDeTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles ProveedorDeTextBox.KeyPress
If Asc(e.KeyChar) = 13 Then
CorreoElectronicoTextBox.Focus()
End If
End Sub
Private Sub CorreoElectronicoTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles CorreoElectronicoTextBox.KeyPress
If Asc(e.KeyChar) = 13 Then
WebTextBox.Focus()
End If
End Sub
Private Sub WebTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles WebTextBox.KeyPress
If Asc(e.KeyChar) = 13 Then
DireccionTextBox.Focus()
End If
End Sub
Private Sub TelefonoFijoTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TelefonoFijoTextBox.KeyPress
If Asc(e.KeyChar) = 13 Then
NombreTextBox.Focus()
End If
End Sub
Private Sub DireccionTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles DireccionTextBox.KeyPress
If Asc(e.KeyChar) = 13 Then
GuardarToolStripMenuItem.Select()
End If
End Sub
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click
Me.ClientesTableAdapter.ContarClientes()
End Sub
End Class