04 2012 档案

摘要:declare @sql varchar(8000)select @sql=isnull(@sql+' drop table ','')+'['+name+']'from (select name from sysobjects where xtype='u')texec('drop table '+ @sql) 阅读全文
posted @ 2012-04-28 17:51 challengesoflife 阅读(127) 评论(0) 推荐(0) 编辑
摘要:string xlsPath = FileUpload1.PostedFile.FileName; string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\";" + "data source=" + xlsPath; OleDbConnection cnnxls = new OleDbConnection(connStr); OleDbDataAdapter myDa 阅读全文
posted @ 2012-04-28 13:49 challengesoflife 阅读(138) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示