aspmssql源码(asp源码之家)
本文目录一览:
- 1、ASP+MSSQL2005网站源代码如何改成PHP+MYSQL程序,具体操作是怎样的,请高手指点,在线等
- 2、将EXCEL里的数据(规定好格式)导入到MSSQL数据库的ASP源码?
- 3、求asp+sql地方门户网站源码。数据库一定是MSSQL
- 4、ASP环境/SQLServer的源码要怎么样从本地运行
- 5、我下了一个源码,是ASP+MSSQL的,到底要怎样本地测试呢和修改主页呢
ASP+MSSQL2005网站源代码如何改成PHP+MYSQL程序,具体操作是怎样的,请高手指点,在线等
asp和php是两种不同的编程语言,asp没有办法改成php的,如果是mssql数据可以导入mysql里面
将EXCEL里的数据(规定好格式)导入到MSSQL数据库的ASP源码?
if (filGzdr.FileName == "") { lblMsg.Text = "请选择要上传的文件"; return; } string ext = Path.GetExtension(filGzdr.FileName); if (ext != ".xls") { lblMsg.Text = "上传文件必须是.xls的格式"; return; } //string filename = DateTime.Now.ToShortDateString().Replace("-", "") + DateTime.Now.Millisecond.ToString() + ext; filGzdr.SaveAs(Server.MapPath("") + @"\payFile\" + filGzdr.FileName); string Image = Server.MapPath("") + @"\payFile\" + filGzdr.FileName; string strname = filGzdr.FileName; string[] str = filGzdr.FileName.Split('.'); zsDr.Open("insert into pay(FNO,FNAME,FCODE,FBUMEN,FCLASS,jcgz,zwgz,jbgz,glgz,lbt,jbt,gajc,jxjt,gzjt,shjt,dzf,yltf,gstf,bfje,cs,gwjt,shbt,yfgz,hk,fz,sf,df,qjlj,gjj,sfjs,ylbx,sfje) select FNO as FNO,FNAME as FNAME,FCODE as FCODE,FBUMEN as FBUMEN,FCLASS as FCLASS,F01 as jcgz,F02 as zwgz,F03 as jbgz ,F04 as glgz ,F05 as lbt ,F06 as jbt,F07 as gajc ,F08 as jxjt,F09 as gzjt,F10 as shjt,F11 as dzf,F13 AS YLTF,F14 as gstf,F15 as bFJE, F16 AS CS,F21 AS GWJT,F22 AS SHBT,F27 AS YFGZ,F28 HK,F31 AS FZ,F32 AS SF,F33 AS DF,F35 AS QJLJ,F36 AS GJJ,F40 AS SFJS,F42 AS YLBX,F45 AS SFJE from openrowset( 'Microsoft.Jet.OLEDB.4.0', 'EXCEL 5.0;HDR=YES;DATABASE=" + Image + "', [" + str[0] + "$])"); zsDr.Close(); File.Delete(Server.MapPath("") + @"\payFile\" + filGzdr.FileName); lblMsg.Text = "导入成功"; 上面那个判断是获得盘符
麻烦采纳,谢谢!
求asp+sql地方门户网站源码。数据库一定是MSSQL
推荐你到易扑源码频道去下载,那里的各类源码很多,
界面设计精美,功能齐全,而且大部分是原创,免费分
享,有什么问题还可以到圈子去提问,有编程高手为你
解决问题
ASP环境/SQLServer的源码要怎么样从本地运行
装好IIS,,,
装好MS SQL
把你的源码放到IIS设置好的根目录,把你的数据库导入到MSSQL,
我下了一个源码,是ASP+MSSQL的,到底要怎样本地测试呢和修改主页呢
从网上下一个IIS,安装之后进入控制面板里的管理工具,然后里边有个“Internet信息服务”,进去之后建立一个新的站点,制定主目录就可以了。配置不复杂,一步步来就行了。测试地址是127.0.0.1或者是localhost