using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.Data.SqlClient;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;

public?partial?class?background?:?System.Web.UI.Page
{?
????????string?strCon?=?“Data?Source=DESKTOP-I6F115P;Initial?Catalog=message_board3;Integrated?Security=True“;
????protected?void?Page_Load（object?sender?EventArgs?e）

????{

????????if?（!IsPostBack）

????????{

????????????BindGridView（）;

????????}

????}



????private?void?BindGridView（）

????{

????????SqlConnection?con?=?new?SqlConnection（strCon）;



????????con.Open（）;

????????SqlCommand?cmd?=?new?SqlCommand（“SELECT?[username]?[message][time]?FROM?[message]“?con）;

????????SqlDataAdapter?adp?=?new?SqlDataAdapter（cmd）;

????????DataSet?ds?=?new?DataSet（）;

????????adp.Fill（ds）;

????????this.GridView1.DataSource?=?ds.Tables[0];

????????this.GridView1.DataBind（）;

????????con.Close（）;

????}





????protected?void?GridView1_RowCancelingEdit（object?sender?GridViewCancelEditEventArgs?e）

????{

????????GridView1.EditIndex?=?-1;

????????BindGridView（）;

????}



????protected?void?GridView1_RowEditing（object?sender?GridViewEditEventArgs?e）

????{

????????GridView1.EditIndex?=?e.NewEditIndex;

????????BindGridView（）;

????}



????protected?void?GridView1_RowUpdating（object?sender?GridViewUpdateEventArgs?e）

????{

????????string?id?=?GridView1.DataKeys[e.RowIndex].Values[0].ToString（）;

????????string?username?=?（（TextBox）GridView1.Rows[e.RowIndex].FindControl（“TextBox1“））.Text;

????????string?message?=?（（TextBox）GridView1.Rows[e.RowIndex].FindControl（“TextBox2“））.Text;
????????//string?time?=?（（TextBox）GridView1.Rows[e.RowIndex].FindControl（“TextBox3“））.Text;
????????//DateTime?dt?=?Convert.ToDateTime（time）;
????????String?time?=?（（TextBox）GridView1.Rows[e.RowIndex].FindControl（“TextBox3“））.Text.Trim（）;

????????string?strUpdate?=?“UPDATE?message?set?username=‘“?+?username?+?“‘message=‘“?+?message?+?“‘time=‘“?+?time?+?“‘??where?username=“?+?username;



????????SqlConnection?con?=?new?SqlConnection（strCon）;

????????con.Open（）;

????????SqlCommand?cmd?=?new?SqlCommand（strUpdate?con）;

????????cmd.ExecuteNonQuery（）;

????????con.Close（）;

????????GridView1.EditIndex?=?-1;

????????BindGridView（）;



????}



????protected?void?GridView1_RowDeleting（object?sender?GridViewDeleteEventArgs?e）

????{

????????string?id?=?GridView1.DataKeys[e.RowIndex].Values[0].ToString（）;

????????string?strDel?=?“DELETE?FROM?message?where?username=“?+?id;

????????SqlConnection?con?=?new?SqlConnection（strCon）;

????????con.Open（）;

????????SqlCommand?cmd?=?new?SqlCommand（strDel?con）;

????????cmd.ExecuteNonQuery（）;

????????con.Close（）;

????????BindGridView（）;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3364??2019-05-03?11:06??留言板LJX?-?完成實驗三\background（1）.aspx

?????文件???????3364??2019-05-03?11:06??留言板LJX?-?完成實驗三\background.aspx

?????文件???????2899??2019-05-03?11:06??留言板LJX?-?完成實驗三\background.aspx（1）.cs

?????文件???????2899??2019-05-03?11:06??留言板LJX?-?完成實驗三\background.aspx.cs

?????文件???????2694??2019-05-03?11:07??留言板LJX?-?完成實驗三\CSS\style.css

?????文件?????132385??2019-05-03?11:07??留言板LJX?-?完成實驗三\images\back.jpg

?????文件??????30851??2019-05-03?11:07??留言板LJX?-?完成實驗三\images\back2.jpg

?????文件????????383??2019-05-03?11:07??留言板LJX?-?完成實驗三\images\icon_pencil-edit.png

?????文件????????534??2019-05-03?11:07??留言板LJX?-?完成實驗三\images\x_alt.png

?????文件???????1456??2019-05-03?11:06??留言板LJX?-?完成實驗三\login（1）.aspx

?????文件???????1456??2019-05-03?11:06??留言板LJX?-?完成實驗三\login.aspx

?????文件???????2135??2019-05-03?11:06??留言板LJX?-?完成實驗三\login.aspx（1）.cs

?????文件???????2135??2019-05-03?11:06??留言板LJX?-?完成實驗三\login.aspx.cs

?????文件???????1672??2019-05-03?11:06??留言板LJX?-?完成實驗三\messages（1）.aspx

?????文件???????1672??2019-05-03?11:06??留言板LJX?-?完成實驗三\messages.aspx

?????文件???????1808??2019-05-03?11:06??留言板LJX?-?完成實驗三\messages.aspx（1）.cs

?????文件???????1808??2019-05-03?11:06??留言板LJX?-?完成實驗三\messages.aspx.cs

?????文件???????1551??2019-05-03?11:06??留言板LJX?-?完成實驗三\register（1）.aspx

?????文件???????1551??2019-05-03?11:06??留言板LJX?-?完成實驗三\register.aspx

?????文件???????1273??2019-05-03?11:06??留言板LJX?-?完成實驗三\register.aspx（1）.cs

?????文件???????1273??2019-05-03?11:06??留言板LJX?-?完成實驗三\register.aspx.cs

?????文件????????362??2019-05-03?11:06??留言板LJX?-?完成實驗三\Web（1）.config

?????文件????????362??2019-05-03?11:06??留言板LJX?-?完成實驗三\Web.config

?????文件???????1306??2019-05-03?11:06??留言板LJX?-?完成實驗三\Web.Debug（1）.config

?????文件???????1306??2019-05-03?11:06??留言板LJX?-?完成實驗三\Web.Debug.config

?????文件????5242880??2019-05-03?11:08??留言板LJX?-?完成實驗三\實驗三數據庫\message_board3.mdf

?????文件????2097152??2019-05-03?11:07??留言板LJX?-?完成實驗三\實驗三數據庫\message_board3_log.ldf

?????文件????????848??2019-05-03?11:06??留言板LJX?-?完成實驗三\數據庫連接驗證（1）.aspx

?????文件????????848??2019-05-03?11:06??留言板LJX?-?完成實驗三\數據庫連接驗證.aspx

?????文件???????1263??2019-05-03?11:06??留言板LJX?-?完成實驗三\數據庫連接驗證.aspx（1）.cs

............此處省略11個文件信息