asp.Net   发布时间:2022-04-07  发布网站:大佬教程  code.js-code.com
大佬教程收集整理的这篇文章主要介绍了asp.net三层架构增删改查大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。

数据库

(SELEct sysdatabases name Maryename ename<span style="color: #0000ff">use<span style="color: #000000"> bond
<span style="color: #008080">--
<span style="color: #008080">基金类型表(左用)

<span style="color: #0000ff">if
<span style="color: #808080">exists
(<span style="color: #0000ff">SELEct
<span style="color: #808080">*
<span style="color: #0000ff">from
sys.objects <span style="color: #0000ff">where
name<span style="color: #808080">=
<span style="color: #ff0000">'
<span style="color: #ff0000">jjlx
<span style="color: #ff0000">'
<span style="color: #000000">)
<span style="color: #0000ff">drop
<span style="color: #0000ff">table
<span style="color: #000000"> jjlx
<span style="color: #0000ff">create
<span style="color: #0000ff">table
<span style="color: #000000"> jjlx
(
id
<span style="color: #0000ff">int
<span style="color: #0000ff">priMary
<span style="color: #0000ff">key
<span style="color: #ff00ff">identity
(<span style="color: #800000; font-weight: bold">1
,<span style="color: #800000; font-weight: bold">1
),<span style="color: #008080">--
<span style="color: #008080">id

jjlx <span style="color: #0000ff">varchar
(<span style="color: #800000; font-weight: bold">50
) <span style="color: #808080">not
<span style="color: #0000ff">null
<span style="color: #008080">--
<span style="color: #008080">基金类型

<span style="color: #000000">)

<span style="color: #008080">--<span style="color: #008080">基金类型表增加存储过程
<span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">SELEct <span style="color: #808080"> <span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx_add<span style="color: #ff0000">'<span style="color: #000000">)
<span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> jjlx_add
<span style="color: #0000ff">go
<span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> jjlx_add
<span style="color: #008000">@jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50<span style="color: #000000">)
<span style="color: #0000ff">as
<span style="color: #0000ff">insert <span style="color: #0000ff">into jjlx <span style="color: #0000ff">values (<span style="color: #008000">@jjlx<span style="color: #000000">)
<span style="color: #0000ff">go
<span style="color: #008080">--<span style="color: #008080">基金类型表查询存储过程
<span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">SELEct <span style="color: #808080">
<span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">p_jjlx<span style="color: #ff0000">'<span style="color: #000000">)
<span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> p_jjlx
<span style="color: #0000ff">go
<span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> p_jjlx
<span style="color: #0000ff">as
<span style="color: #0000ff">SELEct <span style="color: #808080"> <span style="color: #0000ff">from<span style="color: #000000"> jjlx
<span style="color: #0000ff">go
<span style="color: #008080">--<span style="color: #008080">基金类型表修改存储过程
<span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">SELEct <span style="color: #808080">
<span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx_gai<span style="color: #ff0000">'<span style="color: #000000">)
<span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> jjlx_gai
<span style="color: #0000ff">go
<span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> jjlx_gai
<span style="color: #008000">@id <span style="color: #0000ff">int<span style="color: #000000">,<span style="color: #008000">@jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50<span style="color: #000000">)
<span style="color: #0000ff">as
<span style="color: #0000ff">updatE jjlx <span style="color: #0000ff">SET jjlx<span style="color: #808080">=<span style="color: #008000">@jjlx <span style="color: #0000ff">where id<span style="color: #808080">=<span style="color: #008000">@id
<span style="color: #0000ff">go
<span style="color: #008080">--<span style="color: #008080">基金类型表删除存储过程
<span style="color: #0000ff">if <span style="color: #808080">exists(<span style="color: #0000ff">SELEct <span style="color: #808080">* <span style="color: #0000ff">from sys.objects <span style="color: #0000ff">where name<span style="color: #808080">=<span style="color: #ff0000">'<span style="color: #ff0000">jjlx_delete<span style="color: #ff0000">'<span style="color: #000000">)
<span style="color: #0000ff">drop <span style="color: #0000ff">procedure<span style="color: #000000"> jjlx_delete
<span style="color: #0000ff">go
<span style="color: #0000ff">create <span style="color: #0000ff">proc<span style="color: #000000"> jjlx_delete
<span style="color: #008000">@id <span style="color: #0000ff">int<span style="color: #000000">,<span style="color: #008000">@jjlx <span style="color: #0000ff">varchar(<span style="color: #800000; font-weight: bold">50<span style="color: #000000">)
<span style="color: #0000ff">as
<span style="color: #0000ff">delete <span style="color: #0000ff">from jjlx <span style="color: #0000ff">where id<span style="color: #808080">=<span style="color: #008000">@id <span style="color: #808080">and jjlx<span style="color: #808080">=<span style="color: #008000">@jjlx
<span style="color: #0000ff">go

