GridView單行編輯保存

最新推荐文章于 2016-09-16 09:41:06 发布

abc_dr

最新推荐文章于 2016-09-16 09:41:06 发布

阅读量2.3k

点赞数

分类专栏： WEB 文章标签： textbox asp string dataset object server

本文链接：https://blog.csdn.net/abc_dr/article/details/8077042

版权

WEB 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

前臺：

<body>
    <form id="form1" runat="server">
    <div>
    <table style="width: 100%; margin-bottom: 0px;">
            <tr>
                <td colspan="3">
                    <h1 class="style1" style="font-size: x-large">
                        請輸入<span lang="zh-cn">工號</span>進行查詢</h1>
                </td>
            </tr>
            <tr>
                <td style="width:20%">
                        <span lang="zh-cn">請輸入工號</span>：
                    </td>
                <td style="width:20%" align="left">
                        <asp:TextBox ID="txtbianhao" runat="server"></asp:TextBox>
                </td>
                <td align="left">
                        <asp:Button ID="btquery" runat="server" Text="查詢" Height="28px"
                            Width="72px" οnclick="btquery_Click" />
                </td>
            </tr>
        </table>
        <div align="center" >
           <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
                        ForeColor="#333333" GridLines="None" OnRowEditing="GridView1_RowEditing"
                        OnRowUpdating="GridView1_RowUpdating" DataKeyNames="bianhao"
                OnRowCancelingEdit="GridView1_RowCancelingEdit" Height="174px" Width="923px" >
                        <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                        <Columns>
                            <asp:BoundField HeaderText="電腦編號" ReadOnly="True" InsertVisible="False" DataField="bianhao" />
                            <asp:BoundField DataField="daima" HeaderText="部門代碼" ReadOnly="True" />
                            <asp:BoundField DataField="name" HeaderText="員工姓名" ReadOnly="True"/>
                            <asp:BoundField DataField="mingcheng" HeaderText="設備名稱" ReadOnly="True"/>
                            <asp:BoundField DataField="beizhu" HeaderText="備註" />
                            <asp:CommandField HeaderText="编辑" ShowEditButton="True" sho/>
                        </Columns>
                        <RowStyle ForeColor="#000066" />
                        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                    </asp:GridView>
        </div>
    </div>
    </form>
</body>

后臺代碼：

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class page_update2 : System.Web.UI.Page
{
    SqlConnection sqlcon;
    SqlCommand sqlcom;
    string strCon = "Data Source=10.16.0.58;Database=shebei;Uid=sa;Pwd=Ab-123456";
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btquery_Click(object sender, EventArgs e)
    {
        bind();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        bind();
    }

    //更新
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        sqlcon = new SqlConnection(strCon);
        sqlcon.Open();
        string bianhao = Convert.ToString(this.GridView1.DataKeys[e.RowIndex].Value);
        string beizhu = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString();
        string sqlstr = "update xinxi set beizhu='" + beizhu + "' where bianhao='" + bianhao + "'";
        sqlcom = new SqlCommand(sqlstr, sqlcon);
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.EditIndex = -1;
        bind();

}

    //取消
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        bind();
    }

    //绑定
    public void bind()
    {
        string strgonghao = txtbianhao.Text.Trim();
        string sqlstr = "select * from xinxi where gonghao='" + strgonghao + "'";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "表");
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string[] { "bianhao" };//主键
        GridView1.DataBind();
        sqlcon.Close();

}
}