SQLDataSource + GridView + Edit + ItemTemplate + Get URL Query 使用方法

 
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();
         }
      }
   }