[thelist] simple asp.net question

Tab Alleman talleman at Lumpsum.com
Thu Aug 2 08:50:22 CDT 2007


Where is your databind statement?   I don't see one between where you create your sql and where you access your rowcount:


>             AccessDataSource1.SelectCommand = "SELECT [lastName],
> [firstName], [dept], [ext], [email] FROM [tblPhones] WHERE 
> [lastName] = '" +
> strSearch.Text + "' OR [firstName] = '" + strSearch.Text + "' ORDER BY
> [dept], [lastName]"
> 

'****   There should be something here that binds the gridview to the datasource, or executes the command.

>             If GridView1.Rows.Count = 0 Then




> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Jeremy Coulson
> Sent: Thursday, August 02, 2007 8:04 AM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] simple asp.net question
> 
> 
> 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 ! 
> 
> -- 
> 
> * * 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