RDLC report in VB.Net windows form application
RDLC report in VB.Net windows form application
Dim con As New SqlConnection("Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Employeedb.mdf;Integrated Security=True")
Dim SqlQuery As String = "select * from EmployeeMst order by id"
Dim cmd As New SqlCommand(SqlQuery, con)
Dim da As New SqlDataAdapter(cmd)
Dim ds As New DataSet()
da.Fill(ds)
Dim rds As New ReportDataSource("DataSet1", ds.Tables(0))
ReportViewer1.Reset()
ReportViewer1.ProcessingMode = ProcessingMode.Local
ReportViewer1.LocalReport.ReportPath = "FirstReport.rdlc" 'RDLC path
ReportViewer1.LocalReport.DataSources.Clear()
ReportViewer1.LocalReport.DataSources.Add(rds)
ReportViewer1.RefreshReport()
Comments
Post a Comment