看见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();
}