It works just fine for searching strings, can someone help me modify it to search for Integers?
Button Click:
VB Code:
Private Sub btnLogOn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogOn.Click Try Dim validateUserLogOn As Data.DataView = New Data.DataView(DatabaseMainPressDataSet.tblPasswords) validateUserLogOn.RowFilter = "EmployeeFirstName like '%" + txtEnterPassword.Text + "%'" Dim matchFound As Integer = validateUserLogOn.Count Select Case matchFound Case 0 textLabelOnDialogForm = "El Sistema no reconoce la clave entrada?" frmDialog.ShowDialog() Case 1 frmLogOnSuccessful.EmployeeFirstNameParameter = CStr(validateUserLogOn.Item(0)("EmployeeFirstName")) frmLogOnSuccessful.ShowDialog() End Select Catch ex As Exception MessageBox.Show(ex.ToString) End Try End Sub
Property:
Form Load:VB Code:
Private m_EmployeeFirstNameParameter As String Public WriteOnly Property EmployeeFirstNameParameter() As String Set(ByVal value As String) m_EmployeeFirstNameParameter = value End Set End Property
VB Code:
Me.TblPasswordsTableAdapter.FillByEmployeeFirstName(DatabaseMainPressDataSet.tblPasswords, Me.m_EmployeeFirstNameParameter)




Reply With Quote