<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="StuID" HeaderText="StuID" SortExpression="StuID" />
<asp:BoundField DataField="Stuname" HeaderText="Stuname" SortExpression="Stuname" />
<asp:TemplateField HeaderText="Address" SortExpression="Address">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Address") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# (Eval("Address")).ToString().Substring(0,5) %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Grade" HeaderText="Grade" SortExpression="Grade" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabindControlsConnectionString %>"
SelectCommand="SELECT [StuID], [Stuname], [Address], [Grade] FROM [student]"></asp:SqlDataSource>
</div>
webconfig:
<connectionStrings>
<add name="DatabindControlsConnectionString" connectionString="Data Source=A496EEA01CF34AB/SA;Initial Catalog=Students;User ID=sa;pwd=666666" providerName="System.Data.SqlClient"/>
</connectionStrings>