ASP专业实习(1)--后台添加与展示栏目

(1)后台--添加数据

后台页面--insert.aspx

insert.aspx主要代码

 <form action="" method="post" id="myform" name="myform" enctype="multipart/form-data" runat="server">                    <table class="insert-tab" width="100%">                        <tbody>                            <tr>                                <th><i class="require-red">*</i>标题：</th>                                <td>                                                                        <asp:TextBox ID="Title" runat="server" class="common-text required" Size="50"></asp:TextBox>                                                                    </td>                            </tr>                                                        <tr>                                <th></th>                                <td>                                                                        <asp:Button ID="tijiao" runat="server" Text="添加"  class="btn btn-primary btn6 mr10" OnClick="tijiao_Click"/>                                    <input class="btn btn6" onclick="history.go(-1)" value="返回" type="button">                                </td>                            </tr>                        </tbody></table>                </form>

数据库字段设置

后台代码

首先现在web.config配置连接字符串

<connectionStrings>    <add name="ConnectionString" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\maker.mdf;Integrated Security=True"      providerName="System.Data.SqlClient" />    <!--机房环境-->    <!--<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=E:\maker\App_Data\maker.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"      providerName="System.Data.SqlClient" />-->  </connectionStrings>

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;using System.Configuration;public partial class Account_user_insert : System.Web.UI.Page{    public static string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;      WebMessageBox webmessagebox = new WebMessageBox();    protected void Page_Load(object sender, EventArgs e)    {    }    protected void tijiao_Click(object sender, EventArgs e)    {                string con = connectionString;        SqlConnection conn = new SqlConnection(con);        string catetitle = this.Title.Text.Trim();        string sql = "select count(*) from cate where catetitle=N'" +catetitle+ "'"; //sql语句，查询当前添加的栏目是否存在数据库,N表示中文字符        SqlCommand cmd = new SqlCommand(sql, conn);        conn.Open();        int ret = Convert.ToInt32(cmd.ExecuteScalar()); //返回查询的条数，        conn.Close();        if (ret > 0)        {            WebMessageBox.Show("栏目名称已存在");        }        else        {            string insert = "insert into cate (catetitle)values(N'" +catetitle+ "')";            SqlCommand com = new SqlCommand(insert, conn);            conn.Open();            int i = Convert.ToInt32(com.ExecuteNonQuery());            if (i > 0)            {                                Response.Write("<SCRIPT language=JavaScript>alert('添加成功！');location='index.aspx';</SCRIPT>");            }            else            {                Response.Write("<SCRIPT language=JavaScript>alert('添加失败！');location='index.aspx';</SCRIPT>");            }        }    }}

添加成功后返回的页面

index.aspx
在此没有使用asp自带的控件，原因是不会用！！！

所以前端的主要的代码是

<div class="result-content">    <%=test %> </div>

后台index.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;using System.Data.SqlClient;using System.Configuration;public partial class Account_admin_index : System.Web.UI.Page{    public static string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;      public string test = "";    protected void Page_Load(object sender, EventArgs e)    {                string con = connectionString;        SqlConnection conn = new SqlConnection(con);        string sql = "select Id,catetitle from cate "; //查询cate表的id，catetitle字段        conn.Open();        SqlCommand cmd = new SqlCommand(sql, conn);        SqlDataAdapter sda = new SqlDataAdapter(cmd);        DataSet ds = new DataSet(); //        sda.Fill(ds); //数据填充               conn.Close();        DataTable dt = ds.Tables[0];               test = "<table class='result-tab' width='100%'><tr><th>ID</th><th>标题</th><th>操作</th></tr>";        for (int i = 0; i<dt.Rows.Count; i++)   //循环输出表格        {            test += "<tr><td>" + dt.Rows[i]["Id"].ToString() + "</td>";            test += "<td>" + dt.Rows[i]["catetitle"].ToString() + "</td>";            test += "<td><a class='link-update' href='edit.aspx?id=" + dt.Rows[i]["Id"] + "&catetitle=" + dt.Rows[i]["catetitle"] + "'>修改</a> ";            test += "<a class='link-del' href='del.aspx?id=" + dt.Rows[i]["Id"] + "'>删除</a></td></tr>";                    }        test+="</table>";            }