惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Attack and Defense Labs
Attack and Defense Labs
The GitHub Blog
The GitHub Blog
C
Check Point Blog
博
博客园_首页
MongoDB | Blog
MongoDB | Blog
N
Netflix TechBlog - Medium
F
Full Disclosure
Microsoft Security Blog
Microsoft Security Blog
爱范儿
爱范儿
Recent Announcements
Recent Announcements
阮一峰的网络日志
阮一峰的网络日志
G
GRAHAM CLULEY
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
T
Threat Research - Cisco Blogs
C
Cybersecurity and Infrastructure Security Agency CISA
V
Vulnerabilities – Threatpost
K
Kaspersky official blog
博
博客园 - 司徒正美
S
Schneier on Security
T
The Exploit Database - CXSecurity.com
Project Zero
Project Zero
云风的 BLOG
云风的 BLOG
Cisco Talos Blog
Cisco Talos Blog
Know Your Adversary
Know Your Adversary
雷峰网
雷峰网
V
V2EX - 技术
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
Spread Privacy
Spread Privacy
罗
罗磊的独立博客
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
S
Security Affairs
SecWiki News
SecWiki News
Schneier on Security
Schneier on Security
O
OpenAI News
Jina AI
Jina AI
PCI Perspectives
PCI Perspectives
Cyberwarzone
Cyberwarzone
Y
Y Combinator Blog
Apple Machine Learning Research
Apple Machine Learning Research
B
Blog RSS Feed
I
InfoQ
D
Docker
P
Palo Alto Networks Blog
Recorded Future
Recorded Future
M
MIT News - Artificial intelligence
博
博客园 - Franky
B
Blog
Scott Helme
Scott Helme
博
博客园 - 叶小钗
D
DataBreaches.Net

博客园 - xumingming

C# 长浏览 SQL Server 的位运算 sql 的随机函数newID()和RAND() Linq To Xml （增，删，改，查） - xumingming sp_executesql的用法 Sql Server 存储过程分页 linq 存储过程返回多个结果集 Sql语句访问WEB 一些常用的类 MVC Controller与ActionResult的返回值 - xumingming - 博客园 IEnumerable_T_、IEnumerable、ICollection_T_、IList_T_、ObservableCollectin_T_和Collection_T_得关系 routes.MapRoute - xumingming - 博客园 JQuery与Ajax常用代码 MVC 小笔记 - xumingming - 博客园 GridView 72般绝技 C#代码中的事务 - xumingming - 博客园 VS2005中将GridView 中的数据导出至excel - xumingming - 博客园 触发器 删除数据库表中的信息（适用于被注入）
GridView 的临时增删改查示例
xumingming · 2009-08-19 · via 博客园 - xumingming

SqlCommandBuilder  注意点: 

  1.只能更新一个表，不能更新两个或两个以上相关联的表 
  2.表中必须有主键 
  3.更新的表中字段不能有image类型的


create table GridViewDemoTable
(
    [ID] int identity(1,1) primary key,
    [Name] varchar(20) unique,
    [Department] varchar(20)
)
insert into GridViewDemoTable ([Name],[Department]) select '张三','市场部'
union all select '李四','研发部'
union all select '王二','策划部'
union all select '薛七','销售部'
union all select '丁一','财务部'select * from GridViewDemoTable

Code
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    姓名:<asp:TextBox ID="txtName" runat="server"></asp:TextBox>部门:<asp:TextBox ID="txtDepartment" runat="server"></asp:TextBox>
    <asp:Button ID="btnAdd" runat="server" Text="新增" OnClick="btnAdd_Click" />&nbsp;&nbsp;&nbsp;&nbsp;<asp:Button ID="btnSave" Text="保存" runat="server" OnClick="btnSave_Click" />
    <asp:GridView ID="gv" runat="server" AutoGenerateColumns="false" DataKeyNames="ID" OnRowDeleting="gv_RowDeleting" OnRowEditing="gv_RowEditing" OnRowUpdating="gv_RowUpdating" OnRowCancelingEdit="gv_RowCancelingEdit">
        <Columns>
        <asp:TemplateField HeaderText="姓名">
        <ItemTemplate>
        <%#Eval("Name") %>
        </ItemTemplate>        
        <EditItemTemplate>
        <asp:TextBox ID="txtName" runat="server" Text='<%#Eval("Name") %>'></asp:TextBox>
        </EditItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="部门">
        <ItemTemplate>
        <%#Eval("Department") %>
        </ItemTemplate>        
        <EditItemTemplate>
        <asp:TextBox ID="txtDepartment" runat="server" Text='<%#Eval("Department") %>'></asp:TextBox>
        </EditItemTemplate>
        </asp:TemplateField>
            <asp:CommandField ShowDeleteButton="True" />
            <asp:CommandField ShowEditButton="True" />
        </Columns>
    </asp:GridView>
    
    </form>
