新闻添加新功能

 新闻添加_CKEditorFinder

添加改为储存过程

保存修改后的新闻信息
    private void EditNews()
    {
        using (SqlConnection sqlcnn = new SqlConnection(SqlHelper.cnnstring))
        {
            using (SqlCommand sqlcmm = sqlcnn.CreateCommand())
            {
                sqlcmm.CommandText = "update newsContent set title=@t,[content]=@c where id=@newsid";
                sqlcmm.Parameters.Add(new SqlParameter("@t", txtTitle.Text));
                string content = ckeditor1.Text;// Server.HtmlEncode(txtContent.Text).Replace(" ", "&nbsp;").Replace("\n", "<br/>");
                sqlcmm.Parameters.Add(new SqlParameter("@c", content));
                sqlcmm.Parameters.Add(new SqlParameter("@newsid", Request["newsid"]));

                sqlcnn.Open();
                SqlTransaction trans = sqlcnn.BeginTransaction();
                sqlcmm.Transaction = trans;
                try
                {
                    sqlcmm.ExecuteNonQuery();
                    sqlcmm.Parameters.Clear();  //把执行Insert into newcontent，Command中参数清空
                    sqlcmm.CommandText = "delete from NewsCategory where newsid=@newsid";
                    sqlcmm.Parameters.Add(new SqlParameter("@newsid", Request["newsid"]));
                    sqlcmm.ExecuteNonQuery();
                    sqlcmm.CommandText = "insert into NewsCategory(newsid,catid)values(@newsid,@cid)";
                    sqlcmm.Parameters.Add("@cid", SqlDbType.Int);
                    foreach (ListItem item in this.cklCategory.Items)
                    {
                        if (item.Selected)
                        {
                            sqlcmm.Parameters["@cid"].Value = item.Value;
                            sqlcmm.ExecuteNonQuery();
                        }
                    }
                    trans.Commit();
                }
                catch (Exception ex)
                {
                    Response.Write(ex.Message);
                    trans.Rollback();
                }
            }
        }
    }