-

ASP.NET网站应用(图文教程)

ASP.NET是一个由微软开发的用于构建Web应用程序的框架,提供了丰富的功能,包括服务器端组件、数据库访问、身份验证和授权、文件上传和下载、网站导航、数据绑定和Webforms等。

IIS开启asp.net
IIS里和服务器里开启asp.net功能

vs2010配置
Microsoft Visual Studio 2010 软件配置

代码里显示行数

asp.net案例
一个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带翻页>>  
连接sqlserver数据库加载json数据带翻页
asp.net连接sqlserver数据库加载json数据带翻页
查看sqlserver-link-json.html连接sqlserver数据库加载json数据带翻页>>