0351校园信息发布平台附录

1、ublicstringnpics,nlinks,ntexts; protected void Page_Load(objecder,EventArgspublicstringnpics,nlinks,ntexts; protected void Page_Load(objecder,EventArgsifDataSetds=DBHelper.GetDataSet(selecttop10*fromTB_XinWenorderbyID); this.GridView1.DataSource = ds.Tables0;DataSet ds1 =DBHelper.GetDataSet(select t

2、op4 *from TB_FenCaiorder byIDdesc); this.DataList1.DataSource = ds1.Tables0;privatevoidstringsql= selecttop5*from TB_FenCai; DataSet result = new DataSet();result=DBHelper.GetDataSet(sql); if (result != null)if(result.Tables0.Rows.Counti= for(i=0;i this.TextBox1.Text=this.TextBox2.Text=protectedvoid

3、der,EventArgsstringSQL=; bool iRet=false;if(RequestID!= stringprotectedvoidder,EventArgsstringSQL=; bool iRet=false;if(RequestID!= stringid= SQL =updateTB_AdminsetUserName=+ this.TextBox1.Text+ ,PassWord=+ this.TextBox2.Text + where ID= + id + ;iRet =SQL=insert this.TextBox2.Text + );oTB_Admin(UserN

4、ame,PassWord)values(+this.TextBox1.Text+,iRet =ifprotectedvoidder,ImageClickEventArgsif(Txtpwd.Text.ToString().Trim()=|Txtuid.Text.ToString().Trim()=stringsql=select*fromTB_AdminwhereUserName=+Txtuid.Text.ToString().Trim()+and PassWord= + Txtpwd.Text.ToString().Trim() + ;DataSetsql=select*fromTB_Adm

5、inwhereUserName=+Txtuid.Text.ToString().Trim()+and PassWord= + Txtpwd.Text.ToString().Trim() + ;DataSetresult=DBHelper.GetDataSet(sql); if (result != null)if(result.Tables0.Rows.Countusername=cx不public icstringprotectedvoidder,EventArgsifif(RequestID!=protectedvoidstringid=RequestID.ToString(); stri

6、ngsql =select* from TB_FenCaiwhere ID= +abledtstringid=RequestID.ToString(); stringsql =select* from TB_FenCaiwhere ID= +abledt= if(dt.Rows.Count this.TextBox1.Text=this.WebEditor1.Text=fname= this.Image1.ImageUrl= ./+ privatevoidif(UploadFile.Value!=stringnam=i = nam.LastIndexOf(.);stringnewext= Da

7、teTime now = DateTime.Now;stringnewname=()+ : 我这里用tedFile.SaveAs(Server.MapPath(./UpLoad/+newname+fname= UpLoad/+ newname +protectedvoidstringder,EventArgsif(UploadFile.Valueprotectedvoidstringder,EventArgsif(UploadFile.Value!=null&UploadFile.Value!=if(RequestID!=string id= sql=updateTB_FenCaisetTit

8、le=+TextBox1.Text+,PIC=+fname + this.WebEditor1.Text + whereID= +boolb=DBHelper.ExecSql(sql); if (b)sql=,+ this.WebEditor1.Text ,+ +boolb=DBHelper.ExecSql(sql); if (b)protectedvoidder,EventArgsif(this.TextBox2.Text=|this.TextBox3.Text=protectedvoidder,EventArgsif(this.TextBox2.Text=|this.TextBox3.Text=elseif(this.TextBox2.Text=str