[thelist] simple asp.net question
Jeremy Coulson
jcoulson at co.frederick.va.us
Thu Aug 2 07:04:26 CDT 2007
Clearly the problem is my understanding of GridView1.Rows.Count! When I try
to just display the number of rows using:
Dim i As Integer = GridView1.Rows.Count
lbl1.Text = i
I get apparently random numbers. I'll see a gridview with 5 results and
it'll say 0 or 3 or something else completely incorrect. So, if anyone can
tell me how to get an integer that is the exact number of rows in the
gridview, I'll gladly add a little variable representing it to my program.
Jeremy Coulson
PC Technician/Webmaster, Frederick County
(540) 722-8211
jcoulson at co.frederick.va.us
-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Jeremy Coulson
Sent: Wednesday, August 01, 2007 11:55 PM
To: thelist at lists.evolt.org
Subject: [thelist] simple asp.net question
I'm 100% certain I'm missing something really simple on this search I've
been trying to build for our phone directory on our intranet. Everything is
working correctly except one thing. When a user enters a search that
returns no result, a label tells the user there were no results.
Unfortunately, the program never makes it to the second half of the
conditional statement and all searches - even successful ones - return the
same message.
You can see the whole code (there's not much!) at
http://www.co.frederick.va.us/coulson/phoneExtensions.aspx (but you have to
download it because that server is running an older framework that doesn't
know gridview). This is the specific function that is not working:
---------------------->
Sub nameHandler(ByVal sender As Object, ByVal e As EventArgs)
If strSearch.Text = "" Then
lbl1.Text = "<br /><font color='red'>Please enter a search term
in the box above!</font>"
Else
AccessDataSource1.SelectCommand = "SELECT [lastName],
[firstName], [dept], [ext], [email] FROM [tblPhones] WHERE [lastName] = '" +
strSearch.Text + "' OR [firstName] = '" + strSearch.Text + "' ORDER BY
[dept], [lastName]"
If GridView1.Rows.Count = 0 Then
lbl1.Text = "<br />Your search for " & strSearch.Text & "
found no results."
Else
lbl1.Text = "<br />Search string: " & strSearch.Text & "."
End If
End If
End Sub
---------------------->
Why does it never get to the Else half of that If? I'm thinking this is
either a failure of my ability to nest conditional statements, a failure of
my logic, or a failure of my understanding of GridView.Rows.Count. I've
been beating this dead horse for three hours now and I'm going to bed.
Hopefully I will find a solution tomorrow. If you know it, feel free to
share! Thanks!
Jeremy Coulson
PC Technician/Webmaster, Frederick County
(540) 722-8211
jcoulson at co.frederick.va.us
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
More information about the thelist
mailing list