In this example, we will explore some useful select queries that comes handy when we want to retrieve data from different tables. There many ways one can form select queries that returns the same result. For this article, we will use Microsoft’s Pubs database and explore Sub-Queries, Derived Tables and Common Table Expressions (CTE). We will explore these queries one by one.
In this RDLC Reports tutorial, we will explore how to generate the RDLC Reports using the Microsoft supplied report template (.RDLC file). We get the data from the ‘Titles’ table of the Microsoft supplied ‘Pubs’ database. In this example, the ReportViewer Control acts as a presentation UI. To generate the report on the database table, we will use following things:
‘DataSource’ that supplies the data from the database.
‘Report Template’ that defines the visible elements and its location. [.RDLC file]
‘ReportViewer Control’ supplied by the dot net framework.
‘C-Sharp Form’ that houses the ReportViewer control in it.
In this Example, we will see the usage of the ObjectDataSource Control. We will create a web page with a GridView Control and link that control to the ObjectDataSource control. The user will perform data handling through the GridView control. The GridView intern uses the ObjectDataSource to delete or change a record.
Publishing the application in a shared location is useful and pays off for both publisher and clients subscribed to the published application. In the publisher point of view, they no need to cut CDs and ship to every client. Also from the end user point of view, they will get the update to the application that they are using.
This example will explore,
Publishing the application in Network shared path
Providing the Update notification to the Client
Pushing the updates forcibly to the Installed client location
In this article, we will explore how to use transactions in SQL server. Here, we will explore three distinct types SQL transactions. They are:
1) Auto Commit Transactions
2) Implicit Transactions
3) Explicit Transactions