评论功能

最新推荐文章于 2022-05-10 20:36:34 发布

qizhichao110

最新推荐文章于 2022-05-10 20:36:34 发布

阅读量1.7k

点赞数

分类专栏：易忘问题总结文章标签： asp.net

本文链接：https://blog.csdn.net/qizhichao110/article/details/8972355

版权

易忘问题总结专栏收录该内容

9 篇文章 0 订阅

订阅专栏

前台的界面需要的代码，

<head runat="server">
    <title></title>
       <style type="text/css">
.progress{
width: 1px;
height: 14px;
color: white;
font-size: 12px;
    overflow: hidden;
background-color: navy;
padding-left: 5px;
}

</style>
<style type="text/css">
#divfa a{ font-size:20px; font-weight:bold; text-decoration:none}
.style1
{
width: 100%;
}
</style>
<script type="text/JavaScript">

</script>

</head>
<body>
<p>限制：120字节</P>
    <form id="form1" runat="server">
    <div id="div2">
<asp:TextBox ID="maxcharfield" runat="server" Height="93px" MaxLength="300"
            TextMode="MultiLine" Width="500px"
            onKeyDown="textCounter(this,'progressbar1',120)"
onKeyUp="textCounter(this,'progressbar1',120)"
onFocus="textCounter(this,'progressbar1',120)"></asp:TextBox>
<div id="progressbar1" class="progress"></div>

后台代码：
    public partial class WebForm1 : System.Web.UI.Page
    {
        string sqlstr = ConfigurationManager.ConnectionStrings["sqlcon2"].ConnectionString;
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
            {
                GETRecordAll();
                BindData();
            }
        }
        public void GETRecordAll()
        {
            SqlConnection conn = new SqlConnection(sqlstr);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "select count(*) from Content";
            int a = Convert.ToInt32(cmd.ExecuteScalar());
            this.Label1.Text = "全部评论"+"("+a+")";
        }
        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            GridView1.PageIndex = e.NewPageIndex;
            BindData();
        }
        private void BindData()
        {
        using(SqlConnection conn=new SqlConnection(sqlstr))
        {
            conn.Open();
            using(SqlCommand cmd=conn.CreateCommand())
            {
                //sqlcmm.CommandText = "select UserName,contents,DATEDIFF(MINUTE,NowDate,GETDATE()) NowDate from users order by NowDate";

                cmd.CommandText = "select Content.ComContent,NowDate from Content ORDER BY Id DESC";
                SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                adapter.Fill(dt);
                this.GridView1.DataSource = dt;
                this.GridView1.DataBind();
            }
        }
        }
        protected void btnPingLun_Click(object sender, EventArgs e)
        {
            using (SqlConnection conn = new SqlConnection(sqlstr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "insert into Content(ComContent,NowDate)values(@content,@time)";
                    cmd.Parameters.AddWithValue("@content", this.maxcharfield.Text.Trim());
                    cmd.Parameters.AddWithValue("@time", DateTime.Now);
                    int n = cmd.ExecuteNonQuery();
                    if (n > 0)
                    {
                        ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert('评论成功！')</script>", false);
                        this.maxcharfield.Text = "";
                        GETRecordAll();
                        BindData();
                    }
                    else
                    {
                        ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert('评论失败！')</script>", false);
                    }
                }
            }

        }