简单的图片上传程序

看见csdn上面有人问，随手翻出了自己以前写的程序，相当粗糙，呵呵

  private void Button1_Click(object sender, System.EventArgs e)
  {
   if (myFile.Value=="")
   {
    Page.RegisterStartupScript("","<script language='javascript'>alert('请选择一个要上传的相片！');</script>");
    return;
   }

//   this.lMsg.Text=myFile.PostedFile.ContentLength.ToString();

//   if (myFile.PostedFile.ContentLength>1024*1024)
//   {
//    this.lMsg.Text="该图片体积过大，为节省空间，请先将其进行压缩！";
//    return;
//   }
//
   SqlConnection conn = new SqlConnection(sql);
   string sql1 = "select count(eventID) from photo where eventID=@eventID";
   SqlCommand cmd1 = new SqlCommand(sql1,conn);
   cmd1.Parameters.Add("@eventID",SqlDbType.VarChar,22);
   cmd1.Parameters["@eventID"].Value=this.lbID.Text;
   conn.Open();
   int iLicense=Convert.ToInt32(cmd1.ExecuteScalar().ToString())+1;
   conn.Close();

   string nam = myFile.PostedFile.FileName;
   int i = nam.LastIndexOf(".");
   string newext = nam.Substring(i);
   DateTime now = DateTime.Now;
   string  newname = this.lbID.Text+"-"+iLicense.ToString()+"-"+now.ToShortDateString();
   string sql2 = "insert into photo(eventID,license,title,PDescribe,type,path)"+
       " values(@eventID,@license,@title,@PDescribe,@type,@path)";
   SqlCommand cmd2 = new SqlCommand(sql2,conn);
   cmd2.Parameters.Add("@eventID",SqlDbType.VarChar,22);
   cmd2.Parameters.Add("@license",SqlDbType.Int);
   cmd2.Parameters.Add("@title",SqlDbType.VarChar,40);
   cmd2.Parameters.Add("@PDescribe",SqlDbType.Text);
   cmd2.Parameters.Add("@type",SqlDbType.VarChar,20);
   cmd2.Parameters.Add("@path",SqlDbType.VarChar,60);
   cmd2.Parameters["@eventID"].Value=this.lbID.Text;
   cmd2.Parameters["@license"].Value=iLicense;
   cmd2.Parameters["@title"].Value=this.tbTitle.Text;
   cmd2.Parameters["@PDescribe"].Value=this.tbPDescribe.Text;
   cmd2.Parameters["@type"].Value=this.ddlType.SelectedValue;
   cmd2.Parameters["@path"].Value=newname+newext;
   conn.Open();
   try
   {
    myFile.PostedFile.SaveAs(Server.MapPath("photo\\" + newname + newext + ""));
    cmd2.ExecuteNonQuery();
    this.tbTitle.Text="";
    this.tbPDescribe.Text="";
    this.lMsg.Text="该相片上传成功！";
   }
   catch(Exception ex)
   {
    this.lMsg.Text=ex.Message;
   }
   conn.Close();
  }