ASP.Net增删查改写的一个通讯录系统---ShinePans
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了ASP.Net增删查改写的一个通讯录系统---ShinePans,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含8604字,纯文字阅读大概需要13分钟。
内容图文
![ASP.Net增删查改写的一个通讯录系统---ShinePans](/upload/InfoBanner/zyjiaocheng/1245/89d532e929f149dc853317ef9b1153a9.jpg)
1.开发环境
2.更能说明
3.网页效果
![技术分享](/upload/getfiles/default/2022/11/13/20221113110040867.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110041096.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110041338.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110041563.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110041875.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110042162.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110042458.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110042665.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110042895.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110043137.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110043418.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110043623.jpg)
![技术分享](/upload/getfiles/default/2022/11/13/20221113110043796.jpg)
4.关键代码:
<%@ Page Title="Delete" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeFile="Delete.aspx.cs" Inherits="Delete" %> <asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server"> <p> </p> <p> </p> <p> </p> <p> </p> <p> <asp:LinkButton ID="LinkButton1" runat="server" OnClick="LinkButton1_Click">查看所有的联系人</asp:LinkButton> </p> <p> 所有联系人如下,请输入要删除的人的姓名或编号或电话号码:</p> <p> 按电话号码删除:</p> <p> <asp:TextBox ID="Phone" runat="server"></asp:TextBox> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="删除" /> </p> <p> 按名字删除:</p> <p> <asp:TextBox ID="Name" runat="server"></asp:TextBox> <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="删除" /> </p> <p> 按编号删除:</p> <p> <asp:TextBox ID="ID" runat="server"></asp:TextBox> <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="删除" /> </p> <p> </p> <p> <asp:GridView ID="GridView1" runat="server" Width="739px"> </asp:GridView> </p> </asp:Content>
default.aspx.cs:
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; using System.Data; public partial class _Default : Page { protected void Page_Load(object sender, EventArgs e) { } protected void LinkButton1_Click(object sender, EventArgs e) { string ConString="Data Source=(LocalDB)\\v11.0;AttachDbFilename=d:\\UserFile\\Documents\\Visual Studio 2013\\WebSites\\WebSite5\\App_Data\\contact.mdf;Integrated Security=True"; string sql1 = "select * from contact"; SqlConnection myconn = new SqlConnection(ConString); SqlCommand mycmd = new SqlCommand(sql1, myconn); SqlDataAdapter sda = new SqlDataAdapter(mycmd); DataSet ds = new DataSet(); sda.Fill(ds, "contact"); this.GridView1.DataSource = ds.Tables["contact"]; this.GridView1.DataBind(); myconn.Close(); } protected void Button1_Click(object sender, EventArgs e) { string ConString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=d:\\UserFile\\Documents\\Visual Studio 2013\\WebSites\\WebSite5\\App_Data\\contact.mdf;Integrated Security=True"; string sql1 = "select * from contact where name='"+this.Name.Text.ToString().Trim()+"';"; SqlConnection myconn = new SqlConnection(ConString); SqlCommand mycmd = new SqlCommand(sql1, myconn); SqlDataAdapter sda = new SqlDataAdapter(mycmd); DataSet ds = new DataSet(); sda.Fill(ds, "contact"); this.GridView1.DataSource = ds.Tables["contact"]; this.GridView1.DataBind(); myconn.Close(); } protected void Button2_Click(object sender, EventArgs e) { string ConString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=d:\\UserFile\\Documents\\Visual Studio 2013\\WebSites\\WebSite5\\App_Data\\contact.mdf;Integrated Security=True"; string sql1 = "select * from contact where address='"+this.Address.Text+"';"; SqlConnection myconn = new SqlConnection(ConString); SqlCommand mycmd = new SqlCommand(sql1, myconn); SqlDataAdapter sda = new SqlDataAdapter(mycmd); DataSet ds = new DataSet(); sda.Fill(ds, "contact"); this.GridView1.DataSource = ds.Tables["contact"]; this.GridView1.DataBind(); myconn.Close(); } protected void Button3_Click(object sender, EventArgs e) { string ConString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=d:\\UserFile\\Documents\\Visual Studio 2013\\WebSites\\WebSite5\\App_Data\\contact.mdf;Integrated Security=True"; string sql1 = "select * from contact where vocation='"+this.vocation.Text+"';"; SqlConnection myconn = new SqlConnection(ConString); SqlCommand mycmd = new SqlCommand(sql1, myconn); SqlDataAdapter sda = new SqlDataAdapter(mycmd); DataSet ds = new DataSet(); sda.Fill(ds, "contact"); this.GridView1.DataSource = ds.Tables["contact"]; this.GridView1.DataBind(); myconn.Close(); } protected void vocation_TextChanged(object sender, EventArgs e) { } }
<%@ Page Title="Add" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeFile="Add.aspx.cs" Inherits="Add" %> <asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server"> <div class="jumbotron"> <h1>添加联系人</h1> <p class="lead"> Add new information...</p> <p class="lead">ID: <asp:TextBox ID="ID" runat="server"></asp:TextBox> </p> <p class="lead">姓名:<asp:TextBox ID="Name" runat="server"></asp:TextBox> </p> <p class="lead">性别:<asp:TextBox ID="Sex" runat="server"></asp:TextBox> </p> <p class="lead">年龄:<asp:TextBox ID="Age" runat="server"></asp:TextBox> </p> <p class="lead">住址:<asp:TextBox ID="Address" runat="server"></asp:TextBox> </p> <p class="lead">职业:<asp:TextBox ID="Vacation" runat="server"></asp:TextBox> </p> <p class="lead">电话:<asp:TextBox ID="Phone" runat="server"></asp:TextBox> </p> <p class="lead"> <asp:Button ID="Submit" runat="server" OnClick="Submit_Click" Text="提交" /> </p> <p class="lead">当前已存在的联系人:</p> <p class="lead"> </p> </div> <div class="row"> <asp:GridView ID="GridView1" runat="server" Height="151px" Width="794px"> </asp:GridView> <br /> <br /> </div> </asp:Content>
using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Add : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string tempName = this.Name.Text.Trim(); string ConString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=d:\\UserFile\\Documents\\Visual Studio 2013\\WebSites\\WebSite5\\App_Data\\contact.mdf;Integrated Security=True"; string sql1 = "select * from contact"; SqlConnection myconn = new SqlConnection(ConString); SqlCommand mycmd = new SqlCommand(sql1, myconn); SqlDataAdapter sda = new SqlDataAdapter(mycmd); DataSet ds = new DataSet(); sda.Fill(ds, "contact"); this.GridView1.DataSource = ds.Tables["contact"]; this.GridView1.DataBind(); myconn.Close(); } protected void Submit_Click(object sender, EventArgs e) { string tempName=this.Name.Text.Trim(); string ConString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=d:\\UserFile\\Documents\\Visual Studio 2013\\WebSites\\WebSite5\\App_Data\\contact.mdf;Integrated Security=True"; string sql1 = "insert into contact values(@ID,@name,@address,@phonenumber,@age,@sex,@vocation)"; SqlConnection myconn = new SqlConnection(ConString); SqlCommand mycmd = new SqlCommand(sql1, myconn); mycmd.Parameters.Add(new SqlParameter("@ID",SqlDbType.Int)); mycmd.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 50)); mycmd.Parameters.Add(new SqlParameter("@address", SqlDbType.NVarChar, 50)); mycmd.Parameters.Add(new SqlParameter("@phonenumber", SqlDbType.NVarChar, 50)); mycmd.Parameters.Add(new SqlParameter("@age", SqlDbType.Int)); mycmd.Parameters.Add(new SqlParameter("@sex", SqlDbType.NChar, 10)); mycmd.Parameters.Add(new SqlParameter("@vocation", SqlDbType.NVarChar, 50)); mycmd.Parameters["@ID"].Value = this.ID.Text; mycmd.Parameters["@name"].Value = this.Name.Text; mycmd.Parameters["@address"].Value = this.Address.Text; mycmd.Parameters["@phonenumber"].Value = this.Phone.Text; mycmd.Parameters["@age"].Value = this.Age.Text; mycmd.Parameters["@sex"].Value = this.Sex.Text; mycmd.Parameters["@vocation"].Value = this.Vacation.Text; myconn.Open(); mycmd.ExecuteNonQuery(); //Reset all textbox this.ID.Text = ""; this.Name.Text = ""; this.Address.Text = ""; this.Phone.Text = ""; this.Age.Text = ""; this.Sex.Text = ""; this.Vacation.Text = ""; Response.Write("<script>alert(‘已近添加成功,请见添加成功的数据')</script>"); string sql2 = "select * from contact"; SqlCommand newcmd = new SqlCommand(sql2, myconn); SqlDataAdapter sda = new SqlDataAdapter(newcmd); DataSet ds = new DataSet(); sda.Fill(ds, "contact"); this.GridView1.DataSource = ds.Tables["contact"]; this.GridView1.DataBind(); myconn.Close(); } }
原文:http://blog.csdn.net/shinepan/article/details/46558615
内容总结
以上是互联网集市为您收集整理的ASP.Net增删查改写的一个通讯录系统---ShinePans全部内容,希望文章能够帮你解决ASP.Net增删查改写的一个通讯录系统---ShinePans所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。