data binding with grid view and sqldatasource

[phpmel]

Hi guys,
I would like some help please. I have a grid view and an sql datasource that returns results of a search from a database using a stored procedure. I did all of this by drag and drop, not manually. In my sqldatasource_selected method, i have a label that suppose to display the number of records returned and it is not doing that, the first time, sometimes, it some how it is moody and out of sync. I tested the code with less than 10 records and it is working. however when i tested it with 253 records it is when it is giving me trouble. Somehow, the first time i press the find button for the first search it is not entering the SQLDataSource3_selected() method, so the label does not get a value. I know this because i steped through the program using break points. I am not sure if it has something to do with the databinding lifecycle and stuff is being executed before its time or something
Any help would greatly be appreciated

here is my code

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
 
public partial class Centre_Interface_Find : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
 
    }
 
    protected void resetButton_Click(object sender, EventArgs e)
    {
        Response.Redirect("Centre_Interface_Find.aspx");
    }
    protected void allCheckBox_CheckedChanged(object sender, EventArgs e)
    {
 
        if (allCheckBox.Checked == true)
        {
            centreListBox.Enabled = false;
            descriptionTextBox.Enabled = false;
            mcDropDown.Enabled=false;
            ddlArea.Enabled = false;
        }
        else
        {
            centreListBox.Enabled = true;
            descriptionTextBox.Enabled = true;
            mcDropDown.Enabled = true;
            ddlArea.Enabled = true;
        }
 
    }
    protected void findButton_Click(object sender, EventArgs e)
    {
        msgLabel.Visible = false;
        msgLabel1.Visible = false;
        if (allCheckBox.Checked == false)
        {
            if (centreListBox.SelectedIndex==0)
                Session["CentreNo"] = "0";
            else
                Session["CentreNo"] = centreListBox.SelectedValue;
 
            if (descriptionTextBox.Text.Trim() == "")
                Session["description"] = "0";
            else
                Session["description"] = descriptionTextBox.Text.Trim();
 
            if (mcDropDown.SelectedIndex == 1)//Selected Yes
                Session["mc"] = "1";
            if (mcDropDown.SelectedIndex == 2)//Selected No
                Session["mc"] = "0";
            if (mcDropDown.SelectedIndex == 0)//selected Both
                Session["mc"] = "2";
            if (ddlArea.SelectedIndex == 0)
                Session["area"] = 0;
            else
                Session["area"] = 1;
            Session["all"] = 0;
 
        }
        else
        {
            Session["CentreNo"] = "0";
            Session["description"] = "0";
            Session["mc"] = "%";
            Session["area"] = 0;
            Session["all"] = 1;
        }
        DataBind();
        resultLabel.Visible = true;
 
 
            if (afGridView.Rows.Count > 0)
            {
                afGridView.Visible = true;
                msgLabel.Visible = true;
                msgLabel1.Visible = true;
            }
 
 
 
    }
    protected void afGridView_DataBound(object sender, EventArgs e)
    {
 
        if (afGridView.PageCount != 0)
        { 
            msgLabel.Text = string.Format("You are viewing page {0} of {1}...", afGridView.PageIndex + 1, afGridView.PageCount);
        }
 
    }
    protected void SqlDataSource3_Selected(object sender, SqlDataSourceStatusEventArgs e)
    {//this is the method that is moody
        int count = e.AffectedRows;
        if (count == 0)
        { msgLabel1.Text = " No Records found"; }
        else
        {
            if (count == 1)
            { msgLabel1.Text = " 1 record found"; }
            else
            { msgLabel1.Text = " " + count + " records found"; }
        }
     }
 
 
}
 

[webguy007]

I would expect that you could populate this with the afGridView_DataBound method, not the SqlDataSource3_Selected method. I suspect you would then use the datagrid's size / count property to populate your label.

I'm not sure what the datasource selected method would be showing you.

Let us know if this helps.

[balabaster]

I would expect that you could populate this with the afGridView_DataBound method, not the SqlDataSource3_Selected method. I suspect you would then use the datagrid's size / count property to populate your label.

I'm not sure what the datasource selected method would be showing you.

Let us know if this helps.

I would expect the DataSource.Selected event to fire after the DataSource is assigned, but before the data is bound, so consequently no data would have loaded at the time this event fires. Consequently the grid would be of zero size. I've found that the grid only has rows and columns after the DataBind event has fired - consequently any grid manipulation pertaining to data held within the grid should occur when or after the DataBind event has fired.

[phpmel]

Thank you so much for your replies.

So in my afGridView_DataBound method, i will use EventArgs "e.what" to get my count?

I am not sure what to do. Can you all please elaborate a little more.

[phpmel]

Thank you so much for your reply.

So in my afGridView_DataBound method, i will use EventArgs "e.what" to get my count?

I am not sure what to do. Can you all please elaborate a little more.

[Plater]

afGridView.Rows.Count

[phpmel]

Hi,

I have paging enabled in the gridview, so afGridView.rows.count returns 5 since that is my page size. i wanted exactly how many records were returned within the gridview. Do I have to mathematically calculate it using the pagecount and page size, or is there an attribute that i could get it from?

[balabaster]

Hi,

I have paging enabled in the gridview, so afGridView.rows.count returns 5 since that is my page size. i wanted exactly how many records were returned within the gridview. Do I have to mathematically calculate it using the pagecount and page size, or is there an attribute that i could get it from?

Don't get hung up on the GridView object - don't forget you have a DataSource object too... that will tell you how many records were returned in total.

Also, your gridview may have 5 pages but only return 3 rows on the last page instead of 5. So your calculation would've had to take that into account 5 x 5 <> (4 x 5) + 3

[phpmel]

I am using the datasource e.Affetcedrows attribute to find out the number of rows that was returned (see first post with code). It is in the SqlDataSource3_Selected method. However, somethimes it is going into the method and sometimes it is not. So because it is so moody i can not ALWAYS get the label to show how much records was returned.

Please ........any suggestions