asp.net2.0访问Access数据库之（添加）

最新推荐文章于 2019-07-07 09:16:22 发布

gzaqq

最新推荐文章于 2019-07-07 09:16:22 发布

阅读量889

点赞数

分类专栏： DotNet开发文章标签： asp.net access 数据库 compilation authentication button

本文链接：https://blog.csdn.net/gzaqq/article/details/613458

版权

DotNet开发专栏收录该内容

11 篇文章 0 订阅

订阅专栏

还是三个文件和一个Freetextbox组件（网上下载的很多FreeTextBox 1.6.3.26073）：

add.aspx ,add.aspx.cs ,web.config

add.aspx代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="add.aspx.cs" Inherits="add" %>
<%@ Register TagPrefix="ftb" Namespace="FreeTextBoxControls" Assembly="FreeTextBox" %>

<!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>
    <FTB:FreeTextBox id="FreeTextBox1" runat="server" Width="700" />
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /></div>
    </form>
</body>
</html>
===================================================================================

add.aspx.cs代码如下：

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

public partial class add : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        OleDbConnection Connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + ConfigurationManager.ConnectionStrings["ConnectionString"]);
        OleDbCommand cmd = new OleDbCommand();
        cmd.Connection = Connection;
        cmd.CommandText = "Insert Into GuestBook (content) Values ('" + FreeTextBox1.Text + "')";
        Connection.Open();
        cmd.ExecuteNonQuery();
        Connection.Dispose();
        cmd.Dispose();

    }
}
=========================================================================================

web.config代码如下：

<?xml version="1.0"?>

<configuration>
<appSettings/>
<connectionStrings>
  <add name="connectionstring" connectionString="App_Data/data.mdb"/>
</connectionStrings>
<system.web>
  
  <compilation debug="true"/>
  
  <authentication mode="Windows"/>
  <!--
            如果在执行请求的过程中出现未处理的错误，
            则通过 <customErrors> 节可以配置相应的处理步骤。具体说来，
            开发人员通过该节可以配置
            要显示的 html 错误页
            以代替错误堆栈跟踪。