This sub routine fails on the first pass but works on every other pass.
What needs to be changed?
Sub FillGrids()
Try
' Dim cell As DataGridCell = dgStfMbrCntct.CurrentCell
'If tbMfrAppSearch.Text <> "" Then
MessageBox.Show(tbMfrAppSearch.Text)
Dim strSQL As String = "Select _ID, _MFR, _APP, _VER,
_LicCount, _Alias," & _
" _Flags, _LicType from Apps where _App like '%" &
tbMfrAppSearch.Text & "%'" & _
" order by _MFR, _APP"
MessageBox.Show(strSQL.ToString)
'Else
' Dim strSQL As String = "Select _ID, _MFR, _APP,
_VER, _LicCount, _Alias," & _
' " _Flags, _LicType from Apps
order by _MFR, _APP"
'End If 'tbMfrAppSearch <> ""
' daApps.SelectCommand.CommandText = strSQL
'Rebind
dsAudWiz.Clear()
Dim daApps As New SqlDataAdapter(strSQL, cnAudWiz)
daApps.Fill(dsAudWiz, "Apps")
'Rebind
daAppInst.Fill(dsAudWiz, "AppInst")
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
End Sub
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hsc7eel/M=362329.6886308.7839368.1510227/D=groups/S=1705115364:TM/Y=YAHOO/EXP=1123178548/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</a>.</font>
--------------------------------------------------------------------~->
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
