資源簡介
簡單新聞發布系統
源碼描述:
一、源碼特點
新聞發布系統、對數據庫數據的增、刪、改、查,搜索、后臺管理、新聞發布、登錄驗證等
二、菜單功能
前臺頁面
1、新聞欄目展示,新聞詳細信息展示等
2、關鍵字查詢;導航欄查詢
3、后臺入口
后臺管理
1、導航欄:各類新聞模塊列表
2、瀏覽信息:關鍵字查詢;導航欄查詢;新聞列表展示和修改、刪除等
三、注意事項
1、開發環境為Visual Studio 2010,數據庫為SQL Server 2008,使用.net 3.5開發。
2、管理員登陸名密碼均為:admin
3、附加數據庫連接字符串配置文件在web.config
4、DB文件夾中是數據庫文件,附加即可
作者:菜鳥一號已經存在
代碼片段和文件信息
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?Default?:?System.Web.UI.Page
{
????protected?void?Page_Load(object?sender?EventArgs?e)
????{
????????SqlData?da?=?new?SqlData();
????????string?strShiShi?=?“select?top?5?*?from?tb_News?where?Categories=‘時事新聞‘?order?by?issueDate?desc“;
????????string?strEconomic?=?“select?top?5?*?from?tb_News?where?Categories=‘環球經濟‘?order?by?issueDate?desc“;
????????string?strMilitary?=?“select?top?5?*?from?tb_News?where?Categories=‘軍事世界‘?order?by?issueDate?desc“;
????????string?strScience?=?“select?top?5?*?from?tb_News?where?Categories=‘科學技術‘?order?by?issueDate?desc“;
????????string?strSocial?=?“select?top?5?*?from?tb_News?where?Categories=‘社會百態‘?order?by?issueDate?desc“;
????????string?strSports?=?“select?top?5?*?from?tb_News?where?Categories=‘世界體育‘?order?by?issueDate?desc“;
????????string?strFun?=?“select?top?5?*?from?tb_News?where?Categories=‘娛樂綜藝‘?order?by?issueDate?desc“;
????????string?strLife?=?“select?top?5?*?from?tb_News?where?Categories=‘生活理財‘?order?by?issueDate?desc“;
????????SqlDataReader?dar?=?da.ExecuteRead(strShiShi);
????????dlstShiShi.DataSource?=?dar;
????????dlstShiShi.DataKeyField?=?“id“;
????????dlstShiShi.DataBind();
????????dar.Close();
????????SqlDataReader?sdrEco?=?da.ExecuteRead(strEconomic);
????????dlstEconomic.DataSource?=?sdrEco;
????????dlstEconomic.DataKeyField?=?“id“;
????????dlstEconomic.DataBind();
????????sdrEco.Close();
????????SqlDataReader?sdrM?=?da.ExecuteRead(strMilitary);
????????dlstMilitary.DataSource=sdrM;
????????dlstMilitary.DataKeyField=“id“;
????????dlstMilitary.DataBind();
????????sdrM.Close();
????????SqlDataReader?sdrS?=?da.ExecuteRead(strScience);
????????dlstScience.DataSource?=?sdrS;
????????dlstScience.DataKeyField?=?“id“;
????????dlstScience.DataBind();
????????sdrS.Close();
????????SqlDataReader?sdrSoc?=?da.ExecuteRead(strSocial);
????????dlstSocial.DataSource?=?sdrSoc;
????????dlstSocial.DataKeyField?=?“id“;
????????dlstSocial.DataBind();
????????sdrSoc.Close();
????????SqlDataReader?sdrSp?=?da.ExecuteRead(strSports);
????????dlstSports.DataSource?=?sdrSp;
????????dlstSports.DataKeyField?=?“id“;
????????dlstSports.DataBind();
????????sdrSp.Close();
????????SqlDataReader?sdrFun?=?da.ExecuteRead(strFun);
????????dlstFun.DataSource?=?sdrFun;
????????dlstFun.DataKeyField?=?“id“;
????????dlstFun.DataBind();
????????sdrFun.Close();
????????SqlDataReader?sdrLife?=?da.ExecuteRead(strLife);
????????dlstLife.DataSource?=?sdrLife;
????????dlstLife.DataKeyField?=?“id“;
????????dlstLife.DataBind();
????????sdrLife.Close();
????}
????protected?void?dlstShiShi_ItemCommand(object?source?DataListCommandEventArgs?e)
????{
????????i
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1968??2015-03-18?11:16??CNPressReleaseSystem\App_Code\SqlData.cs
?????文件???????4569??2010-01-01?21:28??CNPressReleaseSystem\BackDesk\AddNews.aspx
?????文件???????2120??2009-10-17?13:21??CNPressReleaseSystem\BackDesk\AddNews.aspx.cs
?????文件???????2147??2010-01-01?20:57??CNPressReleaseSystem\BackDesk\AddUser.aspx
?????文件???????1643??2009-10-17?10:33??CNPressReleaseSystem\BackDesk\AddUser.aspx.cs
?????文件????????553??2009-12-31?15:53??CNPressReleaseSystem\BackDesk\foot.htm
?????文件????????891??2010-01-01?20:32??CNPressReleaseSystem\BackDesk\head.htm
?????文件????????939??2010-01-01?20:34??CNPressReleaseSystem\BackDesk\Index.aspx
?????文件????????406??2009-10-17?10:32??CNPressReleaseSystem\BackDesk\Index.aspx.cs
?????文件???????2788??2010-01-01?21:26??CNPressReleaseSystem\BackDesk\Login.aspx
?????文件???????1745??2009-10-17?09:46??CNPressReleaseSystem\BackDesk\Login.aspx.cs
?????文件????????554??2009-12-31?16:01??CNPressReleaseSystem\BackDesk\Main.aspx
?????文件????????405??2009-10-17?10:33??CNPressReleaseSystem\BackDesk\Main.aspx.cs
?????文件???????6301??2010-01-31?20:30??CNPressReleaseSystem\BackDesk\Menu.aspx
?????文件????????405??2009-10-17?10:33??CNPressReleaseSystem\BackDesk\Menu.aspx.cs
?????文件???????5316??2010-01-24?22:32??CNPressReleaseSystem\BackDesk\NewsManage.aspx
?????文件???????2593??2009-10-17?10:19??CNPressReleaseSystem\BackDesk\NewsManage.aspx.cs
?????文件???????4633??2010-01-01?21:28??CNPressReleaseSystem\BackDesk\UpdateNews.aspx
?????文件???????2082??2009-10-17?10:33??CNPressReleaseSystem\BackDesk\UpdateNews.aspx.cs
?????文件???????5326??2009-12-31?16:54??CNPressReleaseSystem\BackDesk\UserManage.aspx
?????文件???????2261??2009-10-17?10:01??CNPressReleaseSystem\BackDesk\UserManage.aspx.cs
?????文件???????1817??2009-12-28?01:27??CNPressReleaseSystem\css\st
?????文件????1835008??2015-03-18?11:14??CNPressReleaseSystem\DB\db_news_Data.MDF
?????文件????1048576??2015-03-18?11:14??CNPressReleaseSystem\DB\db_news_Log.LDF
?????文件??????18300??2009-12-28?01:38??CNPressReleaseSystem\Default.aspx
?????文件???????5522??2009-12-28?01:48??CNPressReleaseSystem\Default.aspx.cs
?????文件?????????23??2010-01-24?22:16??CNPressReleaseSystem\Images\.picasa.ini
?????文件???????2463??2009-12-31?16:36??CNPressReleaseSystem\Images\3.gif
?????文件???????2490??2009-12-31?16:41??CNPressReleaseSystem\Images\4.gif
?????文件???????2471??2009-12-31?16:49??CNPressReleaseSystem\Images\5.gif
............此處省略41個文件信息
- 上一篇:asp.net新聞發布系統(源碼+數據庫+論文)
- 下一篇:Log4Net案例
評論
共有 條評論