链接数据库Web.config

connectionString= />

Model层managementModel类

<span style="color: #0000ff">namespace<span style="color: #000000"> managementModel
{
<span style="color: #0000ff">public
<span style="color: #0000ff">class
jjlxs<span style="color: #008000">//
<span style="color: #008000">基金类型表

<span style="color: #000000"> {
<span style="color: #0000ff">public
<span style="color: #0000ff">int
id { <span style="color: #0000ff">set; <span style="color: #0000ff">get; }<span style="color: #008000">//<span style="color: #008000">id
<span style="color: #0000ff">public <span style="color: #0000ff">string jjlx { <span style="color: #0000ff">set; <span style="color: #0000ff">get; } <span style="color: #008000">//<span style="color: #008000">基金类型
<span style="color: #000000">
}
}

DAL层添加引用 Model层添加程序集引用 using System.Configuration;managementDAL类

= sql = sql = = SqlParameter( sql = = SqlParameter( SqlParameter( sql = = SqlParameter(

DBHelper类

conn = ConfigurationManager.ConnectionStrings[ IUD( count = = = == DataSet Search(= = = }

}

BLL层添加引用 Model层添加引用 DAL层

= flag = (stujjlx.jjlx.Length != count = (count > = flag = (stujjlx.jjlx.Length != &&stujjlx.id!= count = (count > = flag = (stujjlx.jjlx.Length != && stujjlx.id != count = (count > =

UI 层添加引用 Model层添加引用 BLL层基金类型.aspx

<%@ Page Language= AutoEventWireup= CodeBehind= Inherits= %>

<!DOCTYPE html>

<html xmlns=<span style="color: #800000">"<span style="color: #800000">http://www.w3.org/1999/xhtml<span style="color: #800000">">
<head runat=<span style="color: #800000">"<span style="color: #800000">server<span style="color: #800000">">
<meta http-equiv=<span style="color: #800000">"<span style="color: #800000">Content-Type<span style="color: #800000">" content=<span style="color: #800000">"<span style="color: #800000">text/html; charset=utf-8<span style="color: #800000">"/>

runat=> runat= Text=> & runat=>
</div>
    <asp:Label ID=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;Label1</span><span style="color: #800000"&gt;"</span> runat=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;server</span><span style="color: #800000"&gt;"</span> Text=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;基金类型:</span><span style="color: #800000"&gt;"</span>></asp:Label>
    <asp:TextBox ID=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;txtjjlx</span><span style="color: #800000"&gt;"</span> runat=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;server</span><span style="color: #800000"&gt;"</span>></asp:TextBox>
    <br />
    <br />
    <asp:Button ID=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;btnadd</span><span style="color: #800000"&gt;"</span> runat=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;server</span><span style="color: #800000"&gt;"</span> OnClick=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;btnadd_Click</span><span style="color: #800000"&gt;"</span> Text=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;增加</span><span style="color: #800000"&gt;"</span> />
    <asp:Button ID=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;btndelete</span><span style="color: #800000"&gt;"</span> runat=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;server</span><span style="color: #800000"&gt;"</span> OnClick=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;btndelete_Click</span><span style="color: #800000"&gt;"</span> Text=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;删除</span><span style="color: #800000"&gt;"</span> />
    <asp:Button ID=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;btngai</span><span style="color: #800000"&gt;"</span> runat=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;server</span><span style="color: #800000"&gt;"</span> OnClick=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;btngai_Click</span><span style="color: #800000"&gt;"</span> Text=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;修改</span><span style="color: #800000"&gt;"</span> />
    <br />
    <table border=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;1</span><span style="color: #800000"&gt;"</span>>
        <tr&gt;<th>类型id</th><th>基金类型</th></tr&gt;
    <asp:repeater ID=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;repjjlx</span><span style="color: #800000"&gt;"</span> runat=<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;server</span><span style="color: #800000"&gt;"</span>>
        <ItemTemplate>
            <tr&gt;
                <td&gt;<%#Eval(<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;id</span><span style="color: #800000"&gt;"</span>) %></td&gt;
                <td&gt;<%#Eval (<span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;jjlx</span><span style="color: #800000"&gt;"</span>) %></td&gt;
            </tr&gt;
        </ItemTemplate>
    </asp:repeater>
    </table&gt;
</form>

基金类型.aspx.cs基金类型.aspx.cs

m.Collections.Generic; m.Linq; m.Web; m.Web.UI; m.Web.UI.WebControls; m.Data; { m.Web.UI.Page { jjlxbll bll = ); Page_Load(jectE) { Bind(); } {
        </span><span style="color: #0000ff"&gt;this</span>.repjjlx.Datasource = bll.Searchjjlx().Tables[<span style="color: #800080"&gt;0</span><span style="color: #000000"&gt;];
        </span><span style="color: #0000ff"&gt;this</span><span style="color: #000000"&gt;.repjjlx.DataBind();
    }
    </span><span style="color: #0000ff"&gt;protected</span> <span style="color: #0000ff"&gt;void</span> btnadd_Click(<span style="color: #0000ff"&gt;object</span><span style="color: #000000"&gt; sender,EventArgs E)
    {
        jjlxs stujjlx </span>= <span style="color: #0000ff"&gt;new</span> jjlxs {jjlx=<span style="color: #000000"&gt;txtjjlx.Text };
        </span><span style="color: #0000ff"&gt;if</span><span style="color: #000000"&gt; (bll.Insertjjlx(stujjlX))
        {
            Bind();
            Response.Write(</span><span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;<script>alert('增加成功!')</script></span><span style="color: #800000"&gt;"</span><span style="color: #000000"&gt;);
        }
        </span><span style="color: #0000ff"&gt;else</span><span style="color: #000000"&gt; {
            Response.Write(</span><span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;<script>alert('增加失败!')</script></span><span style="color: #800000"&gt;"</span><span style="color: #000000"&gt;);
        }
    }

    </span><span style="color: #0000ff"&gt;protected</span> <span style="color: #0000ff"&gt;void</span> btndelete_Click(<span style="color: #0000ff"&gt;object</span><span style="color: #000000"&gt; sender,EventArgs E)
    {
        jjlxs stujjlx </span>= <span style="color: #0000ff"&gt;new</span><span style="color: #000000"&gt; jjlxs();
        stujjlx.id </span>=<span style="color: #000000"&gt; Convert.ToInt32(txtid.Text);
        stujjlx.jjlx </span>=<span style="color: #000000"&gt; txtjjlx.Text;
        </span><span style="color: #0000ff"&gt;if</span><span style="color: #000000"&gt; (bll.deletejjlx(stujjlX))
        {
            Bind();
            Response.Write(</span><span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;<script>alert('删除成功!')</script></span><span style="color: #800000"&gt;"</span><span style="color: #000000"&gt;);
        }
        </span><span style="color: #0000ff"&gt;else</span><span style="color: #000000"&gt;
        {
            Response.Write(</span><span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;<script>alert('删除失败!')</script></span><span style="color: #800000"&gt;"</span><span style="color: #000000"&gt;);
        }
    }

    </span><span style="color: #0000ff"&gt;protected</span> <span style="color: #0000ff"&gt;void</span> btngai_Click(<span style="color: #0000ff"&gt;object</span><span style="color: #000000"&gt; sender,EventArgs E)
    {
        jjlxs stujjlx </span>= <span style="color: #0000ff"&gt;new</span><span style="color: #000000"&gt; jjlxs();
        stujjlx.id </span>=<span style="color: #000000"&gt; Convert.ToInt32(txtid.Text);
        stujjlx.jjlx </span>=<span style="color: #000000"&gt; txtjjlx.Text;
        </span><span style="color: #0000ff"&gt;if</span><span style="color: #000000"&gt; (bll.Udatejjlx(stujjlX))
        {
            Bind();
            Response.Write(</span><span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;<script>alert('修改成功!')</script></span><span style="color: #800000"&gt;"</span><span style="color: #000000"&gt;);
        }
        </span><span style="color: #0000ff"&gt;else</span><span style="color: #000000"&gt;
        {
            Response.Write(</span><span style="color: #800000"&gt;"</span><span style="color: #800000"&gt;<script>alert('修改失败!')</script></span><span style="color: #800000"&gt;"</span><span style="color: #000000"&gt;);
        }

    }
}

}

大佬总结

以上是大佬教程为你收集整理的asp.net三层架构增删改查全部内容,希望文章能够帮你解决asp.net三层架构增删改查所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。
标签: