[thelist] simple asp.net question

[Jeremy Coulson]

The databinding is accomplished in the gridview control's code.  I moved
AccessDataSource1.SelectCommand into this function so it would only be used
when the function gets called.  I'd paste the code for GridView1 and
AccessDataSource1 here, but it would be too messy to make sense of.  You can
view it at http://www.co.frederick.va.us/coulson/phoneExtensions.txt.  

Thanks to everyone who has or will look at this!  You're helping to make me
a minor hero around here.

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 Tab Alleman
Sent: Thursday, August 02, 2007 9:50 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] simple asp.net question

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 ! 
> 
-- 

* * 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 !