protected void fileUp_Click(object sender,EventArgs e)
{
if(FileUpload1.FileName==string.Empty)
{
Response.Write("<script>altert(‘請選擇要上傳的文件')</script>");
return;
}
string mailto:connstr=@%22Data Source=69F638102711447\SQL2008;Initial Catalog=VarFile;Integrated Security=Ture"; //數(shù)據(jù)庫連接字符串
string the Selected=FileUpload1.FileName; //獲取上傳文件的后綴名
string extension=theSelected.Substring(theSelected.LastIndexOf(".")).ToLower();
if(CheckFileType(extension)) //如果有指定的文件類型
{

string contentType=GetContentType(extension);
string sqlstr="insert into FileInOut values(@FileType,@FileCount)"; //上傳文件的SQL語句
string sqlstrclear="truncate table FileInOut"; //清空數(shù)據(jù)庫SQL語句
SqlConnection con=new SqlConnection(connstr); //實例化數(shù)據(jù)庫連接對象
SqlCommand cmd=new SqlCommand(sqlstr,con); //實例化上傳文件SQL命令
SqlCommand cmdclear=new SqlCommand(sqlstrclear,con); //實例化清空數(shù)據(jù)庫SQL命令
//定義問價類型參數(shù)
cmd.Parameters.Add(new SqlParameter("@FileType”,SlqDbType.NvarChar,30))；
cmd.Parameters["@FileType"].Value=contentType; //定義文件內容參數(shù)
cmd.Parameters.Add(new SqlParameter("@FileCount",SqlDbType.NVarChar,30)); //將文件轉化為字節(jié)數(shù)組作為@FileCount的值
cmd.Parameters["@FileCount"].Value=FileUpload1.FileBytes;
con.Open();
cmdclear.ExecuteNonQuery(); //執(zhí)行清空數(shù)據(jù)庫命令
cmd.ExecuteNonQuery(); //執(zhí)行上傳文件命令
}
}

public static bool CheckFileType(string type)
{
StringDictionary sd=new StringDictionary(); //實例化集合StringDictionary類
sd.Add(".doc","application/msword");
sd.Add(".ppt","application/vnd.ms-powerpoint");
sd.Add(".xsl","application/vnd.ms-excel");
sd.Add(".rtf","application/msword");
sd.Add(".html","text/html");
sd.Add(".htm","text/html");
sd.Add(".txt","text/plain");
sd.Add(".pdf","application/pdf");
return sd.ContainsKey(type); //確定StringDictionary是否包含特定鍵
}

public static string GetContentType(string extension) //獲取輸出文件方式
{StringDictionary sd=new StringDictionary();
sd.Add(".doc","application/msword");
sd.Add(".ppt","application/vnd.ms-powerpoint");
sd.Add(".xsl","application/vnd.ms-excel");
sd.Add(".rtf","application/msword");
sd.Add(".html","text/html");
sd.Add(".htm","text/html");
sd.Add(".txt","text/plain");
sd.Add(".pdf","application/pdf");
return sd[extension]; //返回對應鍵的值
}