[2005] Filling a typed dataset and getting it to display in crystal report
Hi all
I have a asp.net project with a crystal report. I created a dataset now I've tried to fill it but it doesnt show in my crystal report. can anybody help. Here is my code behind's code
Code:
Public Function Wanted() As Data.DataTable
Try
'Dim strConnection As String = "..."
'Dim Connection As New Data.OleDb.OleDbConnection(connclass.INITSQL)
Dim DS As New Data.DataSet
Dim DA As New Data.SqlClient.SqlDataAdapter
Dim strSQL As String = "Select * From MIS_PART1"
DS.Clear()
adoconn = connclass.INITSQL
adoconn.Open()
DA = connclass.INITADAPTER(adoconn, strSQL)
DA.Fill(DS, "dsWanted")
Return DS.Tables("dsWanted")
Me.CrystalReportSource1.DataBind()
Me.CrystalReportViewer1.DataBind()
'Me.CrystalReportSource1.DataBind()
'DS.WriteXmlSchema("C:\Dev\MySchema.xsd")
Catch ex As Exception
'some error handling
End Try
End Function
Please help:confused:
Re: [2005] Filling a typed dataset and getting it to display in crystal report
Don't know much about CR but see if this MSDN bit helps
http://msdn2.microsoft.com/en-us/lib...91(VS.71).aspx
Re: [2005] Filling a typed dataset and getting it to display in crystal report
thanks but I'm not using at as a report service