急救水晶报表的连接显示
Dim SQLCnnDB As New SqlConnection
Dim SQLdataset As New System.Data.DataSet
SQLCnnDB.ConnectionString = "server=QING-7911;database=ben;uid=sa;pwd=sa;pooling=false;max pool size=200"
SQLCnnDB.Open()
Dim myCommand As SqlDataAdapter = New SqlDataAdapter("SELECT top 100 * FROM tab_ding", SQLCnnDB)
myCommand.Fill(SQLdataset, "tab_ding")
Dim MyRepor As New CrystalReport1
MyRepor.SetDataSource(SQLdataset.Tables(0))
Me.CrystalReportViewer1.ReportSource = MyRepor
SQLCnnDB.Close()
我用了以上的方法,连接错误。大虾们帮改下,应该怎么写?