Thanks very much
i try to define a gridview and a SqlDataSource without connectionstrin g
and select command like this
<asp:GridView ID="GridView1" runat="server" AllowPaging="Tr ue"
AllowSorting="T rue"
CellPadding="4" DataSourceID="S qlDataSource1"
ForeColor="#333 333" GridLines="None " EmptyDataText=" No Data Record" >
<FooterStyle BackColor="#990 000" Font-Bold="True"
ForeColor="Whit e" />
<RowStyle BackColor="#FFF BD6" ForeColor="#333 333" />
<SelectedRowSty le BackColor="#FFC C66" Font-Bold="True"
ForeColor="Navy " />
<PagerStyle BackColor="#FFC C66" ForeColor="#333 333"
HorizontalAlign ="Center" />
<HeaderStyle BackColor="#990 000" Font-Bold="True"
ForeColor="Whit e" />
<AlternatingRow Style BackColor="Whit e" />
</asp:GridView>
<asp:Button ID="Button1" runat="server" OnClick="Button 1_Click"
Text="Button" />
<asp:SqlDataSou rce ID="SqlDataSour ce1"
runat="server"> </asp:SqlDataSour ce>
and a little operation in the .cs file
protected void Button1_Click(o bject sender, EventArgs e)
{
SqlDataSource1. ConnectionStrin g =
ConfigurationMa nager.Connectio nStrings["ServiceConnect ionString"].ToString();
SqlDataSource1. SelectCommand = "select * from [tblService]";
}
it displays the gridview when i click the button. However, when I click
the column header or the page index to change, the gridview displays,
and the "No Data Record" is displayed, like no data in the data source.
I also tried to define the gridview with connection string and select
command,. but change the select command when the button is clicked. The
same problem came out.
I wrote a line to write the select commad when in Sorting or
PageIndexChangi ng event, it display the original one defined in the
..aspx file, instead of the one changed to in .aspx.cs file in the
Button_Click() event.
what could be the reason for this?
I am very appreciated for your help.
