上传文件没问题就是把当前文件的名字,类型,大小插入数据库总失败!是什么原因!
protected void btnup_Click(object sender, EventArgs e)
{
string FullFileName = this.FileUpload1.PostedFile.FileName;
string FileName = FullFileName.Substring(FullFileName.LastIndexOf("\\") + 1);
this.FileUpload1.PostedFile.SaveAs(Server.MapPath("Files") + "\\" + FileName);
string type = FileUpload1.PostedFile.ContentType;
int size = FileUpload1.PostedFile.ContentLength;
SqlConnection con = DB.CreatCon();
con.Open();
SqlCommand cmd = new SqlCommand("insert into file_up(file_name,file_size,file_type) values('@file_name','@file_size','@file_type')",con);
cmd.Parameters.Add("@file_name", SqlDbType.VarChar, 50).Value = FileName;
cmd.Parameters.Add("@file_size", SqlDbType.Int ).Value = size;
cmd.Parameters.Add("@file_type", SqlDbType.VarChar, 50).Value = type;
try
{
cmd.ExecuteNonQuery();
Response.Write("<script>alert('上传成功')</script>");
}
catch
{
Response.Write("<script>alert('上传失败')</script>");
}
con.Close();
}
protected void btnup_Click(object sender, EventArgs e)
{
string FullFileName = this.FileUpload1.PostedFile.FileName;
string FileName = FullFileName.Substring(FullFileName.LastIndexOf("\\") + 1);
this.FileUpload1.PostedFile.SaveAs(Server.MapPath("Files") + "\\" + FileName);
string type = FileUpload1.PostedFile.ContentType;
int size = FileUpload1.PostedFile.ContentLength;
SqlConnection con = DB.CreatCon();
con.Open();
SqlCommand cmd = new SqlCommand("insert into file_up(file_name,file_size,file_type) values('@file_name','@file_size','@file_type')",con);
cmd.Parameters.Add("@file_name", SqlDbType.VarChar, 50).Value = FileName;
cmd.Parameters.Add("@file_size", SqlDbType.Int ).Value = size;
cmd.Parameters.Add("@file_type", SqlDbType.VarChar, 50).Value = type;
try
{
cmd.ExecuteNonQuery();
Response.Write("<script>alert('上传成功')</script>");
}
catch
{
Response.Write("<script>alert('上传失败')</script>");
}
con.Close();
}
错误的行数显示的是 cmd.ExecuteNonQuery(); 这行
这个错了
应该写成 cmd.Parameters.Add("@file_size", SqlDbType.Int ).Value =convent.toInt32(size)
这句得到的值是什么
insert into file_up(file_name,file_size,file_type) values('@file_name','@file_size','@file_type')
应该是
insert into file_up(file_name,file_size,file_type) values(@file_name,@file_size,@file_type)
@file_name已经是string,再加''肯定报错了
int.parm(***)