¶àýÌå±ÏÒµ¼ÍÄî²á±¨¸æ ÏÂÔØ±¾ÎÄ

}

ÒÔÏÂ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¿Ø¼þÖÐÌí¼Ó\\Ä£°å£¬ÔÚÄ£°åÖÐÌí¼ÓÈçÏ´úÂë\ID=\\¼´¿ÉÏÔʾͼƬ¡£ÏÂÃæÖ÷ÒªÁгöͼƬµÄɾ³ý´úÂë ÈçÏ£º

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¿Ø¼þµÄÏîÖÐÌí¼ÓÈçÏ´úÂë È磺\ID=\plate> \ɾ³ýÈÕÖ¾ÊÇÆôÓÃÁËGridView¿Ø¼þ×Ô´øµÄɾ³ý¹¦ÄÜ£¬¶øÐÞ¸ÃÈÕÖ¾ÊÇÔÚGridView¿Ø¼þÖÐÌí¼ÓÁËÁÐ,µã»÷±à¼­°´Å¥Ê±»á´ø×ŸÃÁеÄIDתµ½index5lk.aspxÀ´ÊµÏÖÐ޸ŦÄÜ¡£Ò³ÃæÈçͼ4.8.1ºÍͼ4.8.2Ëùʾ

ͼ4.8.1

ͼ4.8.2

4.8.2 ºǫ́Ö÷Òª´úÂë

±¾Ò³Ãæºǫ́Ö÷Òª´úÂëÔÚÇ°Ãæ»ù±¾¶¼ÒѽéÉܹýÁËÒ»¸öÌí¼Ó´úÂëºÍÒ»¸öÐ޸ĴúÂ룬ÕâÀï²»ÔÚÖØ¸´Áгö¡£

4.9 °à¼¶³ÉÔ±£¨index8.aspx£©

4.9.1 ¹¦ÄܼòÊö

±¾Ò³·ÖΪ°à¼¶³ÉÔ±ºÍ¹ÜÀí°à¼¶³ÉÔ±Á½ÏÄÜ£¬°à¼¶³ÉÔ±Ö»ÓмÓÈëÁ˰༶»ò¹ÜÀíÔ±Óû§

- 22 -