-- BUSQUEDA DE ESTUDIANTE POR APELLIDOS
CREATE PROCEDURE USP_S_BUSCARESTUDIANTEAPELLIDO
@EST_Apellido		varchar(30)
AS
BEGIN TRANSACTION
SELECT 
	EST_Codigo	AS Codigo						,
	EST_Nombres	AS Nombre						,
	EST_ApellidoPaterno	AS ApellidoPaterno		,
	EST_ApellidoMaterno	AS ApellidoMaterno		,
	EST_CorreoElectronico AS CorreoElectronico
FROM Estudiante
WHERE EST_ApellidoPaterno = @EST_Apellido OR EST_ApellidoMaterno = @EST_Apellido
IF (@@error <> 0) 
	ROLLBACK TRANSACTION
ELSE
	COMMIT TRANSACTION
GO 

 Private Sub BusquedaDataGrid_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles BusquedaDataGrid.CellClick

        Dim ind As Integer = Me.BusquedaDataGrid.CurrentRow.Index
        Dim item As String = Me.BusquedaDataGrid.Item(0, e.RowIndex).Value

        Me.BusquedaTextBox.Text = item
    End Sub

Private Sub BusquedaDataGrid_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles BusquedaDataGrid.CellClick
        BusquedaDataGrid(e.ColumnIndex, e.RowIndex).Value

    End Sub