给大家提供一个C#2.0的网站后台文章上传与前台显示的代码！呵呵！fckeditor大家自己调哦！

最新推荐文章于 2018-03-21 13:15:19 发布

行者杜丘

最新推荐文章于 2018-03-21 13:15:19 发布

阅读量786

点赞数

分类专栏：程序员升级文章标签：源代码 c# fckeditor 北京开源

本文链接：https://blog.csdn.net/onkinsen/article/details/42149719

版权

程序员升级专栏收录该内容

8 篇文章 0 订阅

订阅专栏

添加文章前台

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="addnews.aspx.cs" Inherits="cht_addnews" %>
<%@Register Assembly="CKEditor.NET" Namespace="CKEditor.NET" TagPrefix="CKEditor"%> 

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title>后台新闻发布页面</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    添加文章<br />
新闻标题<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
        <br />
新闻作者<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
        <br />
新闻大类型<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
        <br />
新闻小类型<br />
新闻图片<asp:FileUpload ID="FileUpload1" runat="server" />
        <asp:Image ID="Image1" runat="server" />
        <br />
新闻内容<br />
        <br />
        <br /><CKEditor:CKEditorControl ID="ck14" BasePath="/ckeditor" runat="server"></CKEditor:CKEditorControl>  

     
        <asp:Button ID="Button1" runat="server" Text="确认" OnClick="Button1_Click" />
    </div>
    </form>
</body>
</html>

添加文章后台

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class cht_addnews : System.Web.UI.Page
{
    //初始化一个连接开关
    SqlConnection myConn = DBClass.GetConnection();
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        MapPathStr();
    }
    //添加文章的方法开始
    void MapPathStr()
    {
        string sFile = FileUpload1.PostedFile.FileName;
        if (sFile.Trim().Length == 0)
        {
            sFile = sFile.Substring(sFile.LastIndexOf("\\") + 1);
          //  sFile = sFile.Substring(sFile.LastIndexOf("."));
            string Dtime = DateTime.Now.Date.ToString("yyyy-MM-dd");
            string Ftime = Convert.ToString(DateTime.Now.Hour) + Convert.ToString(DateTime.Now.Minute) + Convert.ToString(DateTime.Now.Second);
            //string NullPath = "../" + "files/" + Dtime + Ftime + sFile.ToLower();
            string NullPath = "files/" + Dtime + Ftime + sFile.ToLower();
            //    string NewsPath = "files/" + Dtime + Ftime + sFile.ToLower();
           // string sPath = null;
         //   FileUpload1.PostedFile.SaveAs(sPath);
            myConn.Open();
            SqlCommand cmd = new SqlCommand("cnews_ADD", myConn);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter ntime = new SqlParameter("@ntime", SqlDbType.DateTime.ToString());
            ntime.Value = Dtime.ToString();
            cmd.Parameters.Add(ntime);
            SqlParameter nauthor = new SqlParameter("@nauthor", SqlDbType.VarChar, 200);
            nauthor.Value = this.TextBox3.Text.ToString().Trim();
            cmd.Parameters.Add(nauthor);
            SqlParameter nname = new SqlParameter("@nname", SqlDbType.VarChar, 200);
            nname.Value = this.TextBox4.Text.ToString().Trim();
            cmd.Parameters.Add(nname);
            SqlParameter ntype1 = new SqlParameter("@ntype1", SqlDbType.VarChar, 200);
            ntype1.Value = this.TextBox1.Text.ToString().Trim();
            cmd.Parameters.Add(ntype1);
            SqlParameter ntype2 = new SqlParameter("@ntype2", SqlDbType.VarChar, 200);
            ntype2.Value = this.TextBox2.Text.ToString().Trim();
            cmd.Parameters.Add(ntype2);
            SqlParameter ncontent = new SqlParameter("@ncontent", SqlDbType.Text);
            ncontent.Value = this.ck14.Text.ToString();
            cmd.Parameters.Add(ncontent);
            SqlParameter nimage = new SqlParameter("@nimage", SqlDbType.Text);
            nimage.Value ="";
            cmd.Parameters.Add(nimage);
            try
            {
                cmd.ExecuteNonQuery();
                ClientScript.RegisterStartupScript(this.GetType(), "Message", "<Script>alert('新闻发布成功！')</Script>");
            }
            catch (Exception)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "Message", "<Script>alert('新闻发布失败！')</Script>");
            }
            finally
            {
                myConn.Dispose();
                myConn.Close();

            }
        }
        else
        {
            sFile = sFile.Substring(sFile.LastIndexOf("\\") + 1);
            sFile = sFile.Substring(sFile.LastIndexOf("."));
            string Dtime = DateTime.Now.Date.ToString("yyyy-MM-dd");
            string Ftime = Convert.ToString(DateTime.Now.Hour) + Convert.ToString(DateTime.Now.Minute) + Convert.ToString(DateTime.Now.Second);
            //string NullPath = "../" + "files/" + Dtime + Ftime + sFile.ToLower();
            string NullPath = "files/" + Dtime + Ftime + sFile.ToLower();
            string Ppath = Dtime + Ftime + sFile.ToLower();
        //    string NewsPath = "files/" + Dtime + Ftime + sFile.ToLower();
            string sPath = Server.MapPath(NullPath);
            FileUpload1.PostedFile.SaveAs(sPath);
            myConn.Open();
            SqlCommand cmd = new SqlCommand("cnews_ADD", myConn);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter ntime = new SqlParameter("@ntime", SqlDbType.DateTime.ToString());
            ntime.Value = Dtime.ToString();
            cmd.Parameters.Add(ntime);
            SqlParameter nauthor = new SqlParameter("@nauthor", SqlDbType.VarChar,200);
            nauthor.Value = this.TextBox3.Text.ToString().Trim();
            cmd.Parameters.Add(nauthor);
            SqlParameter nname= new SqlParameter("@nname", SqlDbType.VarChar, 200);
            nname.Value = this.TextBox4.Text.ToString().Trim();
            cmd.Parameters.Add(nname);
            SqlParameter ntype1 = new SqlParameter("@ntype1", SqlDbType.VarChar, 200);
            ntype1.Value = this.TextBox1.Text.ToString().Trim();
            cmd.Parameters.Add(ntype1);
            SqlParameter ntype2 = new SqlParameter("@ntype2", SqlDbType.VarChar, 200);
            ntype2.Value = this.TextBox2.Text.ToString().Trim();
            cmd.Parameters.Add(ntype2);
            SqlParameter ncontent = new SqlParameter("@ncontent", SqlDbType.Text);
            ncontent.Value =this.ck14.Text.ToString();
            cmd.Parameters.Add(ncontent);
            SqlParameter nimage = new SqlParameter("@nimage", SqlDbType.Text);
            nimage.Value = Ppath.ToString().Trim();
            cmd.Parameters.Add(nimage);
            try
            {
                cmd.ExecuteNonQuery();
                ClientScript.RegisterStartupScript(this.GetType(), "Message", "<Script>alert('新闻发布成功！')</Script>");
            }
            catch (Exception)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "Message", "<Script>alert('新闻发布失败！')</Script>");
            }
            finally
            {
                myConn.Dispose();
                myConn.Close();

            }
        }
    }
    //添加文章的方法结束
}

