ASP.NET数据绑定控件

protected void btnUp_Click(object sender, EventArgs e)
    {
        var da = new NewsDataSetTableAdapters.categoryTableAdapter();
        foreach (GridViewRow row in this.GridView1.Rows)
        {
            if (row.RowType == DataControlRowType.DataRow)
            {
                CheckBox ck = row.FindControl("ckSel") as CheckBox;
                if (ck.Checked)
                {
                    var cateID = this.GridView1.DataKeys[row.RowIndex].Value;
                    var cateName = (row.FindControl("txtName") as TextBox).Text;

                    da.Update(cateName, int.Parse(cateID.ToString()));
                }
            }
        }
    }

    var cateID = this.GridView1.DataKeys[row.RowIndex].Value;
    da.Delete(int.Parse(cateID.ToString()));

//新建方法
protected string FormatImgURL(object url)    //因为Eval()返回值是 object,所以用此类型
{
    return ResolveClientUrl("~/images/+url");
}
//调用
<%#FormatImgURL(Eval("PicPath"))%>

<asp:Repeater ID="Repeater1" runat="server" DataSourceID="ObjectDataSource1">
     <HeaderTemplate><div style="background-color:Aqua;width:200px;">会员管理系统<br /></div></HeaderTemplate>
     <ItemTemplate>主键：<%#Eval("Id") %>姓名：<%#Eval("username") %> <br /></ItemTemplate>
     <AlternatingItemTemplate><div style="color:Red">主键：<%#Eval("Id") %>姓名：<%#Eval("username") %> <br /></div></AlternatingItemTemplate>
     <FooterTemplate><div style="background-color:Aqua;width:200px;">作者：小高</div></FooterTemplate>
     <SeparatorTemplate><hr width="200" align="left"/></SeparatorTemplate>
</asp:Repeater>

//ItemDataBound事件
DataRowView rowView = (DataRowView)e.Item.DataItem;        //得到这行的值
var userRow = (TestObject.DataSetUser.T_User)rowView.Row;    //转换成强类型DataSet
if (userRow.Age > 30)        //当年龄大于 30
{
    TextBox txtAge = (TextBox)e.Item.FindControl("txtAge"); //获得模板中的控件
    txtAge.BackColor = Color.Red;                //设置背景颜色
}

if (userRow.Age > 40)        //当年龄大于40
{
    HtmlGenericControl spnRow = (HtmlGenericControl)e.Item.FindControl("spanRow"); //获得整行Span的ID
    spanRow.Attributes["class"] = "warning";        //设定定义好的样式
}

//Repeater控件设置
 <ItemTemplate>姓名：<%#Eval("username") %> 年龄:‘<%#Eval("age") %>‘
 <asp:Button runat="server" Text="加一岁" CommandName="inc"
 CommandArgument=‘<%#Eval("id") %>‘ /><br /></ItemTemplate>

//增加一个SQL更新语句,名为 IncAgeById()
 // update T_Person set age=age+1 where id=@id

//ItemCommand事件设置
   protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        if (e.CommandName == "inc")
        {
            int id = int.Parse(e.CommandArgument.ToString());           //获得当前行的ID值
            T_personTableAdapter adapter = new T_personTableAdapter(); //创建 adapter
            adapter.IncAgeById(id);    //使用自定义SQL进行更新,按当前ID来加一
            this.Repeater1.DataBind();    //数据再次绑定,实现网页与数据库同步
        }
    }

<HeaderTemplate><table><tr class="head"><td>用户</td><td>状态</td><td>操作</td></tr></HeaderTemplate>
  <ItemTemplate><tr id="trRow" runat="server">
  <td><%#Eval("UserName") %></td><td><%#Eval("Status") %></td>
  <td><asp:Button runat="server" ID="Enabled" Text="启用" OnClientClick="return confirm(‘你确认启用该用户？‘)" 
  CommandName="Enabled" CommandArgument=‘<%#Eval("Id") %>‘ /><asp:Button runat="server" ID="Disable" Text="禁用" 
  OnClientClick="return confirm(‘你确认禁用该用户？‘)" CommandName="Disabled" CommandArgument=‘<%#Eval("Id") %>‘ />
  </td></tr></ItemTemplate>
  <FooterTemplate></table></FooterTemplate>

    <style type="text/css">
        .disableRow{ background-color:Red;}
    </style>

