}
ÒÔÏÂlbggtx_Click()ʼþÖ÷ҪʵÏÖÓû§ÉÏ´«Í·ÏñºÍÐÞ¸ÄÍ·Ïñ
protected void lbggtx_Click(object sender, EventArgs e) {
SqlConnection con = conn.createconnection(); con.Open();
string fullname = FileUpload1.PostedFile.FileName;
string filename = fullname.Substring(fullname.LastIndexOf(\) + 1); string type = fullname.Substring(fullname.LastIndexOf(\) + 1); if (type == \ || type == \ || type == \||type==\) {
FileUpload1.PostedFile.SaveAs(Server.MapPath(\) + \+Session[\]+ filename); Image1.ImageUrl = \ + Session[\] + filename; string url = \ + Session[\] + filename; SqlCommand com = new SqlCommand(%usertable set head='\ +url+\where login= '\ + Session[\] + \, con); com.ExecuteNonQuery(); } else {
Response.Write(\ÄãÑ¡ÔñµÄͼƬ¸ñʽ²»ÕýÈ·£¡\\\); }
}
4.6 ¸öÈËÏà²á(index3.aspx£©
4.6.1 ¹¦Äܼò½é
¸öÈËÏà²áÒ³Óû§¿ÉÒÔÉÏ´«×Ô¼ºÏ²»¶µÄͼƬµ½ÍøÒ³ÉÏÀ´£¬²¢¶ÔͼƬ½øÐйÜÀíÖ´ÐÐɾ³ý²Ù
×÷¡£Í¼Æ¬Â·¾¶µÄ»ñȡʹÓÃFileUpload¿Ø¼þÀ´»ñÈ¡£¬Í¼Æ¬µÄÏÔʾʹÓÃDataList¿Ø¼þÀ´ÏÔʾ£¬Í¼Æ¬ÉÏ´«ºó¶¼ÊDZ£´æµ½Îļþ¼Ð¡°Photo¡± ÀïÈ¥µÄÈ»ºó½«Í¼Æ¬µÄÏÔʾ·¾¶±£´æÊý¾Ý¿â£¬ÕâÀï¶ÔͼƬִÐÐɾ³ý²Ù×÷Ö÷Òª¾ÍÊÇÒª¶ÔÎļþÖ´ÐÐɾ³ý²Ù×÷¡£Ò³ÃæÈçͼ4.6.1Ëùʾ
- 19 -
ͼ4.6.1
4.6.2 ºǫ́Ö÷Òª´úÂë
ͼƬµÄÉÏ´«ºÍÓû§Í·ÏñµÄÉÏ´«´úÂë»ù±¾Ò»Ñù²»ÔÚÁгö£¬¶øÍ¼Æ¬µÄÏÔʾʵÏÖÊÇͨ¹ýDataList¿Ø¼þ½¨Á¢Êý¾ÝÁ¬½ÓºóÔÚDataList¿Ø¼þÖÐÌí¼Ó\
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e) {
string phid = DataList1.DataKeys[e.Item.ItemIndex].ToString();//»ñȡҪɾ³ýͼƬid SqlConnection con = conn.createconnection(); con.Open();
SqlCommand cmd = new SqlCommand(\ + phid + \, con);
SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = cmd; DataSet dataset = new DataSet(); adapter.Fill(dataset); SqlDataReader dr;
dr = cmd.ExecuteReader(); if (dr.Read()) {
string path = dr[\].ToString();
string filename = path.Substring(path.LastIndexOf(\) + 1);//»ñÈ¡ÎļþÃû
System.IO.File.Delete(Server.MapPath(\) + \ + filename);//ɾ³ýÎļþ¼ÓÀïµÄͼƬ }
dr.Close();
SqlCommand com = new SqlCommand(\ + phid + \, con);//ɾ³ýÊý¾Ý¿âÀïµÄͼƬ·¾¶ com.ExecuteNonQuery(); con.Close();
Response.Write(\ͼƬÒÑɾ³ý£¡\\\); }
4.7 ¸öÈË×ÊÁÏ£¨index4.sapx£©
4.7.1 ¹¦Äܼò½é
´ËÒ³ÃæÖ÷Òª¹¦ÄÜÊǹÜÀíºÍÍêÉÆÓû§»ù±¾×ÊÁÏ£¬Óû§ÔÚ×¢²áʱ¿ÉÄÜÓÐЩ×ÊÁϲ»ÊÇÌîµÃ
ºÜÍêÕû»òÓû§×ÊÁÏ·¢Éú¸Ä±äʱÐèÒªÐ޸ġ£´ËÒ³Ãæ¾ÍÄÜΪÓû§Ìṩ×ÊÁϵÄÐ޸ĺÍÍêÉÆ¡£×ÊÁϵÄÏÔʾºÍÐ޸ͼÊÇÔÚͬһ¸öÒ³Ãæ£¬·Ö±ðʹÓÃÁËÁ½¸öÈÝÆ÷¿Ø¼þPanel°üº¬ÆðÀ´£¬µã»÷¸öÈË×ÊÁÏʱ½«°üº¬ÐÞ¸ÄÄÚÈݵÄPanelµÄVisibleÊôÐÔÉèÖÃΪ¡°false¡±£¬µã»÷ÐÞ¸Äʱ·´¹ýÀ´¼´¿É¡£Ò³ÃæÈçͼ4.7.1ºÍͼ4.7.2Ëùʾ
- 20 -
ͼ4.7.1
ͼ4.7.2
4.7.2 ºǫ́Ö÷Òª´úÂë
ÏÔʾ¸öÈË×ÊÁÏ´úÂëÇ°ÃæÒÑÁгö¹ýÕâÀï²»ÔÚÁгö£¬ÏÂÃæÖ÷ÒªÁгöµÄÊÇ×ÊÁϵÄÐ޸ĴúÂë ÈçÏ£º
protected void Button1_Click(object sender, EventArgs e)
{
string dd = (ddlxb.SelectedItem).ToString();//»ñÈ¡ddlxbÏÂÀÁбíÖеÄÖµ
string cc = (ddlbj.SelectedItem).ToString(); SqlConnection con = conn.createconnection(); con.Open();
SqlCommand MyCommand1 = new SqlCommand();
MyCommand1.CommandText = \ + textname.Text + \ + ddlsex.Text + \ + ddltime.Text + \ + dd + \ +cc +\'\ + Session[\] + \;
MyCommand1.Connection = con; MyCommand1.ExecuteNonQuery(); con.Close();
Response.Write(\Ð޸ijɹ¦~£¡\\\);
}
- 21 -
4.8 ¸öÈËÈÕÖ¾£¨index5.aspx£©
4.8.1 ¹¦ÄܼòÊö
±¾Ò³Ãæ·ÖΪдÈÕÖ¾ºÍÈÕÖ¾¹ÜÀíÁ½¸ö²¿·Ö£¬ÈÕÖ¾¹ÜÀíÓÖ·ÖΪÐÞ¸ÄÈÕÖ¾ºÍɾ³ýÈÕÖ¾Á½²¿
·Ö¡£Ð´ÈÕ־ΪÓû§ÌṩÁËÒ»¸öÀàËÆÓÚ¼Çʱ¾µÄÒ³Ãæ£¬Óû§¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄ°®ºÃÔÚÀïÃæÐ´ÈëһЩ¼Ç¼ÐÔµÄÎÄ×ÖºÍÖØÒª×ÊÁÏ¡£ÐÞ¸ÄÈÕÖ¾ºÍɾ³ýÈÕÖ¾·Ö±ðʹÓÃÁËÒ»¸ö GridViewÀ´ÏÔʾֻÊÇÉÔ½«ÓÃÀ´ÏÔʾÖ÷ÌâºÍÏÔʾÄÚÈݵÄÁ½ÁнøÐÐÁËÒ»µã¸ÄÔ죬ÔÚÁ½ÁÐÖзֱð¼ÓÈëÁËÒ»¸öµ¥ÐÐÏÔʾµÄTextBoxºÍÒ»¸ö¶àÐÐÏÔʾµÄTextBoxÀ´ÏÔʾÖ÷ÌâºÍÄÚÈÝ£¬ÆäʵÏÖ·½·¨ÊÇÔÚGridView¿Ø¼þµÄ
ͼ4.8.1
ͼ4.8.2
4.8.2 ºǫ́Ö÷Òª´úÂë
±¾Ò³Ãæºǫ́Ö÷Òª´úÂëÔÚÇ°Ãæ»ù±¾¶¼ÒѽéÉܹýÁËÒ»¸öÌí¼Ó´úÂëºÍÒ»¸öÐ޸ĴúÂ룬ÕâÀï²»ÔÚÖØ¸´Áгö¡£
4.9 °à¼¶³ÉÔ±£¨index8.aspx£©
4.9.1 ¹¦ÄܼòÊö
±¾Ò³·ÖΪ°à¼¶³ÉÔ±ºÍ¹ÜÀí°à¼¶³ÉÔ±Á½ÏÄÜ£¬°à¼¶³ÉÔ±Ö»ÓмÓÈëÁ˰༶»ò¹ÜÀíÔ±Óû§
- 22 -