SqlConnection Connection = con();
string sql = "select * from t_applySubject where t_applyType='000003'";(根据要求可以更改sql语句)
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(sql, Connection);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
if (dt != null)
{ foreach (DataRow dr in dt.Rows)
{ string str3 = Server.MapPath("~/files");
String sourcePath = str3+"\\keti\\" + dr["t_filePath"].ToString();(需要导出的文件的路径)
String targetPath = "f:\\www\\" + dr["t_applyName"].ToString() + dr["t_oldFileName"].ToString();(需要导入到的文件夹的路径)
bool isrewrite = true; // true=覆盖已存在的同名文件,false则反之
System.IO.File.Copy(sourcePath, targetPath, isrewrite);
}
Response.Write("<script>alert('导出成功')</script>");