SQLDataSource + GridView + Edit + ItemTemplate + Get URL Query 使用方法
Default.aspx |
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=.\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI" SelectCommand="SELECT * FROM dbo.Team " UpdateCommand="UPDATE dbo.Team SET Team_Name=@TeamName WHERE Team_ID=@TeamID" /> <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:CommandField ShowSelectButton="True" ShowEditButton="true" /> <asp:TemplateField HeaderText="Team ID"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("Team_ID") %>'/> </ItemTemplate> <EditItemTemplate> <asp:Label ID="Label2" runat="server" Text='<%# Eval("Team_ID") %>'/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Team Name"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("Team_Name") %>'/> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Team_Name") %>'/> </EditItemTemplate> </asp:TemplateField> </Columns> <EmptyDataTemplate> <asp:Label ID="Label3" runat="server" Text="No Record Existing!!"></asp:Label> </EmptyDataTemplate> <EditRowStyle BackColor="#2461BF" /> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#EFF3FB" /> <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> <SortedAscendingCellStyle BackColor="#F5F7FB" /> <SortedAscendingHeaderStyle BackColor="#6D95E1" /> <SortedDescendingCellStyle BackColor="#E9EBEF" /> <SortedDescendingHeaderStyle BackColor="#4870BE" /> </asp:GridView> |
Default.aspx.cs |
using System; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; namespace WebApplication9 { public partial class _Default : System.Web.UI.Page { protected void Page_Init(object sender, EventArgs e) { } protected void Page_Load(object sender, EventArgs e) { GetQuery(); GridView1.RowUpdating += new GridViewUpdateEventHandler(GridView1_RowUpdating); } void GetQuery() { String GetQuery = Request.QueryString["League"]; if (GetQuery != null) { if (GetQuery.Trim().Length > 0) { try { GetQuery = Convert.ToInt32(GetQuery).ToString(); } catch (FormatException a) { GetQuery = "0"; } catch (OverflowException a) { GetQuery = "0"; } SqlDataSource1.SelectCommand += "WHERE League_ID = " + GetQuery; } } } void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { Label IndexLabel = (Label)GridView1.Rows[e.RowIndex].Cells[1].Controls[1]; SqlDataSource1.UpdateParameters.Add("TeamName", e.NewValues[0].ToString()); SqlDataSource1.UpdateParameters.Add("TeamID", IndexLabel.Text.ToString().Trim()); SqlDataSource1.Update(); } } } |