using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.ComponentModel;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
Boolean fileOK = false;
String path = Server.MapPath("uploadfile/");
if (FileUpload1.HasFile)
{
String fileExtension =
System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();
String[] allowedExtensions =
{ ".gif", ".png", ".jpeg", ".jpg" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
string thetime = DateTime.Now.ToString();
string aa = CleanString.cleantime(thetime.ToString());
string bb = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();
FileUpload1.PostedFile.SaveAs(path +aa+ bb);
Label1.Text = "上传成功!";
///listbox的值
filebox.Items.Add(aa+bb);
}
else
{
Label1.Text = "上传文件名不能为空!";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
filebox.Items.Remove(filebox.SelectedItem);
}
///循环插入数据库
protected void Button3_Click(object sender, EventArgs e)
{
for (int i = 0; i < filebox.Items.Count; i++)
{
SqlConnection myConnection = new SqlConnection(DataBaseDB.ConnectionString);
String cmdText = "insert into test001 (name1)values('" + filebox.Items[i].Text.ToString()+ "')";
SqlCommand myCommand = new SqlCommand(cmdText, myConnection);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
}