</body>
</html>


protected void Page_Load(object sender, EventArgs e)
    {if (!IsPostBack)
        {
            DataTable dt = getDataTable();
            ViewState["dt"] = dt;
            gv.DataSource = dt;
            gv.DataBind();
        }
    }private DataTable getDataTable()
    {
        using (SqlConnection con = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=Test"))
        {
            SqlDataAdapter sda = new SqlDataAdapter("select * from GridViewDemoTable ", con);
            DataSet ds = new DataSet();
            sda.Fill(ds, "GridViewDemoTable");
            if (ds.Tables.Contains("GridViewDemoTable"))
            {
                return ds.Tables["GridViewDemoTable"];                
            }
            return null;

        }

//end using block    
    }protected void gv_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        object val = gv.DataKeys[e.RowIndex].Value;
        DataTable dt = ViewState["dt"] as DataTable;
        if (dt != null)
        {
            for (int i = dt.Rows.Count - 1; i > -1; i--)
            {
                if (dt.Rows[i][0].Equals(val))
                {
                    dt.Rows[i].Delete();
                    //dt.Rows.RemoveAt(i);                    
                }
            }
            ViewState["dt"] = dt;
            gv.DataSource = dt;
            gv.DataBind();
            //Response.Write("<script language='JavaScript'>window.location=location;</script>");  //防止刷新重复提交

        }        
    }
    protected void gv_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gv.EditIndex = e.NewEditIndex;
        DataTable dt = ViewState["dt"] as DataTable;
        if (dt != null)
        {
            gv.DataSource = dt;
            gv.DataBind();
        }        
    }protected void gv_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        int iRowIndex = e.RowIndex;

        DataTable dt 

= ViewState["dt"] as DataTable;
        if (dt != null)
        {
            dt.Rows[iRowIndex]["Name"] = ((sender as GridView).Rows[iRowIndex].FindControl("txtName") as TextBox).Text;
            dt.Rows[iRowIndex]["Department"] = ((sender as GridView).Rows[iRowIndex].FindControl("txtDepartment") as TextBox).Text;

            ViewState[

"dt"] = dt;
            (sender as GridView).EditIndex = -1;
            gv.DataSource = dt;
            gv.DataBind();
        }                           

    }

protected void gv_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        
        gv.EditIndex = -1;
        DataTable dt = ViewState["dt"] as DataTable;
        if (dt != null)
        {
            gv.DataSource = dt;
            gv.DataBind();
        }    
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        DataTable dt = ViewState["dt"] as DataTable;
        if (dt != null)
        {            
            using (SqlConnection con = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=Test"))
            {
                SqlDataAdapter sda = new SqlDataAdapter("select MAX(ID)+1 from GridViewDemoTable ", con);
                DataSet ds = new DataSet();
                sda.Fill(ds, "MaxID");
                if (ds.Tables.Contains("MaxID") && ds.Tables["MaxID"].Rows.Count > 0)
                {
                    DataRow dr = dt.NewRow();
                    dr[0] = ds.Tables["MaxID"].Rows[0][0];
                    dr[1] = txtName.Text;
                    dr[2] = txtDepartment.Text;
                    dt.Rows.Add(dr);
                    ViewState["dt"] = dt;
                    gv.DataSource = dt;
                    gv.DataBind();
                }                
            }//end using block                
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        DataTable dt = ViewState["dt"] as DataTable;
        if (dt != null)
        {
            using (SqlConnection con = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=Test"))
            {
                SqlDataAdapter sda = new SqlDataAdapter("select * from GridViewDemoTable ", con);
                SqlCommandBuilder scb = new SqlCommandBuilder(sda);
                DataSet ds = new DataSet();
                sda.Fill(ds, "GridViewDemoTable");                                
                sda.Update(dt);
                ClientScript.RegisterStartupScript(GetType(), "success", "alert('保存成功!');", true);
            }//end using block                
        }
    }

此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。