如果我要允许多种后缀名文件上传该如何修改以下sql语句

[zy639150]

string postfileName = coursename + "_" + time + ".doc";

[happy664618843]

string filename=Fileupload1.PostedFile.FileName;
FileInfo files=new FileInfo(filename);
bool result=false;
string fileEx=files.Extension;
if(fileEx=="jpg"||fileEx="rar"||fileEx=="png"||fileEx="bmp"||fileEx=="doc")
{
result=true;
string serverpath=Server.Mappath("Files/")+filename;
FileUpload1.PostedFile.SaveAs(serverpath);
}
else
{
result=false;
}

[赤色火焰]

这是SQL语句?????

这好像是C#的语句吧,你可以先获取上传文件的扩展名
using System.IO;
string ext = Path.GetExtension(文件路径);
string postfileName = cousename + "_" + ext;

[zy639150]

是这样的，我要允许.rar,.txt,.doc,.xls,.mdb等文件上传，如果在原函数中修改怎么改？函数如下：
public void UploadFile(string time)
{
string coursename = bm.ReturnCourseName(Request.QueryString["courseid"].ToString());
//string postfileName = FUL.PostedFile.FileName.Substring(FUL.PostedFile.FileName.LastIndexOf("\\"), FUL.PostedFile.FileName.Length - FUL.PostedFile.FileName.LastIndexOf("\\"));
string postfileName = coursename + "_" + time + ".doc";
string path = Server.MapPath(BusyworkManage.Path + Request.Cookies["TeacherID"].Value.ToString() + BusyworkManage.TopicPath + coursename + "/" + postfileName);
string fileExtension = System.IO.Path.GetExtension(FUL.PostedFile.FileName).ToLower();
bool result = bm.CheckFileExtension(fileExtension);
if(result==true)
{
FUL.PostedFile.SaveAs(path);
Response.Write("<Script language='JavaScript'>alert('" + "添加成功！" + "');</Script>");
}
else
{
Response.Write("<Script language='JavaScript'>alert('" + "格式不正确！" + "');</Script>");
}

[赤色火焰]

public void UploadFile(string time)
{
string coursename = bm.ReturnCourseName(Request.QueryString["courseid"].ToString());
//string postfileName = FUL.PostedFile.FileName.Substring(FUL.PostedFile.FileName.LastIndexOf("\\"), FUL.PostedFile.FileName.Length - FUL.PostedFile.FileName.LastIndexOf("\\"));
string fileExtension = System.IO.Path.GetExtension(FUL.PostedFile.FileName).ToLower();
string postfileName = coursename + "_" + time + fileExtension;
string path = Server.MapPath(BusyworkManage.Path + Request.Cookies["TeacherID"].Value.ToString() + BusyworkManage.TopicPath + coursename + "/" + postfileName);
bool result = bm.CheckFileExtension(fileExtension);
if(result==true)
{
FUL.PostedFile.SaveAs(path);
Response.Write(" <Script language='JavaScript'>alert('" + "添加成功！" + "'); </Script>");
}
else
{
Response.Write(" <Script language='JavaScript'>alert('" + "格式不正确！" + "'); </Script>");
}

[zy639150]

那CheckFileExtension怎么改？
//检查上传作业的格式
public bool CheckFileExtension(string extensionName)
{
bool result = false;
if(extensionName==".doc")
{
result = true;
}
return result;
}
我把它改成：
//检查上传作业的格式
public bool CheckFileExtension(string extensionName)
{
bool result = false;
if(extensionName==".doc"||".rar"||".xls"||"mdb"||"txt")
{
result = true;
}
return result;
}
运行错误说：运算符“||”无法应用于“bool”和“string”类型的操作数

[zy639150]

好像可以了，谢谢