从客户端导入数据文件,将数据文件保存到服务器端.然后从服务器端读取其数据交服务器处理。最后删除数据文件,释放磁盘空间。
private void Button12_Click(object sender, System.EventArgs e)
{
if((FileUp.PostedFile != null) && FileUp.PostedFile.ContentLength > 0)
{
if(FileUp.PostedFile.FileName.Substring(FileUp.PostedFile.FileName.LastIndexOf(".")).ToString()== ".txt")
{
this.ListBox1.SelectionMode = System.Web.UI.WebControls.ListSelectionMode.Multiple;
this.ListBox1.DataSource = null;
try
{
string fn = System.IO.Path.GetFileName(FileUp.PostedFile.FileName);
string dr = Server.MapPath("UploadFiles");
if(!Directory.Exists(dr))
{
Directory.CreateDirectory(Server.MapPath("UploadFiles"));
}
string saveLocation = Server.MapPath("UploadFiles") + "//" + fn;
if(File.Exists(saveLocation))
{
File.Delete(saveLocation);
}
try
{
FileUp.PostedFile.SaveAs(saveLocation);
}
catch ( Exception ex )
{
Response.Write("<script language='javascript'>alert('保存文件时错误信息:'+ '"+ex.ToString()+"');history.back(-2)</script>");
Response.End();
}
FileStream fs = new FileStream(saveLocation,FileMode.Open);
using(TextReader sr = new StreamReader(fs,System.Text.Encoding.GetEncoding("gb2312")))
{
String line;
SqlConnection dbConn = new SqlConnection(strConn);
try
{
dbConn.Open();
while ((line = sr.ReadLine()) != null)
{
if(line.Length == 11)
{
this.ListBox1.Items.Add(line);
MultDelDesign(line.ToString(),dbConn);
}
}
}
catch(Exception ex)
{
Response.Write("<script language='javascript'>alert('错误信息:'+ '"+ex.ToString()+"');history.back(-1)</script>");
Response.End();
}
finally
{
sr.Close();
dbConn.Close();
}
}
fs.Close();
if(File.Exists(saveLocation))
{
File.Delete(saveLocation);
}
}
catch(Exception ex)
{
Response.Write("<script language='javascript'>alert('错误信息:'+ '"+ex.ToString()+"');history.back(-1)</script>");
Response.End();
}
}
else
{
Response.Write("<script language='javascript'>alert('请选择要上传的文本文件!');history.back(-1)</script>");
Response.End();
}
}
else
{
Response.Write("<script language='javascript'>alert('请导入号码文件,文件格式是文本文件!');history.back(-1)</script>");
Response.End();
}
}