我搜索了一段语句,为什么加在我的程序中,有一行存在语法错误,具体如下:
Private Sub BindReport()
Dim myConnection As New SqlClient.SqlConnection
myConnection.ConnectionString = "server=localhost;uid=sa;pwd=;database=dtw_InfoSys;Trusted_Connection=yes"
Dim MyCommand As New SqlClient.SqlCommand
MyCommand.Connection = myConnection
MyCommand.CommandText = "Select * from zichzl"
MyCommand.CommandType = CommandType.Text
Dim MyDA As New SqlClient.SqlDataAdapter
MyDA.SelectCommand = MyCommand
Dim myDS As New Dataset1
MyDA.Fill(myDS, "zichzl")
Dim oRpt As New CrystalReport1 '这一行存在语法错误
oRpt.SetDataSource(myDS)
CrystalReportViewer1.ReportSource = oRpt
End Sub
在我的程序中已经建立了一个CrystalReport1报表,并且使用数据集方式连接的。为什么我这里还是语法不识别?我将如何解决?
Private Sub BindReport()
Dim myConnection As New SqlClient.SqlConnection
myConnection.ConnectionString = "server=localhost;uid=sa;pwd=;database=dtw_InfoSys;Trusted_Connection=yes"
Dim MyCommand As New SqlClient.SqlCommand
MyCommand.Connection = myConnection
MyCommand.CommandText = "Select * from zichzl"
MyCommand.CommandType = CommandType.Text
Dim MyDA As New SqlClient.SqlDataAdapter
MyDA.SelectCommand = MyCommand
Dim myDS As New Dataset1
MyDA.Fill(myDS, "zichzl")
Dim oRpt As New CrystalReport1 '这一行存在语法错误
oRpt.SetDataSource(myDS)
CrystalReportViewer1.ReportSource = oRpt
End Sub
在我的程序中已经建立了一个CrystalReport1报表,并且使用数据集方式连接的。为什么我这里还是语法不识别?我将如何解决?
解决方案 »
- 没想到要用jquery获得dropdownlist的值很困难!
- 此网站的缺憾
- 如何让ValidationSummary控件有条件地显示?
- 请问各位高手,如何对textbox输入的信息判断只能是数字或小数点,最后用javascript实现?
- StreamReader如何换行?
- server.HtmlEncode()和Server.HtmlDecode
- [急]Select控件为什么不走ASP.net里的ServerChange事件
- 请问怎样用javascript来判断点击的是哪个imagebutton控件?
- asp.net 把共享的打印机通过程序罗列出来
- 每改一个文件,发布后就要重新传全部的aspx文件,很麻烦啊
- 菜鸟求助
- 求助!数据源控件问题!
SqlConnection Conn = new SqlConnection(str);
Conn.Open();
SqlDataAdapter myCommand = new SqlDataAdapter("SELECT * from 员工信息 where 是否离职='否'", Conn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "员工信息");
DataView View = new DataView(ds.Tables[0]);
if (View.Count == 0)
{
Response.Redirect("../NoData.aspx");
}
else
{
CrystalReportSource1.ReportDocument.Load(Server.MapPath("../baobiao/CryXueLi.rpt"));
this.CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables["员工信息"]);
this.CrystalReportViewer1.ReportSource = this.CrystalReportSource1.ReportDocument;
}
我的页面中只引用了:
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
还有其他需要引用的吗