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

Understanding the Difference Between Controller and ControllerBase in ASP.NET Core

Image
  Understanding the Difference Between Controller and ControllerBase in ASP.NET Core   What are Controllers in ASP.NET Core? In ASP.NET Core, controllers are the classes that handle incoming HTTP requests from clients (like web browsers or apps) and decide how to respond. They are an essential part of the MVC (Model-View-Controller) architecture and Web API development. Controllers receive input, interact with the application's business logic or data, and then return a response—this could be an HTML page, JSON data, a file, or even a redirect to another page. They act as the “middleman” between users and your application's backend.   Why Controllers Matter in Web Apps and APIs Controllers play a crucial role because they determine how your application communicates with the outside world: In web applications, controllers render views (HTML pages) that users see in their browsers. They make websites interactive by handling forms, navigation, and user input. ...
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