更新删除操作怎么写？？？

Question

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data;namespace University
{
    public partial class repeater编辑更新删除 : System.Web.UI.Page
    {
        public int id = 0;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindGrid();
            }           
        }
        private void BindGrid()
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            SqlDataAdapter da = new SqlDataAdapter("select * from notes",conn);
            DataSet ds = new DataSet();
            conn.Open();
            da.Fill(ds);
            conn.Close();
            this.Repeater1.DataSource = ds.Tables[0].DefaultView;
            this.Repeater1.DataBind();
        }        protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                DataRowView rowv = (DataRowView)e.Item.DataItem;
                string nid = rowv["nid"].ToString();
                if (nid != id.ToString())
                {
                    ((Panel)e.Item.FindControl("plItem")).Visible = true;
                    ((Panel)e.Item.FindControl("plEdit")).Visible = false;
                }
                else
                {
                    ((Panel)e.Item.FindControl("plItem")).Visible = false;
                    ((Panel)e.Item.FindControl("plEdit")).Visible = true;
                }
            }
        }        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
           
            if (e.CommandName == "Edit")
            {
                id = int.Parse(e.CommandArgument.ToString());
            }
            else if (e.CommandName == "Cancel")
            {
                id = -1;
            }
            else if (e.CommandName == "Update")
            {
                //怎么实现更新功能
                //string ntitle = ((TextBox)this.Repeater1.Items[e.Item.ItemIndex].FindControl("ntitle")).Text.Trim();
                //this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('更新ID：');", true);            }
            else if (e.CommandName == "Delete")
            {
                //删除功能怎么实现
            //    this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('删除ID：');", true);            }
            BindGrid();
        }
    }
}

Answer 1

楼主 你想干什么
怎么不用 gridview 功能强大

Answer 2

repeater编辑更新删除---------------------------就算是新手 也不应该写出这种代码。

Answer 3

  SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
//删除
conn.open();
string strDel="delete from notes where id='"+id+"'";
sqlcommand cmd = new sqlcommand(strDel,conn);
cmd.ExecuteNonQuery();
//修改
string strUpdate="Update notes set 字段1=value,字段2=value where id='"+id+"'";
sqlcommand cmd = new sqlcommand(strUpdate,conn);
cmd.ExecuteNonQuery();conn.close();

Answer 4

像你这里直接执行要修改或 删除的SQL语句就好.
 ((TextBox)this.Repeater1.Items[e.Item.ItemIndex].FindControl("ntitle")).Text.Trim
根据这样获取所要更新的值.
拼接成SQL,执行.

Answer 5

前台<asp:Repeater ID="repeaters" runat="server">
       <HeaderTemplate>
        <table align="center" border="1" width="80%" id="xing">
            <tr style="font-size:14px; color:Red;">
                <td>
                    编号</td>
               
                <td>
                    图集类型</td>
                <td>
                    图集创建时间</td><td>
                    操作</td>
            </tr>
           </HeaderTemplate>
           <ItemTemplate> 
            <tr>
                <td><%# Eval("id") %>
                </td>
               
                <td><%# Eval("cover")%>
                </td>
                <td><%# Eval("createdate")%>
                </td><td>
                    <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="images/del.gif" OnClick="delete"  ToolTip='<%# Eval("id") %>' />
                </td>
                <td>
                    <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="images/del.gif" OnClick="update"  ToolTip='<%# Eval("id") %>' />
</a>
                </td>
            </tr>
           </ItemTemplate>
           <FooterTemplate>
        </table>
        </FooterTemplate>
        </asp:Repeater>后台
    protected void delete(object sender, EventArgs e)
    {
        int id = Convert.ToInt32(((ImageButton)sender).ToolTip);
        new mypro.BLL.wjcont().Delete(id);
        bind();
    }    protected void update(object sender, EventArgs e)
    {
        int id = Convert.ToInt32(((ImageButton)sender).ToolTip);
        new mypro.BLL.wjcont().Delete(id);
        bind();
    }

Answer 6

谁还用GW啊，基本都是Repeater，要么就是Ext的控件，用GW基本就OUT了！！！

Answer 7

前台<asp:Repeater ID="repeaters" runat="server">
       <HeaderTemplate>
        <table align="center" border="1" width="80%" id="xing">
            <tr style="font-size:14px; color:Red;">
                <td>
                    编号</td>
               
                <td>
                    图集类型</td>
                <td>
                    图集创建时间</td><td>
                    操作</td>
            </tr>
           </HeaderTemplate>
           <ItemTemplate> 
            <tr>
                <td><%# Eval("id") %>
                </td>
               
                <td><%# Eval("cover")%>
                </td>
                <td><%# Eval("createdate")%>
                </td><td>
                    <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="images/del.gif" OnClick="delete"  ToolTip='<%# Eval("id") %>' />
                </td>
                <td>
                    <a href='Webcon.aspx?id=<%# Eval("id") %>'><img alt="" src="images/edit.gif" /></a>
                </td>
            </tr>
           </ItemTemplate>
           <FooterTemplate>
        </table>
        </FooterTemplate>
        </asp:Repeater>后台    protected void delete(object sender, EventArgs e)
    {
        int id = Convert.ToInt32(((ImageButton)sender).ToolTip);
        new mypro.BLL.wjcont().Delete(id);
        bind();
    }    protected void update(object sender, EventArgs e)
    {
        int id = Convert.ToInt32(((ImageButton)sender).ToolTip);
        new mypro.BLL.wjcont().Delete(id);
        bind();
    }

Answer 8

CommArguments='<%#Eval('id')%>' commandName="del"
int id=e.CommandArguemtents.Tostring();
delete操作