//对于Header等则不处理，必须要判断AlternatingItem,因为默认是加入这个的
   if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
   {
         DataRowView rowView = (DataRowView)e.Item.DataItem;    //将当前对象转换成 DataRowView
         var userRow = (人员管理.DAL.DataSetT_User.T_UserRow)rowView.Row; //获得当前行成员

          if (userRow.Status == "禁用")        //如果状态是禁用,则设置它的一些样式
           {
             HtmlTableRow trRow = (HtmlTableRow)e.Item.FindControl("trRow"); //获得trRow的控件
             trRow.Attributes["class"] = "disableRow";        //增加一个calss属性

             Button btnenable = (Button)e.Item.FindControl("Enabled"); //获得Enabled控件
             Button btndisable = (Button)e.Item.FindControl("Disable"); 

             btnenable.Visible = true;        //将btnenable设置为显示
             btndisable.Visible = false;    //将btndisable设置为不显示
          }
           else if(userRow.Status == "启用")    
            {
             HtmlTableRow trRow = (HtmlTableRow)e.Item.FindControl("trRow");
             trRow.Attributes["class"] = "";    //设置无样式

             Button btnenable = (Button)e.Item.FindControl("Enabled");  
             Button btndisable = (Button)e.Item.FindControl("Disable");

             btnenable.Visible = false;        //与上面相反
             btndisable.Visible = true;
            }
            else                //为了程序的严整性
            {
             throw new Exception("状态有误！"); //抛出异常
            }
    }

 if (e.CommandName == "Enabled")    //如果CommandName为 Enable
            {
                int id =int.Parse(e.CommandArgument.ToString());    //获得CommandArgument值
                T_UserTableAdapter adpter = new T_UserTableAdapter();    //new 一个adpter
                adpter.EnableById(id);    //使用自定义SQL方法怎么数据修改
                Repeater1.DataBind();    //再次绑定数据
            }
            else if(e.CommandName == "Disabled")    //同上相反
            {
                int id = int.Parse(e.CommandArgument.ToString());
                T_UserTableAdapter adapter = new T_UserTableAdapter();
                adapter.DisableById(id);
                Repeater1.DataBind();
            }

 ListViewDataItem lvDataItem = (ListViewDataItem)e.Item;
 DataRowView rowView = (DataRowView)lvDataItem.DataItem;

if (e.Item.ItemType == ListViewItemType.DataItem)
        {
            ListViewDataItem lvDataItem = (ListViewDataItem)e.Item; //必须先转换,调试可得
            DataRowView rowView = (DataRowView)lvDataItem.DataItem; 
            var userRow = (TEST.DAL.DataSetTEST.T_UserRow)rowView.Row;
            if (userRow.Status == "禁用")            //检测状态是否为 "禁用"
             {
                HtmlTableRow trRow = (HtmlTableRow)e.Item.FindControl("trRow"); //取得控件ID
                trRow.Attributes["class"] = "disabled";        //设置样式
             }
        }

    if (e.Item.ItemType == ListViewItemType.InsertItem)//判断是否为InsertItem类型
     {
           TextBox AgeBox = (TextBox)e.Item.FindControl("AgeTextBox"); //获取年龄控件
           AgeBox.Text = "20"; //设置插入的默认值
     }

     e.Values["id"]=Guid.NewGuid();            //新建一个 Guid 传给当前id字段
     if (e.Values["UserName"].ToString() == "xgao")    //判断用户名
     {
         e.Cancel = true;                //取消数据插入
     }

 if (Convert.ToInt32(e.NewValues["UserName"].ToString().Length) > 9) //当长度大于9时
      {
          Response.Write("<script>alert(‘用户长度不能大于9！‘)</script>");
          e.Cancel = true;        //取消数据插入
       }

<asp:Button runat="server" ID="INC" CommandName="IncAge" Text="加一岁" />

  int num = ((ListViewDataItem)e.Item).DisplayIndex;    //取得前行号
  int id = (int)ListView1.DataKeys[num].Value;        //取当前操作行的主键值
  if (e.CommandName == "IncAge")        //判断当前控件的CommandName是否为IncAge
   {
       T_personTableAdapter adpater = new T_personTableAdapter();
       adpater.IncAgeById(id);    //利用自定义SQL语句进行 年龄加1
       ListView1.DataBind();    //数据绑定
   }
      

//DropDownList 显示时用 ItemCreated 事件
 DropDownList ddlStatus = (DropDownList)e.Item.FindControl("ddlStatus");
 if (ddlStatus != null)        //如果没有找到ddlStatus ,就认识不是EditTemplete
   {
          ListViewDataItem lvData = (ListViewDataItem)e.Item;
          DataRowView rowView = (DataRowView)lvData.DataItem;
          if (rowView != null) //如果取到的话
           {
               var userRow = (TEST.DAL.DataSetTEST2.T_UserRow)rowView.Row;
               ddlStatus.SelectedValue =    
           }
   }

 //DropDownList 插入时用 ItemInserting 事件
 DropDownList ddlStatus = (DropDownList)e.Item.FindControl("defalutStatus");
 e.Values["Status"] = ddlStatus.SelectedValue;    //e.Values[]  赋值操作

 //DropDownList 更新时用 ItemUpdating 事件

 DropDownList ddlStatus = (DropDownList)ListView1.Items[e.ItemIndex].FindControl("ddlStatus");
 e.NewValues["Status"] = ddlStatus.SelectedValue;  //e.NewValues[] 更新数据后赋值操作

select * from (SELECT Id, UserName row_number()over(order by id)rownum 
FROM T_User)t
where t.rownum>10 and t.rownum<=20

select * from
(select id,name Row_Number()over(order by id)rownum from T_User)t
where t.rownum>@startRowIndex and t.rownum<=@startRowIndex+@maximumRows

if (!IsPostBack)
 {
      string action = Request["action"];
       if (action == "edit")                //是否为 edit 模式
       {
           FormView1.ChangeMode(FormViewMode.Edit);    //更改模式为 编辑模式
       }
       else if (action == "new")            //是否为 new 模式
       {
           FormView1.ChangeMode(FormViewMode.Insert);    //更改模式为 编辑模式
       }    
       else if (action == "view")            //是否为 view 模式
       {
           FormView1.ChangeMode(FormViewMode.ReadOnly);    //更改模式为 编辑模式
       }
}