qileilove

blog已经转移至github,大家请访问 http://qaseven.github.io/

与加密后的Access数据库建立连接

　　Default.aspx
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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 id="Head1" runat="server">
<title>与加密后的Access数据库建立连接</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<div>
<table style="width: 587px; height: 338px">
<tr>
<td colspan="6">
<asp:Image ID="Image1" runat="server" ImageUrl="~/image/head.gif" /></td>
</tr>
<tr>
<td style="width: 100px; height: 13px">
<asp:Label ID="Label1" runat="server" Font-Size="Smaller" Text="输入连接Access数据库的密码："
Width="199px"></asp:Label></td>
<td style="width: 77px; height: 13px">
<asp:TextBox ID="TxtMm" runat="server" TextMode="Password"></asp:TextBox></td>
<td style="width: 77px; height: 13px">
<asp:Button ID="BtnOK" runat="server" OnClick="BtnOK_Click" Text="显示数据" Width="58px" /></td>
<td style="width: 100px; height: 13px">
<asp:Label ID="lblMessage" runat="server" Font-Bold="True" Font-Size="Smaller" ForeColor="Red"
Width="296px"></asp:Label></td>
<td style="width: 100px; height: 13px">
</td>
<td style="width: 95px; height: 13px">
</td>
</tr>
<tr>
<td colspan="6" style="height: 142px">
<asp:GridView ID="GridbookSell" runat="server" AutoGenerateColumns="False" CellPadding="4"
Font-Size="Smaller" ForeColor="#333333" GridLines="None" Width="788px">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="图书编号" HeaderText="图书编号" />
<asp:BoundField DataField="图书名称" HeaderText="图书名称" />
<asp:BoundField DataField="价格" HeaderText="价格" />
<asp:BoundField DataField="出版时间" HeaderText="出版时间" />
<asp:BoundField DataField="类别" HeaderText="类别" />
<asp:BoundField DataField="备注" HeaderText="备注" />
</Columns>
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<EditRowStyle BackColor="#999999" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
</td>
</tr>
<tr>
<td colspan="6" style="height: 60px">
<asp:Image ID="Image2" runat="server" ImageUrl="~/image/foot.gif" /></td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
　　Default.aspx.cs
using System;
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.OleDb;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void BtnOK_Click(object sender, EventArgs e)
{
string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:DataBase Password=" + this.TxtMm.Text + ";User Id=admin;Data source=" + Server.MapPath("db_ADO.mdb");
OleDbConnection Con = new OleDbConnection(ConStr);
if (this.TxtMm.Text == "")
{
Response.Write("<script language=javascript>alert('对不起！文本框不能为空！');location='javascript:history.go(-1)'</script>");
}
else
{
try
{
//打开数据库连接
Con.Open();
OleDbDataAdapter Dap = new OleDbDataAdapter("select * from tb_booksell", Con);
DataSet ds = new DataSet();
Dap.Fill(ds, "tb_booksell");
GridbookSell.DataSource = ds;
GridbookSell.DataBind();
this.lblMessage.Text = " 恭喜你，与加密后的Access数据库连接成功！";
}
catch (Exception error)
{
this.lblMessage.Text = " 很遗憾,密码错误,请重新输入密码！";
return;
}
finally
{
//关闭数据库连接
Con.Close();
}
}
}
}

posted on 2014-07-15 10:30 顺其自然EVO 阅读(179) 评论(0)  编辑  收藏 所属分类: 数据库


只有注册用户登录后才能发表评论。
网站导航:
 
<2014年7月>
日一二三四五六
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

导航

统计

常用链接

留言簿(55)

随笔分类

随笔档案

文章分类

文章档案

搜索

最新评论

阅读排行榜

评论排行榜