04 2012 档案

一句sql删除数据库中的所有表
摘要：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 阅读(133) 评论(0) 推荐(0)
从Excel中读取数据
摘要：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 阅读(143) 评论(0) 推荐(0)