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()

Location: India

Comments

Post a Comment

Popular posts from this blog

Understanding Middleware in .NET Core

Image
What is Middleware in ASP.NET Core? If you're starting to learn ASP.NET Core , you've probably heard the word "middleware" quite a few times. It might sound complicated at first, but don’t worry — in this post, we’ll break it down into simple terms . You’ll learn: What middleware is Why it's important How it works How to create your own Best practices (and things to avoid) What is Middleware in .NET Core? Middleware is a piece of code that sits between the incoming HTTP request and the outgoing HTTP response in an ASP.NET Core app. It can: Inspect or modify the request Handle authentication or logging Pass the request to the next step Or even stop the request entirely In simple words: Middleware is like a checkpoint that performs some logic on every request before it reaches your controller or API. Real-Life Analogy: The Airport Imagine you're at an airport going through various checks: Security Check (Middleware 1): Checks...
Read more

Database Approaches in .NET Core: Code-First vs Database-First Explained for Beginners

Image
Why Most Beginners Get Confused Choosing a Database Approach in .NET Core?  Beginners often confused - Here are the main reasons why this confusion happens:   1. Too Many Options, Not Enough Context It's common for beginners to feel overwhelmed by the sheer number of data access options in the .NET ecosystem. The key is to understand that these technologies are not competing to solve the same problem. Instead, they operate at different levels of abstraction to address different needs, from raw speed to developer productivity.    2. .NET Learning Curve is Already Steep ASP.NET Core has a lot: Startup, Middleware, Dependency Injection, Routing, Controllers, Services. Adding database decisions (e.g., how to scaffold models or handle migrations) is just another layer on top of all that.   3. Misleading or Fragmented Tutorials Some tutorials say “Use EF Core, it's simple!” Others say “EF is slow, ...
Read more

Dev tunnels

Image
             Dev tunnels allow you to securely expose local web services to the internet, creating a public URL that tunnels traffic directly to your development machine. This is useful for testing, collaboration, and integration with external services Uses of dev tunnel in daily development Debugging and testing on different devices Dev tunnels eliminate the need for complex network configurations when you need to test your application on a separate device. You can access your local server from a mobile phone, tablet, or another computer by simply navigating to the tunnel's public URL.  Integrating with external services and webhook  Many third-party services, like payment gateways, social media APIs, and communication platforms (e.g., Twilio), rely on webhooks to send real-time notifications to your application.  Since webhooks cannot send requests to localhost, you need a public URL to receive them.   A dev tunnel provides a secu...
Read more