Maticsoft.SQLServerDAL qq在哪里添加好友

【图文】U8二开基础培训_百度文库
两大类热门资源免费畅读
续费一年阅读会员,立省24元!
评价文档:
U8二开基础培训
上传于|0|0|文档简介
&&U8二次开发基础培训-VS.NET
大小:3.85MB
登录百度文库,专享文档复制特权,财富值每天免费拿!
你可能喜欢 上传我的文档
 下载
 收藏
该文档贡献者很忙,什么也没留下。
 下载此文档
正在努力加载中...
使用动软 net代码自动生成工具的步骤
下载积分:300
内容提示:使用动软 net代码自动生成工具的步骤
文档格式:PDF|
浏览次数:147|
上传日期: 18:56:32|
文档星级:
该用户还上传了这些文档
使用动软 net代码自动生成工具的步骤
官方公共微信.net - Reference Microsoft.SqlServer.Smo.dll - Stack Overflow
Insights on the world's developers
Demographics. Technologies. Salaries. Career satisfaction.
I need to use
class which is stored in Microsoft.SqlServer.Smo.dll I don't see this assembly in usual References dialog. I have found it at C:/Program Files/Microsoft SQL Server/100/SDK/Assemblies and try to reference from there but Visual Studio throws an error "A reference 'C:/Program Files/Microsoft SQL Server/100/SDK/Assemblies/Microsoft.SqlServer.Smo.dll' could not be added. Please make sure that file is accessible, and that it is a valid assembly or COM component". What am I doing wrong?
5,4142691188
C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies is the correct folder location (or C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies on 64-bit systems).
You need to add references to:
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.SqlEnum.dll
(These are the minimum files that are required to build an SMO application)
For SQL Server 2016, this location is C:\Program Files (x86)\Microsoft SQL Server\130\SDK\Assemblies (for the 64bit version).
The SQL Server Management Objects (SMO) are downloadable as part of the relevant
(check the smallprint as I don't believe these are redistributable?)
223k28355452
I know this is an old question, but I just ran into the same issue.
@Mitch_Wheat is correct that as a minimum you need references to the 4 SMO assemblies.
Trying to add all 4 at once, however, gave me the error you listed.
Adding the assemblies one at a time bypassed the error.
8,24244674
You can try this unofficial nuget package...
Install-Package Unofficial.Microsoft.SQLServer.SMO
2,43412557
You need to install following package to solve the problem , I have solved this problem twice with this package hope it may work for everyone too...
Microsoft SQL Server 2005 Management Objects Collection
The Management Objects Collection package includes several key elements of the SQL Server 2005 management API, including Analysis Management Objects (AMO), Replication Management Objects (RMO), and SQL Server Management Objects (SMO). Developers and DBAs can use these components to programmatically manage SQL Server 2005.
You can get from Feature Pack for Microsoft SQL Server 2005 - December 2008 from Microsoft site [/en-us/download/details.aspx?id=11988][1]
But the link location of download page changes every-time if you don't find resource you can download it from my blog too.
I have also provided some tips and resources about this in my blog if you want
For those who need the sql server 2014 version (version 120) you need to download and install the following packages from Microsoft:
SQLSysClrTypes (x64):
SharedManagementObjects(x64):
You can find all relevant info on Microsoft website on this page (as suggested correctly by @mitch-wheat ):
In the case that you want use Backup class add Microsoft.SqlServer.Management.SmoExtended to your project.
2,43762239
Try registering the DLL library by running this at the DOS prompt (I'm curious as to why it's not registered already. I tried using it on a Windows that had SQL2008 installed and didn't have your problem)
"c:\windows\system32\regsvr32.exe C:/Program Files/Microsoft SQL
Server/100/SDK/Assemblies/Microsoft.SqlServer.Smo.dll"
You need the quotation marks because of the spaces in the directory names.
If you're running a 64-bit Windows, regsvr32.exe will be in C:\windows\syswow64\
Best of luck. Let us know if this won't help..
1,91221016
Your Answer
Sign up or
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Post as a guest
By posting your answer, you agree to the
Not the answer you're looking for?
Browse other questions tagged
rev .25518
Stack Overflow works best with JavaScript enabled总浏览数:5246
总下载量:4
总成交量:1
OAS.BLL.dll[76KB]
OAS.BLL.pdb[203KB]
mon.dll[48KB]
mon.pdb[109KB]
OAS.DALFactory.dll[20KB]
OAS.DALFactory.pdb[25KB]
OAS.IDAL.dll[24KB]
OAS.IDAL.pdb[7KB]
OAS.Model.dll[32KB]
OAS.Model.pdb[135KB]
OpenSmtp.dll[44KB]
OAS.BLL.dll[68KB]
mon.dll[44KB]
OAS.DALFactory.dll[20KB]
OAS.IDAL.dll[20KB]
OAS.Model.dll[32KB]
OpenSmtp.dll[44KB]
BLL.csprojResolveAssemblyReference.cache[34KB]
DesignTimeResolveAssemblyReferencesInput.cache[5KB]
OAS.BLL.dll[76KB]
OAS.BLL.pdb[203KB]
BLL.csprojResolveAssemblyReference.cache[18KB]
DesignTimeResolveAssemblyReferencesInput.cache[6KB]
OAS.BLL.dll[68KB]
ResolveAssemblyReference.cache[52KB]
BLL.csproj.user[2KB]
COM.Excel.dll[15KB]
mon.dll[48KB]
mon.pdb[109KB]
OpenSmtp.dll[44KB]
OWC10Chart.dll[20KB]
COM.Excel.dll[15KB]
mon.dll[44KB]
OpenSmtp.dll[44KB]
OWC10Chart.dll[20KB]
vssver2.scc[190B]
Common.csprojResolveAssemblyReference.cache[24KB]
DesignTimeResolveAssemblyReferencesInput.cache[5KB]
mon.dll[48KB]
mon.pdb[109KB]
Common.csprojResolveAssemblyReference.cache[13KB]
DesignTimeResolveAssemblyReferencesInput.cache[6KB]
mon.dll[44KB]
ResolveAssemblyReference.cache[39KB]
Properties
Common.csproj.user[2KB]
OAS.suo[20KB]
vssver2.scc[507B]
DALFactory
MySql.Data.dll[360KB]
mon.dll[48KB]
mon.pdb[109KB]
OAS.DALFactory.dll[20KB]
OAS.DALFactory.pdb[25KB]
OAS.DBUtility.dll[64KB]
OAS.DBUtility.pdb[181KB]
OAS.IDAL.dll[24KB]
OAS.IDAL.pdb[7KB]
OAS.Model.dll[32KB]
OAS.Model.pdb[135KB]
OAS.OracleDAL.dll[24KB]
OAS.OracleDAL.pdb[29KB]
OpenSmtp.dll[44KB]
System.Data.SQLite.dll[828KB]
MySql.Data.dll[360KB]
mon.dll[44KB]
OAS.DALFactory.dll[20KB]
OAS.DBUtility.dll[56KB]
OAS.IDAL.dll[20KB]
OAS.Model.dll[32KB]
OAS.OracleDAL.dll[24KB]
OpenSmtp.dll[44KB]
System.Data.SQLite.dll[828KB]
DALFactory.csprojResolveAssemblyReference.cache[71KB]
DesignTimeResolveAssemblyReferencesInput.cache[5KB]
OAS.DALFactory.dll[20KB]
OAS.DALFactory.pdb[25KB]
DALFactory.csprojResolveAssemblyReference.cache[69KB]
DesignTimeResolveAssemblyReferencesInput.cache[6KB]
OAS.DALFactory.dll[20KB]
ResolveAssemblyReference.cache[118KB]
DALFactory.csproj.user[2KB]
MySql.Data.dll[360KB]
OAS.DBUtility.dll[64KB]
OAS.DBUtility.pdb[181KB]
System.Data.SQLite.DLL[828KB]
MySql.Data.dll[360KB]
OAS.DBUtility.dll[56KB]
System.Data.SQLite.DLL[828KB]
DBUtility.csprojResolveAssemblyReference.cache[23KB]
DesignTimeResolveAssemblyReferencesInput.cache[5KB]
OAS.DBUtility.dll[64KB]
OAS.DBUtility.pdb[181KB]
DBUtility.csprojResolveAssemblyReference.cache[22KB]
DesignTimeResolveAssemblyReferencesInput.cache[6KB]
OAS.DBUtility.dll[56KB]
ResolveAssemblyReference.cache[34KB]
DBUtility.csproj.user[478B]
OAS.suo[23KB]
db_OA.mdf[3MB]
db_OA_log.ldf[1MB]
OAS.IDAL.dll[24KB]
OAS.IDAL.pdb[7KB]
OAS.Model.dll[32KB]
OAS.Model.pdb[135KB]
OAS.IDAL.dll[20KB]
OAS.Model.dll[32KB]
DesignTimeResolveAssemblyReferencesInput.cache[5KB]
IDAL.csprojResolveAssemblyReference.cache[8KB]
OAS.IDAL.dll[24KB]
OAS.IDAL.pdb[7KB]
DesignTimeResolveAssemblyReferencesInput.cache[6KB]
IDAL.csprojResolveAssemblyReference.cache[6KB]
OAS.IDAL.dll[20KB]
ResolveAssemblyReference.cache[4KB]
IDAL.csproj.user[2KB]
COM.Excel.dll[15KB]
LTP.Accounts.dll[40KB]
LtpPageControl.dll[24KB]
Microsoft.mon.dll[148KB]
Microsoft.Practices.EnterpriseLibrary.Data.dll[80KB]
Microsoft.Web.UI.WebControls.dll[182KB]
MySql.Data.dll[360KB]
OpenSmtp.dll[44KB]
OWC10Chart.dll[20KB]
System.Data.SQLite.DLL[828KB]
System.Data.SQLite.lib[55KB]
OAS.Model.dll[32KB]
OAS.Model.pdb[135KB]
OAS.Model.dll[32KB]
DesignTimeResolveAssemblyReferencesInput.cache[5KB]
Model.csprojResolveAssemblyReference.cache[1KB]
OAS.Model.dll[32KB]
OAS.Model.pdb[135KB]
DesignTimeResolveAssemblyReferencesInput.cache[6KB]
Model.csprojResolveAssemblyReference.cache[1KB]
OAS.Model.dll[32KB]
Model.csproj.user[2KB]
MySql.Data.dll[360KB]
mon.dll[48KB]
mon.pdb[109KB]
OAS.DBUtility.dll[64KB]
OAS.DBUtility.pdb[181KB]
OAS.IDAL.dll[24KB]
OAS.IDAL.pdb[7KB]
OAS.Model.dll[32KB]
OAS.Model.pdb[135KB]
OAS.OracleDAL.dll[24KB]
OAS.OracleDAL.pdb[29KB]
OpenSmtp.dll[44KB]
System.Data.SQLite.dll[828KB]
MySql.Data.dll[360KB]
mon.dll[44KB]
OAS.DBUtility.dll[56KB]
OAS.IDAL.dll[20KB]
OAS.Model.dll[32KB]
OAS.OracleDAL.dll[24KB]
OpenSmtp.dll[44KB]
System.Data.SQLite.dll[828KB]
DesignTimeResolveAssemblyReferencesInput.cache[6KB]
OAS.OracleDAL.dll[24KB]
OAS.OracleDAL.pdb[29KB]
OracleDAL.csprojResolveAssemblyReference.cache[59KB]
DesignTimeResolveAssemblyReferencesInput.cache[6KB]
OAS.OracleDAL.dll[24KB]
OracleDAL.csprojResolveAssemblyReference.cache[56KB]
ResolveAssemblyReference.cache[94KB]
OracleDAL.csproj.user[2KB]
SQLServerDAL
MySql.Data.dll[360KB]
mon.dll[48KB]
mon.pdb[109KB]
OAS.DBUtility.dll[64KB]
OAS.DBUtility.pdb[181KB]
OAS.IDAL.dll[24KB]
OAS.IDAL.pdb[7KB]
OAS.Model.dll[32KB]
OAS.Model.pdb[135KB]
OAS.SQLServerDAL.dll[104KB]
OAS.SQLServerDAL.pdb[207KB]
OpenSmtp.dll[44KB]
System.Data.SQLite.dll[828KB]
MySql.Data.dll[360KB]
mon.dll[44KB]
OAS.DBUtility.dll[56KB]
OAS.IDAL.dll[20KB]
OAS.Model.dll[32KB]
OAS.SQLServerDAL.dll[96KB]
OpenSmtp.dll[44KB]
System.Data.SQLite.dll[828KB]
DesignTimeResolveAssemblyReferencesInput.cache[6KB]
OAS.SQLServerDAL.dll[104KB]
OAS.SQLServerDAL.pdb[207KB]
SQLServerDAL.csprojResolveAssemblyReference.cache[31KB]
DesignTimeResolveAssemblyReferencesInput.cache[6KB]
OAS.SQLServerDAL.dll[96KB]
SQLServerDAL.csprojResolveAssemblyReference.cache[56KB]
SQLServerDAL.csproj.user[2KB]
App_Themes
Control.skin[1KB]
Green2Theme
Control.skin[1KB]
GreenTheme
Control.skin[1KB]
PurpleTheme
Control.skin[1KB]
Control.skin[1KB]
Attendance
ManualSign
calendar.dll[5KB]
COM.Excel.dll[15KB]
LTP.Accounts.dll[40KB]
LtpPageControl.dll[24KB]
Microsoft.Web.UI.WebControls.dll[182KB]
MySql.Data.dll[360KB]
OAS.BLL.dll[76KB]
OAS.BLL.pdb[203KB]
mon.dll[48KB]
mon.pdb[109KB]
OAS.DALFactory.dll[20KB]
OAS.DALFactory.pdb[25KB]
OAS.DBUtility.dll[64KB]
OAS.DBUtility.pdb[181KB]
OAS.IDAL.dll[24KB]
OAS.IDAL.pdb[7KB]
OAS.Model.dll[32KB]
OAS.Model.pdb[135KB]
OAS.OracleDAL.dll[24KB]
OAS.OracleDAL.pdb[29KB]
OAS.SQLServerDAL.dll[104KB]
OAS.SQLServerDAL.pdb[207KB]
OAS.Web.dll[102KB]
OAS.Web.pdb[461KB]
OpenSmtp.dll[44KB]
OWC10Chart.dll[20KB]
System.Data.SQLite.dll[828KB]
Components
Copy of Images
14841.gif[5KB]
15388.gif[1KB]
26061.gif[5KB]
27262.gif[3KB]
28367.gif[5KB]
5893.gif[5KB]
6088.gif[2KB]
6217.gif[5KB]
6414.gif[2KB]
add_Schedule.gif[909B]
butClose.gif[1KB]
butOpen.gif[1KB]
code1.JPG[82KB]
code2.JPG[96KB]
leftbg.jpg[5KB]
loginbg.jpg[44KB]
loginmain.jpg[16KB]
login_1.gif[9KB]
login_1.jpg[7KB]
login_2.jpg[87KB]
login_3.jpg[17KB]
login_button.gif[1KB]
main_cen_bg.gif[168B]
nav_bj.gif[1KB]
new_005.jpg[847B]
new_006.jpg[502B]
new_007.jpg[836B]
new_008.jpg[416B]
new_009.jpg[402B]
new_010.jpg[608B]
new_011.jpg[365B]
new_012.jpg[612B]
new_019.jpg[709B]
new_020.jpg[451B]
new_021.jpg[714B]
new_022.jpg[365B]
new_023.jpg[402B]
new_024.jpg[611B]
new_025.jpg[411B]
new_026.jpg[612B]
new_027.jpg[319B]
sts.gif[330B]
test.jpg[23KB]
top.jpg[14KB]
asax.gif[591B]
ascx.gif[356B]
ashx.gif[574B]
asmx.gif[578B]
asp.gif[386B]
aspx.gif[608B]
bmp.gif[375B]
config.gif[169B]
CS.gif[378B]
css.gif[389B]
db.gif[628B]
dll.gif[628B]
doc.gif[633B]
exe.gif[115B]
folder.gif[349B]
from.gif[4KB]
gif.gif[375B]
htm.gif[627B]
html.gif[627B]
jpeg.gif[375B]
jpg.gif[375B]
js.gif[389B]
master.gif[608B]
mdb.gif[634B]
other.gif[172B]
pdf.gif[364B]
php.gif[262B]
pic.gif[587B]
png.gif[375B]
ppt.gif[645B]
psd.gif[614B]
rar.gif[596B]
resx.gif[164B]
sitemap.gif[396B]
sql.gif[588B]
swf.gif[356B]
txt.gif[361B]
xls.gif[633B]
xml.gif[386B]
xsl.gif[600B]
zip.gif[596B]
copy.gif[1KB]
cut.gif[136B]
delete.gif[276B]
edit.gif[236B]
file_new.gif[631B]
folder_new.gif[590B]
paste.gif[628B]
refresh.gif[1KB]
rename.gif[334B]
up.gif[209B]
14841.gif[5KB]
15388.gif[1KB]
26061.gif[5KB]
27262.gif[3KB]
28367.gif[5KB]
5893.gif[5KB]
6088.gif[2KB]
6217.gif[5KB]
6414.gif[2KB]
add_Schedule.gif[909B]
butClose.gif[1KB]
butOpen.gif[1KB]
code1.JPG[82KB]
code2.JPG[96KB]
leftbg.jpg[5KB]
loginbg.jpg[44KB]
loginmain.jpg[28KB]
login_1.gif[9KB]
login_1.jpg[7KB]
login_2.jpg[87KB]
login_3.jpg[17KB]
login_button.gif[1KB]
logo.gif[10KB]
logo.jpg[50KB]
logotitle.gif[9KB]
main_cen_bg.gif[168B]
nav_bj.gif[1KB]
new_005.jpg[847B]
new_006.jpg[502B]
new_007.jpg[836B]
new_008.jpg[416B]
new_009.jpg[402B]
new_010.jpg[608B]
new_011.jpg[365B]
new_012.jpg[612B]
new_019.jpg[709B]
new_020.jpg[451B]
new_021.jpg[714B]
new_022.jpg[365B]
new_023.jpg[402B]
new_024.jpg[611B]
new_025.jpg[411B]
new_026.jpg[612B]
new_027.jpg[319B]
note.jpg[11KB]
sts.gif[330B]
test.jpg[23KB]
top.jpg[15KB]
x.jpg[3KB]
My97DatePicker
img.gif[1KB]
bg.jpg[307B]
img.gif[1KB]
datePicker.gif[1KB]
img.gif[1KB]
bg.jpg[307B]
img.gif[1KB]
datePicker.gif[1KB]
DesignTimeResolveAssemblyReferencesInput.cache[34KB]
OAS.Web.Admin.Main.resources[608B]
OAS.Web.Admin.Spliter.resources[180B]
OAS.Web.Admin.Top.resources[608B]
OAS.Web.Controls.CheckRight.resources[180B]
OAS.Web.Controls.CopyRight1.resources[180B]
OAS.Web.dll[102KB]
OAS.Web.Global.resources[180B]
OAS.Web.pdb[461KB]
Web.csproj.GenerateResource.Cache[1KB]
Web.csprojResolveAssemblyReference.cache[135KB]
DesignTimeResolveAssemblyReferencesInput.cache[34KB]
GenerateResource.read.1.tlog[2KB]
GenerateResource.write.1.tlog[6KB]
OAS.Web.Admin.Main.resources[608B]
OAS.Web.Admin.Spliter.resources[180B]
OAS.Web.Admin.Top.resources[608B]
OAS.Web.Controls.CheckRight.resources[180B]
OAS.Web.Controls.CopyRight1.resources[180B]
OAS.Web.dll[96KB]
OAS.Web.Global.resources[180B]
OAS.Web.pdb[361KB]
ResolveAssemblyReference.cache[221KB]
Web.csproj.GenerateResource.Cache[1KB]
Web.csprojResolveAssemblyReference.cache[194KB]
OfficialDoc
Department
PManagerment
Properties
DepartSchedule
MySchedule
OAS概要设计说明书.doc[607KB]
简历.doc[1.12MB]
Department
开题报告模板(张原川).doc[760KB]
webctrl_client
folder.gif[914B]
folderopen.gif[917B]
html.gif[982B]
root.gif[1016B]
TreeImages
F.gif[847B]
Fminus.gif[883B]
Fplus.gif[890B]
I.gif[850B]
L.gif[850B]
Lminus.gif[884B]
Lplus.gif[890B]
minus.gif[878B]
plus.gif[884B]
r.gif[844B]
Rminus.gif[881B]
Rplus.gif[888B]
T.gif[854B]
Tminus.gif[887B]
Tplus.gif[892B]
white.gif[837B]
f.gif[851B]
fminus.gif[883B]
fplus.gif[887B]
i.gif[114B]
L.gif[851B]
Lminus.gif[886B]
Lplus.gif[889B]
minus.gif[879B]
plus.gif[882B]
r.gif[844B]
Rminus.gif[881B]
Rplus.gif[884B]
T.gif[856B]
Tminus.gif[889B]
Tplus.gif[892B]
white.gif[837B]
MultiPage.htc[3KB]
TabStrip.htc[24KB]
toolbar.htc[48KB]
treeview.htc[71KB]
MasterPage1.Master[651B]
Web.csproj.user[1KB]
from.gif[4KB]
OAS.sln[9KB]
OAS.suo[336KB]
OAS.v11.suo[431KB]
最新Asp.Net源码下载.url[125B]
源码介绍
源码类别:【商务办公】
源码类型:B/S
适合人群:
授权类型:商业版
开发语言:C#
数据库:SQL2008
框架版本:1.00
源码大小:12.2MB
相关网址:
源码指数:
上架时间: 09:15:55
AL中小型通用办公OA系统源码浏览器兼容:IE6及以上/FF技术特点:多层架构 抽象工厂模式&&& 通过工厂模式来实现支持不同数据库类型。根据实际情况从解决方案中移除不需要的DAL.通过修改Web.config 的&add key=&DAL& value=&Maticsoft.SQLServerDAL& /&实现加载不同的DAL程序集.OracleDAL,SQLServerDAL功能描述:&个人信息管理&修改个人资料、查看个人信息&个人通讯管理&添加通讯录&人事管理&机构管理:增设机构,删除机构,修改机构。&部门管理:增设部门,删除部门,修改部门。&员工管理:添加员工,删除员工,修改员工。&日程管理&我的日程:创建当天日程,删除和修改当天日程。&部门日程:创建部门日程,删除和修改部门日程。&我的便签:创建便签,删除和修改便签。&文档管理&个人文档管理:新建、上传、删除、修改文件及文件夹等操作。&部门文件管理:部门文件夹供以该部门以下的员工公用。&消息传递&发送消息、收件箱、发件箱&公文流转&提交公文、浏览公文&系统管理&角色管理:增加角色、删除角色、修改角色、查看角色。&登陆日志:日志查看、删除&考勤管理&考勤时间设置、考勤统计、考勤打卡注意事项:&用户名密码均为:51aspx&开发环境为Visual Studio 2010,数据库为SQL Server 2008,数据库文件在DB_51aspx文件夹中附加就行。&
责任编辑:WALL·E
举报源码
购买记录
源码评论
请输入验证码
评论列表
暂无评论 &
活跃于:&&&03-09 02:56:47
通过率:&&&5 / 10 = 50%
源码名称:
AL中小型通用办公OA系统源码
源码名称:
AL中小型通用办公OA系统源码
举报理由:
功能不完整
程序不开源
举报说明:
联系方式:
联系电话:
北京市海淀区中关村鼎好大厦A座二层 邮编:100080
Floor 2nd,Dinghao Building,Zhongguancun,Beijing,China,100080
由 && 提供运营服务,
由 & 提供技术保障
使用需知
商家需知
用户需知
快捷通道}

我要回帖

更多关于 qq在哪里添加好友 的文章

更多推荐

版权声明:文章内容来源于网络,版权归原作者所有,如有侵权请点击这里与我们联系,我们将及时删除。

点击添加站长微信