用ASP.NET做动态网站，怎么与数据库链接？数据库是用Access做的

发布网友发布时间：2022-04-07 20:19

共5个回答

懂视网时间：2022-04-08 00:41

C#" AutoEventWireup="true" CodeBehind="滑动门.aspx.cs" Inherits="UI.滑动门" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> 　　<link rel="stylesheet" href="css/style.css" /> </head> <body> <form id="form1" runat="server"> <div class="solidBox"> <h3 class="solidBox_title"> <asp:ListView ID="ListTitle" runat="server"> <ItemTemplate>  <strong runat="server" id="Title" class=""> <%#Eval("Title") %> </strong> </ItemTemplate> </asp:ListView> </h3> <div class="solidBox_content"> <asp:ListView ID="ListContent" runat="server"> <ItemTemplate>  <strong runat="server" id="Content"> <%#Eval("Content") %> </strong> </ItemTemplate> </asp:ListView> </div> </div> </form> </body> </html>

样式重置：

/*
 * 样式重置文件
 */
body,
div,
dl,
dt,
dd,
ul,
ol,
li,
h1,
h2,
h3,
h4,
h5,
h6,
pre,
form,
fieldset,
input,
textarea,
p,
blockquote,
th,
td {
 margin: 0;
 padding: 0;
 font-weight: normal;
 font-style: normal;
 font-size: 12px;
 font-family: inherit;
}
table {
 border-collapse: collapse;
 border-spacing: 0;
}
fieldset,
img {
 border: 0;
}
address,
caption,
cite,
code,
dfn,
em,
strong,
th,
var {
 font-style: normal;
 font-weight: normal;
}
ol,
ul {
 list-style: none;
}
caption,
th {
 text-align: left;
}
h1,
h2,
h3,
h4,
h5,
h6 {
 font-size: 100%;
 font-weight: normal;
}
q:before,
q:after {
 content: ‘‘;
}
abbr,
acronym {
 border: 0;
}
a {
 color: #333;
 text-decoration: none;
}
a:hover {
 text-decoration: underline;
}
/*通用父子盒子嵌套浮动问题解决，开始*/

.clearfix:after {
 content: ".";
 display: block;
 height: 0;
 clear: both;
 visibility: hidden;
}
.clearfix {
 display: inline-block;
}
* html .clearfix {
 height: 1%;
}
.clearfix {
 display: block;
}
/*通用父子盒子嵌套浮动问题解决，结束*/
/*间隙层开始*/

.space_hx {
 /*横向间隙*/
 
 clear: both;
 width: 100%;
 height: 10px;
 font-size: 1px;
 overflow: hidden;
}
.space_zx {
 /*纵向间隙*/
 
 float: left;
 width: 10px;
 font-size: 1px;
 overflow: hidden;
}
/*间隙层结束*/

样式：

 .solidBox {
  width: 330px;
  height: 187px;
  margin: 20px;
  border-left: #CCCCCC 1px solid;
  overflow: hidden;
 }
  /*.solidBox .solidBox_title 中间空格是父子关系，以逗号隔开是同级关系*/

  .solidBox .solidBox_title {
  height: 30px;
  line-height: 30px;
  }

  .solidBox .solidBox_title div {
   float: left;
   /*变成块级元素*/
   width: 109px;
   height: 30px;
   border: #CCCCCC 1px solid;
   text-align: center;
   border-left: none;
   font: 16px "微软雅黑";
   cursor: pointer;
   /*cursor局部鼠标的样式*/
  }

  .solidBox .solidBox_title .hover {
   background: #9D9D9D;
   color: #FFF;
  }

  .solidBox .solidBox_content {
  padding: 5px;
  border: #CCCCCC 1px solid;
  border-left: none;
  border-top: none;
  height: 157px;
  width: 327px;
  overflow: hidden;
  }

后台：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

namespace UI
{
 public partial class 滑动门 : System.Web.UI.Page
 {
 protected void Page_Load(object sender, EventArgs e)
 {
  DBind();
 }
 private void DBind()
 {
  SqlConnection conn = new SqlConnection("Server=.;database=Test;uid=sa;pwd=x");
  conn.Open();
  SqlCommand cmd = new SqlCommand("select * from huadongmen",conn);
  SqlDataReader reader = cmd.ExecuteReader();
  List<huadongmen> list = new List<huadongmen>();
  while (reader.Read())
  {
  huadongmen sb = new huadongmen();
  sb.Title = reader[0].ToString();
  sb.Content = reader[1].ToString();
  list.Add(sb);
  }
  reader.Close();
  conn.Close();
  ListTitle.DataSource = list;
  ListTitle.DataBind();
  ListContent.DataSource = list;
  ListContent.DataBind();
 }
 }
}

附上数据库脚本：

create database Test
go
use Test
create table huadongmen
(
 title varchar(20),
 content varchar(500)
)
go
insert into huadongmen values(‘标题一‘,‘这是标题一的内容‘)
insert into huadongmen values(‘标题二‘,‘这是标题二的内容‘)
insert into huadongmen values(‘标题三‘,‘这是标题三的内容‘)

update huadongmen set content=‘这是标题二的内容‘ where title=‘标题二‘
select * from huadongmen

asp.net实现数据库版动态网页滑动门

标签：

热心网友时间：2022-04-07 21:49

<connectionStrings>
<add name="connStr" connectionString="provider=Microsoft.Jet.Oledb.4.0;data source=|DataDirectory|\#mydata.mdb"/>
</connectionStrings>
把你的access 放到App_Data文件夹中，如果没有看到这个文件夹，则在你的项目上右键，创建asp.net文件夹里面就能找到:App_data这个选项；然后在web.config中<system.web>之前加上上面的代码，#mydata.mdb换成你的access数据库文件名就行了。
然后在你的其它类文件中引用。
例如：
当然别忘了命名空间：System.Data.OleDb;

public static string connStr = ConfigurationManager.ConnectionStrings["connStr"].ToString();

public OleDbConnection getConnection()
{
return new OleDbConnection(connStr);
}

热心网友时间：2022-04-07 23:07

首先引用System.Data.OleDb;

建立连接
string strSql = "Provider=Microsoft.Jet.Oledb.4.0;data source=/data.mdb";
conn.Open();
OleDbCommand ODC = new OleDbCommand(strSql, conn);
OleDbDataReader ODDR = ODC.ExecuteReader();
while (ODDR.Read())
{
string name=ODDR["name"].ToString();
//code
}

读取字段就在while循环里面，其实和使用SqlClient差不多，只是引用的类不同

热心网友时间：2022-04-08 00:41

用ado.net技术连接数据库啊 access好像是ole连接数据库随便在网上找一个例子看看我好久没做都忘了

热心网友时间：2022-04-08 02:33