please help me
I must show the report(real time) that data come from database --> (data are from another program)
User open my webpage for looking the report-->update data
How can I set report automatic.
--> automatic refresh<-----
thanks so much
If your report is using the CrystalReportViewer, and you are not exporting the report to PDF or Excel, I would simply set a META Refresh in the header. Here is a reference:
This will cause the page to reload from the server at a specified interval.
You can't do this via VB.NET, since VB.NET runs on the server, and is done once the HTTPResponse has been completely sent to the client. You need to use a client side code such as META Refresh.
If my post is your answer, please mark it as the answer. It will bring good karma.
I use DAtaset and meta data that you told me for refreash data base
this my code on page load
Dim myconn As String
Dim strSQL As String
myconn = "User ID=carlo;Password=;Data source= LAMDBS01;Initial Catalog=ProjAuto;"
strSQL = "select * from kpiboon.joblist"
Dim ds As DataSet
Dim conn As New SqlConnection(myconn)
Dim objAdaptor As New SqlDataAdapter(strSQL, conn)
ds = New DataSet
Dim strReportPath As String = "c://inetpub/wwwroot/crnet/crystalreport4.rpt"
Dim cr As New CrystalDecisions.CrystalReports.Engine.ReportDocument
CrystalReportViewer1.ReportSource = cr
and I add this between <head></head>
<meta http-equiv="refresh" content="10; url=http://localhost/crnet/webform9.aspx">
thanks so much for helping me..