显示文章列表前台，大家举一反三吧！！！我这是显示所有，没有加翻页控件！！！我会坚持开源！！！我爱编程！从心里爱你们！有机会下个月来北京参加csdn的活动！！！

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server"><%-- ImageUrl='<%#Eval("nimage","./ht/files/{0}")%>' "/ht/files/"+
         <asp:Image ID="image1"runat="server" ImageUrl='<%# Eval("nimage") %>' Width="300px" Height="500px" /> 
        
        --%>
    <div>
    
    </div> 

        <asp:DataList ID="d1" runat="server"  >
            <ItemTemplate>  
                <asp:Image ID="Image2" runat="server"  ImageUrl='<%#Eval("nimage","./ht/files/{0}")%>' AlternateText='<%#Eval("nname") %>' Width="100px" Height="100px" />
        <b><asp:Label ID="i1" runat="server" ><%#Eval("nname")%></asp:Label></b>
                <asp:Label ID="c1" runat="server"><%#Eval("ncontent") %></asp:Label>
                <label title="阅读更多内容 >>"></label>
            </ItemTemplate>
        </asp:DataList>
    </form>
    <p>
         </p>
</body>
</html>

显示文章后台

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
 

public partial class test : System.Web.UI.Page
{
    SqlConnection myConn = DBClass.GetConnection();
    protected void Page_Load(object sender, EventArgs e)
    {
      
        if (!IsPostBack)
        {
            //此方法绑定数据库
            DBBind();


        }
    
    }
    
   
    public void DBBind()
    {
        SqlConnection myConn = DBClass.GetConnection();
        myConn.Open();
        SqlCommand cmd = new SqlCommand("cnews_GetList", myConn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.ExecuteNonQuery();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "GoodsInfo");
        d1.DataSource = ds.Tables["GoodsInfo"].DefaultView;
        d1.DataBind();

        //cmd.Dispose();woxiawuyaochuqule 
        myConn.Close();

    }
    }