ASP.NET程序设计：留言板的实现.pptVIP

任务实施 步骤7．配置SqlDataSouce1数据源控件，其HTML代码如下： asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString=%$ ConnectionStrings:SMDBConnStr % SelectCommand=SELECT T_bbsNote.tz_NoteID, T_bbsNote.tz_Heading, T_Vip.hy_Username, T_bbsNote.tz_Time FROM T_bbsNote INNER JOIN T_Vip ON T_bbsNote.hy_VipID = T_Vip.hy_VipID /asp:SqlDataSource 任务实施 步骤8．创建存储过程，保存所发表的留言信息。代码如下： create proc [dbo].[Proc_InsertMessageInfo] (@VipID int, @tz_Heading varchar(20), @tz_Content varchar(8000), @tz_Time smallDateTime, @flag int output) as begin insert dbo.T_bbsNote(hy_VipID,tz_Heading,tz_Content,tz_Time) values(@VipID,@tz_Heading,@tz_Content,@tz_Time) return @@rowcount end 任务实施 步骤9．给MessageBoard.aspx的页面中的btnConfirm按钮添加Click事件，代码如下： protected void btnConfirm_Click (object sender, EventArgs e) { if (Session[VipID] != null) { if (txtContent.Text == || txtTitle.Text == ) { Page.RegisterStartupScript(, scriptalert(请输入留言主题和内容！); /script); } else { try{ string connstr = ConfigurationManager.ConnectionStrings[SMDBConnStr].ConnectionString; SqlConnection conn = new SqlConnection(connstr); conn.Open(); 任务实施 SqlCommand cmd = new SqlCommand(Proc_InsertMessageInfo, conn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter para1 = new SqlParameter(@VipID, SqlDbType.Int); para1.Value = Session[VipID].ToString(); cmd.Parameters.Add(para1); SqlParameter para2 = new SqlParameter(@tz_Heading, TextBox1.Text); cmd.Parameters.Add(para2); SqlParameter para3 = new SqlParameter(@tz_Content, SqlDbType.NVarChar); para3.Value = TextBox2.Text; cmd.Parameters.Add(para3); SqlParameter para4 = new SqlParameter(@tz_Time, SqlDbType.DateTime); para4.Value = DateTime.Now.ToShortDateString(); cmd.Parameters.Add(para4); 任务实施 SqlParameter para5 = new SqlParameter(@flag, DbType.Int32); para5.Direction = ParameterDirection.Output; cmd.Parameters.Add(para5); cmd.ExecuteNonQuery(); Page.RegisterStartupScript(, scriptalert(发表成功！);/script); conn.Close(); } catch{ } } } else { Response.Redirect(Login.aspx); } }