
2 ASPX运行需要你网站托管的服务器支持才行,目前一般网络空间只支持asp,支持aspx需要另外定制.并且原aspx是ACCESS的数据库,改成SQL,那你原来的代码都要重新编写,你又不懂aspx,那就太困难了.
给你个例子,自己看看,OKstring filename = FileUpload1.PostedFile.FileName.Substring(FileUpload1.PostedFile.FileName.LastIndexOf("\\"))
FileUpload1.PostedFile.SaveAs(Server.MapPath("fileupload\\") + filename)//上传文件
string conn = "Provider=Microsoft.Jet.OLEDB.4.0Data Source=" + Server.MapPath("fileupload\\") + filename + "Extended Properties=Excel 8.0"
string sqlin = "SELECT * FROM [Sheet2$]"
OleDbCommand olecommand = new OleDbCommand(sqlin, new OleDbConnection(conn))
OleDbDataAdapter adapterin = new OleDbDataAdapter(olecommand)
DataSet dsin = new DataSet()
adapterin.Fill(dsin)
DataTable dtin = dsin.Tables[0]//连接并读取excel数据
for (i = 3i <= totalrowi++)//将Excel文件中第一个工作表的数据导入到sql数据库scjd_youliaoxiaohaojihua表中
{
string sql = "insert into scjd_youliaoxiaohaojihua(yuexuhao,danwei,youpin,cheliangmingchengxinghao,zichanxingzhi,chepaihao,qiyou,chaiyou,beizhu) values('"
int j
sql += DropDownList1.SelectedValue.ToString() + DropDownList3.SelectedValue.ToString()
if (DropDownList1.SelectedValue.ToString() != DateTime.Now.Year.ToString() || int.Parse(DateTime.Now.Month.ToString()) != int.Parse(DropDownList3.SelectedValue.ToString()))
{
sql += "20"
}
else
{
if (int.Parse(DateTime.Now.Day.ToString()) <10)
sql += "0"
sql += DateTime.Now.Day.ToString()
}
if (i-3 + count <9)
sql += "00"
else if (i-3 + count <99)
sql += "0"
sql += (i -3 + 1 + count).ToString()
sql += "','"
for (j = 1j <8j++)
{//遍历Excel表中一行的所有列,除最后一列
sql += dtin.Rows[i][j].ToString().Trim()
sql += "','"
}
sql += dtin.Rows[i][8].ToString().Trim()
sql += "')"
try
{
DoSql(sql)
}
catch (Exception eeeeeee)
{
Response.Write("<script>alert('数据导入错误,请检查Excel文件')</script>")
return
}
}
FileInfo file = new FileInfo(Server.MapPath("fileupload/") + filename)
if (file.Exists)
{//删除文件
file.Delete()
}
protected void DoSql(string sql)//执行sql语句的函数
{
SqlConnection conn = new SqlConnection()//创建连接对象
conn.ConnectionString = ConfigurationManager.AppSettings["conn"].ToString()//给连接字符串赋值
conn.Open()//打开数据库
SqlCommand cmd = new SqlCommand(sql, conn)
cmd.ExecuteNonQuery()//
conn.Close()//关闭数据库
}
JS获得的值 var name=document.getElenmentById("username").value用url 提交到后台 脚本 winodw.open('addname.php?username='+name)
后台获取前台提交的数据后用mysql命令写入数据库
<?php $username= $_GET['username']$link=mysql_connect('127.0.0.1','root','******') or die("connection error".mysql_error()) $flag=mysql_select_db("testdb",$link) mysql_query("set names "."utf8") mysql_query('insert into user ( username) value ('.$username.')')?>
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)