OleDbCommandBuilder批量更新数据库［Session的应用］

最新推荐文章于 2024-04-19 16:12:43 发布

idays021

最新推荐文章于 2024-04-19 16:12:43 发布

阅读量1.3k

点赞数

分类专栏： ADO.NET 文章标签： session 数据库 dataset textbox asp

ADO.NET 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

/为了便于阅读写的有些地方有点重复，见谅

//Web.config数据库链接字符串

 <connectionStrings>
    <add name="access" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/ccc.mdb" providerName="System.Data.OleDb"/>
  </connectionStrings>

//前台代码

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="default4.aspx.cs" ValidateRequest="false" Inherits="RM.WebApp.default4" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="gdv1" runat="server" AutoGenerateColumns="False" Width="530px" OnRowCommand="gdv1_RowCommand" DataKeyNames="id">
            <Columns>
                <asp:TemplateField HeaderText="ID">
                    <EditItemTemplate>
                        <asp:Label ID="lblID2" runat="server" Text='<%# Eval("id") %>'></asp:Label>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="lblID" runat="server" Text='<%# Eval("id") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="TITLE">
                    <EditItemTemplate>
                        <asp:TextBox ID="cbxTitle" runat="server" Text='<%# Eval("title") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="lblTitle" runat="server" Text='<%# Eval("title") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="CONTENT">
                    <EditItemTemplate>
                        <asp:TextBox ID="txtContent" runat="server" Rows="6" Text='<%# Eval("content") %>'
                            TextMode="MultiLine" Width="215px"></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="lblContent" runat="server" Text='<%# Eval("content") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="操作">
                    <EditItemTemplate>
                        <asp:LinkButton ID="lbtnUpdata" runat="server" CommandName="Mupdata" CommandArgument='<%# Eval("id") %>'>更新</asp:LinkButton>
                        <asp:LinkButton ID="lbtnCancel" runat="server" CommandName="Mcancel" CommandArgument='<%# Eval("id") %>' >取消</asp:LinkButton>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:LinkButton ID="lbtnEditor" runat="server" CommandName="Medit" CommandArgument='<%# Eval("id") %>' >编辑</asp:LinkButton>
                        <asp:LinkButton ID="lbtnDelete" runat="server" CommandName="Mdelete" CommandArgument='<%# Eval("id") %>' >删除</asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
        <br />
        <br />
         <asp:Button ID="Button1" runat="server" Text="更新数据库,把现有数据写入或更新数据库" OnClick="Button1_Click" /></div>
    </form>
</body>
</html>

//后台代码

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.OleDb;

namespace RM.WebApp
{
    public partial class default4 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DataSet ds=new DataSet();
                bind(ds);
            }
        }

        protected void gdv1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            switch (e.CommandName.ToString())
            {
                case "Medit":
                    GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
                    gdv1.EditIndex = gvr.RowIndex;
                    DataSet ds = (DataSet)Session["bind"];
                    bind(ds);
                    break;
                case "Mcancel":
                    DataSet dt = (DataSet)Session["bind"];
                    gdv1.EditIndex = -1;
                    bind(dt);
                    break;
                case "Mdelete":
                    DataSet dsD= (DataSet)Session["bind"];
                    GridViewRow gvrq = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
                    int i = gvrq.RowIndex;
                    dsD.Tables["rm_Article"].Rows.Remove(dsD.Tables["rm_Article"].Rows[i]);
                    bind(dsD);
                    break;
                case "Mupdata":
                    GridViewRow g= (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
                    int x = g.RowIndex;
                    DataSet dsU = (DataSet)Session["bind"];
                    dsU.Tables["rm_Article"].Rows[x]["title"] = ((TextBox)gdv1.Rows[x].FindControl("cbxTitle")).Text;
                    dsU.Tables["rm_Article"].Rows[x]["content"] = ((TextBox)gdv1.Rows[x].FindControl("txtContent")).Text;
                    gdv1.EditIndex = -1;
                    bind(dsU);
                    break;
            }
        }

        public void bind(DataSet ds)
        {
            if (Session["bind"] == null)
            {
                OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["access"].ConnectionString);
                conn.Open();
                OleDbDataAdapter adp = new OleDbDataAdapter("select * from rm_Article", conn);
                DataSet dss = new DataSet();
                adp.Fill(dss, "rm_Article");
                gdv1.DataSource = dss.Tables["rm_Article"].DefaultView;
                gdv1.DataBind();

                Session["bind"] = dss;

            }
            else
            {
                gdv1.DataSource = ds.Tables["rm_Article"];
                gdv1.DataBind();
                Session["bind"] = ds;
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            OleDbConnection oleCn = new OleDbConnection(ConfigurationManager.ConnectionStrings["access"].ConnectionString);
            string sql = "select * from rm_Article";
            OleDbDataAdapter oleSub = new OleDbDataAdapter(sql, oleCn);
            OleDbCommandBuilder cb1 = new OleDbCommandBuilder(oleSub);

            DataSet ds = (DataSet)Session["bind"];
            oleSub.Update(ds, "rm_Article");
            Response.Write("数据库更新成功");
        }
    }
}