ASPNET课程实验报告

PAGEPAGE1《ASP.NET程序设计》课程实验报告实验课题：专业：计算机应用班级：指导教师：完成人：2011年5月29

5.3留言板publicpartialclassliuyan:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidButton1_Click(objectsender,EventArgse){if(Session["userID"]!=null){if(TextBox1.Text==""||TextBox2.Text==""){Page.RegisterStartupScript("","<script>alert('请输入留言主题和内容!');</script>");}else{try{stringconnstr=ConfigurationManager.ConnectionStrings["WShopConnectionString"].ConnectionString;SqlConnectionconn=newSqlConnection(connstr);conn.Open();SqlCommandcmd=newSqlCommand("Proc_InsertMessageInfo",conn);cmd.CommandType=CommandType.StoredProcedure;SqlParameterpara1=newSqlParameter("@userID",SqlDbType.Int);para1.Value=Session["userID"].ToString();cmd.Parameters.Add(para1);SqlParameterpara2=newSqlParameter("@Heading",TextBox1.Text);cmd.Parameters.Add(para2);SqlParameterpara3=newSqlParameter("@Content",SqlDbType.NVarChar);para3.Value=TextBox2.Text;cmd.Parameters.Add(para3);SqlParameterpara4=newSqlParameter("@Time",SqlDbType.DateTime);para4.Value=DateTime.Now.ToShortDateString();cmd.Parameters.Add(para4);SqlParameterpara5=newSqlParameter("@flag",DbType.Int32);para5.Direction=ParameterDirection.Output;cmd.Parameters.Add(para5);cmd.ExecuteNonQuery();Page.RegisterStartupScript("","<script>alert('发表成功!');</script>");conn.Close();}catch{}}}else{Response.Redirect("denglu.aspx");}Response.Redirect("liuyan.aspx");}}5.4商品查询protectedvoidButton1_Click(objectsender,EventArgse){SqlDataSource2.SelectParameters.Clear();stringstr=SqlDataSource2.SelectCommand+"whereWaretype.typeID=@typeID";Parameterpara1=newParameter("typeID",DbType.Int16);para1.DefaultValue=DropDownList1.SelectedItem.Value;SqlDataSource2.SelectParameters.Add(para1);if(TextBox1.Text!=""){str+="andWare.Warenamelike'%'+@Warename+'%'";SqlDataSource2.SelectParameters.Add("Warename",TextBox1.Text);}GridView1.DataSourceID=null;SqlDataSource2.SelectCommand=str;GridView1.DataSourceID="SqlDataSource2";}5.5在线聊天protectedvoidPage_Load(objectsender,EventArgse)

{

if(Session["uName"]!=null)

{

lblOnlineNum.Text="当前在线人数为"+Application["count"].ToString()+"人";

txtChatRoom.Text=Application["chat"].ToString();

lblName.Text=Session["uName"].ToString();

}

else

{

Response.Redirect("denglu.aspx");

}

}

protectedvoidbtnSend_Click(objectsender,EventArgse)

{

stringtab="";

stringnewline="\r";

stringnewMessage=lblName.Text+";"+tab+txtChat.Text+newline+Application["chat"];

if(newMessage.Length>500)

newMessage=newMessage.Substring(0,499);

Application.Lock();

Application["chat"]=newMessage;

Application.UnLock();

txtChat.Text="";

txtChatRoom.Text=Application["chat"].ToString();

}

5.6在线投票publicpartialclasstoupiao:System.Web.UI.Page{ArrayListcn=newArrayList();protectedvoidPage_Load(objectsender,EventArgse){//validatorlogin.Validator();if(Request.Cookies["vote"]!=null){lblState.Text="<b>您已经投过票了！</b>";}else{lblState.Text="<b>您可以投票！</b>";}getVote();}protectedvoidgetVote(){stringfilePath=Server.MapPath("vote.txt");try{StreamReadersr=File.OpenText(filePath);stringstr=sr.ReadLine();string[]strvote=str.Split(',');foreach(stringssinstrvote)cn.Add(int.Parse(ss));sr.Close();}catch(Exceptionee){Response.Write("<script>alert('"+ee.Message+"')</script>");}}protectedvoidputVote(){stringfilePath=Server.MapPath("vote.txt");try{StreamWritersw=newStreamWriter(filePath,false);//false表示不是追加的stringstr=cn[0].ToString();for(inti=1;i<cn.Count;i++){str+=","+cn[i].ToString();}sw.WriteLine(str);sw.Close();}catch(Exceptionee){Response.Write("<script>alert('"+ee.Message+"')</script>");}}protectedvoidbtnVote_Click(objectsender,EventArgse){if(rbtlVote.SelectedIndex!=-1){if(Request.Cookies["vote"]==null){inti=rbtlVote.SelectedIndex;cn[i]=int.Parse(cn[i].ToString())+1;putVote();Response.Cookies["vote"].Value="vt";Response.Cookies["vote"].Expires=DateTime.Now.AddDays(14);Response.Write("<script>alert('投票成功！')</script>");}else{Response.Write("<script>alert('您