string source=this.FileUpload1.PostedFile.FileName;
string getextend = System.IO.Path.GetExtension(source);//得到
if (source == String.Empty || getextend != ".xls")
{
Response.Write("<script>alert('')</script>");
}
else
{
string strconn = "provider=microsoft.jet.oledb.4.0;data source=" + source + ";Extended Properties=EXCEL 8.0";
string str_select = "select * from [Sheet1$]";
OleDbConnection con = new OleDbConnection(strconn);
OleDbDataAdapter sda = new OleDbDataAdapter(str_select, con);
DataSet ds = new DataSet();
sda.Fill(ds, "view");
this.gvshow.DataSource = ds.Tables[0].DefaultView;
this.gvshow.DataBind();
int count=ds.Tables[0].Rows.Count;
if (count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("卡号");
dt.Columns.Add("密码");
dt = ds.Tables[0];
DataRow[] rows = dt.Select();
string sql="";
foreach(DataRow dr in rows)
{
string pid = dr[0].ToString();
string pwd=dr[1].ToString();
sql+="insert into card values('"+pid+"','"+pwd+"');";
}
SqlConnection con2 = new SqlConnection("server=tamonga;database=test;uid=sa;pwd=");
con2.Open();
SqlCommand cmd = new SqlCommand(sql, con2);
int counts = cmd.ExecuteNonQuery();
Response.Write("<scritp>alert('成功插入"+counts.ToString()+"')</script>");
}
}