postback gridview row count to text tag...

[VisualGuy]

I was wondering if anyone knew why when I try and to get a grid view row count, I get 0, unless I call the count from a second button AFTER the gridview has already loaded.

 

[jbenson001]

You don't want to count the rows in the grid. If you want to display a row count, count the rows in the datasource(datatable, etc) that the grid is binding too.

 

[VisualGuy]

I tried that, but couldn't figure out how to do it...Below, you can see that my datasource is called SqlDataSource1. There isn't a table. How and on what event can I access this information?

<asp:GridView ID="GridView2" runat="server" AllowSorting="True"
AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px"
CellPadding="3" CellSpacing="2" AlternatingRowStyle-BackColor="#CCFFFF" >
<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
<Columns>
<asp:ButtonField Text="Expand Details" ButtonType="Button" />
<asp:BoundField DataField="Account_Number" HeaderText="Account_Number"
SortExpression="Account_Number" />
<asp:BoundField DataField="Full_Name" HeaderText="Full_Name"
SortExpression="Full_Name" />
<asp:BoundField DataField="Last_Name" HeaderText="Last_Name"
SortExpression="Last_Name" />
<asp:BoundField DataField="Social_Number" HeaderText="Social_Number"
SortExpression="Social_Number" />
</Columns>
<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStringsurgedAccountsConnectionString %>" >
</asp:SqlDataSource>

 

[jbenson001]

This is another reason not to use the datasource controls. I suggest you don't and use a dataaccess layer.

This should answer your question:

http://www.dotnetspider.com/resources/15865-Get-Number-rows-affected-by-SqlDataSource.aspx