ASP.NET是一个由微软开发的用于构建Web应用程序的框架,提供了丰富的功能,包括服务器端组件、数据库访问、身份验证和授权、文件上传和下载、网站导航、数据绑定和Webforms等。
IIS里和服务器里开启asp.net功能
Microsoft Visual Studio 2010 软件配置
代码里显示行数
一个asp.net案例,实现增删改查功能,在bin目录里放Interop.ADOX.DLL文件,可操作数据库
查看aspnet案例1>>
<!--#include file="Include/asp.aspx"-->
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>ASP.Net案例,增删改查</title>
</head>
<body>
<script runat="server" language="c#">
string html="";
string title="";
protected void Page_Load(object sender, EventArgs e){
string MDBPath=mapPath(".\\") + "\\data.mdb"; //数据库路径
//Response.Write(MDBPath);
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+MDBPath;
OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
if( cStr(Request["act"])== "del" ){
Response.Write("提示,删除ID("+Request["id"]+")成功 ");
string sql1 = "delete FROM article where id in("+Request["id"]+")";
OleDbCommand cmd2 = new OleDbCommand(sql1, conn);
cmd2.ExecuteReader();
}else if( cStr(Request["act"])== "save" ){
//修改
if( cStr(Request["id"])!=""){
string sql1 = "insert into article (title) values('"+ Request["title"] +"') where id="+Request["id"];
OleDbCommand cmd2 = new OleDbCommand(sql1, conn);
cmd2.ExecuteReader();
}else{ //添加
string sql1 = "insert into article (title) values('"+ Request["title"] +"')";
OleDbCommand cmd2 = new OleDbCommand(sql1, conn);
cmd2.ExecuteReader();
}
}else if( cStr(Request["act"])== "addedit" ){
if( cStr(Request["id"])!=""){
string sql3 = "SELECT top 1 * FROM article where id="+Request["id"] ;
OleDbCommand cmd3 = new OleDbCommand(sql3, conn);
OleDbDataReader rsx = cmd3.ExecuteReader();
while (rsx.Read()){
title=cStr(rsx["title"]);
}
}
}
string sql = "SELECT top 10 * FROM article order by id desc";
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader rs = cmd.ExecuteReader();
// 处理数据
while (rs.Read())
{
html+="<tr><td height='30' bgcolor='#FFFFFF'><input name='id' type='checkbox' id='id' value='"+rs["id"]+"' /></td>";
html+="<td height='30' bgcolor='#FFFFFF'>"+rs["id"]+"</td>";
html+="<td height='30' bgcolor='#FFFFFF'>"+rs["title"]+"</td>";
html+="<td height='30' bgcolor='#FFFFFF'>"+rs["createtime"]+"</td>";
html+="<td height='30' bgcolor='#FFFFFF' align='center'><a href='?act=addedit&id="+rs["id"]+"'>修改</a> | <a href='?act=del&id="+rs["id"]+"'>删除</a></td></tr> ";
}
rs.Close();
conn.Close();
}
</script>
<script src='jquery.js'></script>
<%if(cStr(Request["act"])=="addedit"){%>
<form id="form1" name="form1" method="post" action="?act=save">
标题
<input type="text" name="title" id="title" value="<%=title%>" />
<input type="submit" name="button" id="button" value="提交" />
</form>
<%}%>
<form id="form1" name="form1" method="post" action="?act=submit">
<table width="600" border="0" cellspacing="1" cellpadding="0" bgcolor="#000000">
<tr>
<td height="40" colspan="5" align="left" bgcolor="#FFFFFF">
<input type="button" name="button" id="button" value="全选" onclick="selectAll()" />
<input type="button" name="button2" id="button2" value="反选" onclick="reverseSelect()" />
<input type="button" name="button3" id="button3" value="批量删除" onclick="deleteRows()" />
<a href='?act=addedit'>新增加一条</a>
</td>
</tr>
<tr>
<td height="40" align="center" bgcolor="#FFFFFF">选择</td>
<td height="40" align="center" bgcolor="#FFFFFF">ID</td>
<td height="40" align="center" bgcolor="#FFFFFF">标题</td>
<td height="40" align="center" bgcolor="#FFFFFF">时间</td>
<td height="40" align="center" bgcolor="#FFFFFF">操作</td>
</tr>
<%=html%>
</table>
</form>
<script>
function selectAll() {
var checkboxes = document.getElementsByName("id");
for (var i = 0; i < checkboxes.length; i++) {
checkboxes[i].checked = true;
}
}
function reverseSelect() {
var checkboxes = document.getElementsByName("id");
for (var i = 0; i < checkboxes.length; i++) {
checkboxes[i].checked = !checkboxes[i].checked;
}
}
function deleteRows() {
var checkboxes = document.getElementsByName("id");
var ids = [];
for (var i = 0; i < checkboxes.length; i++) {
if (checkboxes[i].checked) {
ids.push(checkboxes[i].value);
}
}
if (ids.length > 0) {
var deleteUrl = "?act=del"; // 替换为您的删除URL
var postData = "id=" + ids.join(",");
var xhr = new XMLHttpRequest();
xhr.open("POST", deleteUrl, true);
xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xhr.onreadystatechange = function() {
if (xhr.readyState == 4 && xhr.status == 200) {
alert("删除成功");
location.reload();
}
};
xhr.send(postData);
} else {
alert("请至少选择一个记录");
}
}
</script>
使用服务器控件来展示Access数据库里对应表数据
查看asp.net案例2>> 查看asp.net案例3带翻页>>asp.net连接sqlserver数据库加载json数据带翻页
查看sqlserver-link-json.html连接sqlserver数据库加载json数据带翻页>>