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)
阅读全文
摘要: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
阅读全文