繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > 用asp.net写的论坛程序--论坛主页
- ASP
- ASP编程入门进阶（十二）：ASP技巧累加（一）
- ASP编程入门进阶（十三）：Ad & Content Rotator
- ASP编程入门进阶（十四）：Browser & Linking
- ASP编程入门进阶（十五）：组件Counters
- 一些简单的ASP练习
- ASP编程入门进阶（十六）：FSO组件之驱动器操作
- ASP编程入门进阶（十七）：FSO组件之文件夹操作
- ASP编程入门进阶（十八）：FSO组件之文件操作（上）
- ASP编程入门进阶（十八）：FSO组件之文件操作（中）
- ASP编程入门进阶（十八）：FSO组件之文件操作（下）
- ASP编程入门进阶（十九）：ASP技巧累加（二）
- ASP中有关双引号，单引号以及&号的解释
- ASP编程入门进阶（二十）：ADO组件之显示数据记录
- ASP编程入门进阶（二十）：ADO组件之插入数据记录
- ASP编程入门进阶（二十）：ADO组件之分页程序
- ASP编程入门进阶（二十）：ADO组件之修改数据记录
- ASP编程入门进阶（二十）：ADO组件之删除数据记录
- ASP初学者常犯的几个错误（ZT）
- 无组件上传图片之文件采用方案
- ASP编程入门进阶（二十）：ADO组件之查询数据记录
ASP 中的 用asp.net写的论坛程序--论坛主页
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-11-03 浏览: 172 ::
收藏到网摘: n/a
<%@ Page Language="C#" Debug="true" %>
<%@ Assembly Name="System.Data" %>
<%@ Import Namespace="System.Data.ADO" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System" %>
<html><head>
<title>Welcome to My Forum!</title>
<script language="C#" runat="server" >
//execute this script when the page loads
void Page_Load(Object Src, EventArgs E)
{
//Call the Method to DataBind the DataGrid
Binding() ;
}
//This Method Connects to the Database, and DataBinds the Database to the DataGrid
public void Binding()
{
//String to connect to the database, If your Database is in some other directory then change the path
//To the Database below
string strConn=@"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source="+Server.MapPath(".\\db\\board.mdb") ;
//Make a Connection to the Database
ADOConnection myConn = new ADOConnection(strConn) ;
//String to select records from the Database. newpost Table
//I have used "ORDER BY postid DESC" since I want to show the latest post on the top
//If you remove this clause then the oldest message will be shown first
string strCom = "SELECT postid ,subject ,name ,replies ,views ,date FROM newpost ORDER BY postid DESC" ;
//Open the Connection, Always remember to Open the connection before doing anything else
myConn.Open();
DataSet myDataSet = new DataSet();
//Create a ADODataSetCommand and a DataSet
ADODataSetCommand myCommand =new ADODataSetCommand(strCom,myConn);
//Fill the DataSet
myCommand.FillDataSet(myDataSet,"newpost") ;
//Connection is closed
myConn.Close();
//Set the DataView of the Table "newpost" contained in the DataSet for the DataGrid
DataGrid1.DataSource = myDataSet.Tables["newpost"].DefaultView ;
//DataBind the DataGrid
DataGrid1.DataBind();
}
//This method is called when the DataGrid is Paged (i.e. when you change from Page 1 to Page 2 etc.. )
public void DataGrid_Updt(Object sender, DataGridPageChangedEventArgs e)
{
//Call the Method to Databind
Binding();
}
//This Method is called when the form is submitted to make a new Post
public void Submit_Click(Object sender, EventArgs e)
{
//proceed only if all the required fields are filled-in
if(Page.IsValid&&name.Text!=""&&subject.Text!=""&&email.Text!=""){
//Get the Current Date and Time
DateTime now = DateTime.Now ;
errmess.Text="" ;
//I am building a custom query which will be used to call the postmessage.aspx page.
//Since it will be a query we have to encode the query into UTF8 format.
//So I get all the fields from the form and encode them into UTF8 format
string req = "name="+ System.Web.HttpUtility.UrlEncodeToString(name.Text, System.Text.Encoding.UTF8);
req+="&&email="+ System.Web.HttpUtility.UrlEncodeToString(email.Text, System.Text.Encoding.UTF8);
req+="&&subject="+ System.Web.HttpUtility.UrlEncodeToString(subject.Text, System.Text.Encoding.UTF8);
//Get the HostAddress of the Author
req+="&&ip="+ System.Web.HttpUtility.UrlEncodeToString(Request.UserHostAddress.ToString(), System.Text.Encoding.UTF8);
req+="&&date="+ System.Web.HttpUtility.UrlEncodeToString(now.ToString(), System.Text.Encoding.UTF8);
req+="&&message="+ System.Web.HttpUtility.UrlEncodeToString(message.Text, System.Text.Encoding.UTF8);
//A 'yes' is used below to tell the postmessage page that this is a new topic post
req+="&&newpost="+ System.Web.HttpUtility.UrlEncodeToString("yes", System.Text.Encoding.UTF8);
//call the postmessage.aspx page and append the query to it.
Page.Navigate("postmess
评论 (0) All
