不是偶在学习开始时也遇到过,你选择的数据库是localhost还是localhost/netSDK,然后选择使用安全验证,就行了,
解决方案 »
- 网站屏蔽鼠标右键问题,在线等,急!
- VS2008中加在JS文件,断点进不去怎么解决?提示当前不会命中断点,未加载该文档。
- "Sys"未定义,Ajax出错,紧急求助。
- 百度知道中提问框为空时的js效果页面和不为空时直接跳转页面?急....
- Web开发]ASP.NET+C#+VS2008+sql2005 开发在线订餐系统,大神们建议下网站可以有哪些模块呢。求给一个直接易懂的,直接搞定的
- 问大家一个问题。。为什么我装完VS2005为什么没有创建网站。。。我找不到。。(在线等)
- gridview 绑定中数据源中 添加删除的问题
- datagrid 中点 删除 按钮怎样弹出对话框
- 如何不用VS来编译后台文件
- 如何调用private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
- Crystal Report中的图例的内容如何自己定制??
- 如何在运行时获取DataGrid中某一绑定列对应的数据集中的字段名
问题终于解决了,看了tensun(好想学好.NET) ( )的文章后,解决了动态加载数据库显示在CrystalReportViewer1的问题:
Imports CrystalDecisions.Shared '负责解释TableLogOnInfo类
Imports CrystalDecisions.CrystalReports.Engine Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim logOnInfo As TableLogOnInfo = New TableLogOnInfo()
Dim oRpt As ReportDocument = New ReportDocument()
oRpt.Load("c:\\inetpub\\wwwroot\\hj\\CrystalReport1.rpt")
logOnInfo.ConnectionInfo.ServerName = "localhost"
logOnInfo.ConnectionInfo.DatabaseName = "pubs"
logOnInfo.ConnectionInfo.UserID = "sa"
logOnInfo.ConnectionInfo.Password = "jvhmr"
oRpt.Database.Tables(0).ApplyLogOnInfo(logOnInfo)
CrystalReportViewer1.ReportSource = oRpt
End Sub
但是又出现的新的问题,就是在把CrystalReport1中的数据库数据导出为excel或.....也显示
登陆失败,偶也使用的tensun(好想学好.NET) ( )的思路:
Imports CrystalDecisions.Shared '负责解释TableLogOnInfo类
Imports CrystalDecisions.CrystalReports.EnginePrivate Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim myrpt As CrystalReport1 = New CrystalReport1()
Dim logOnInfo As TableLogOnInfo = New TableLogOnInfo()
Dim oRpt As ReportDocument = New ReportDocument()
oRpt.Load("c:\\inetpub\\wwwroot\\hj\\CrystalReport1.rpt")
logOnInfo.ConnectionInfo.ServerName = "localhost"
logOnInfo.ConnectionInfo.DatabaseName = "pubs"
logOnInfo.ConnectionInfo.UserID = "sa"
logOnInfo.ConnectionInfo.Password = "jvhmr"
myrpt.Database.Tables(0).ApplyLogOnInfo(logOnInfo)
myrpt.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile
myrpt.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.WordForWindows
Dim opt As CrystalDecisions.Shared.DiskFileDestinationOptions = New CrystalDecisions.Shared.DiskFileDestinationOptions()
opt.DiskFileName = "C:\Inetpub\wwwroot\HJ\out.doc"
myrpt.ExportOptions.DestinationOptions = opt
myrpt.Export()
End Sub
CSDN 水晶报表专栏
中国软件--专栏作家--海波.NET(haibodotnet)专栏
http://www.csdn.net/develop/MY_article.asp?author=haibodotnet
----------------------------------
九、水晶报表 - 问题&补丁2、彻底解决 CrystalReports 登录失败问题 (haibodotnet原创)