Updating dataset in c by arrangement dating
It is the Sql Data Adapter that manages connections with the data source and gives us disconnected behavior.The Sql Data Adapter opens a connection only when required and closes it as soon as it has performed its task.And this is especially true if you are using Enterprise Library.A good example is a that can accept a table as parameter so that you have all the granularity. Suppose we have a purchase order management system and we want our suppliers to supply items in installments.
This Lesson shows how to accomplish something in-between Sql Connection and Sql Data Reader interaction by using the Data Set and Sql Data Adapter objects.
For example, the Sql Data Adapter performs the following tasks when filling a Data Set with data: In between the Fill and Update operations, data source connections are closed and you are free to read and write data with the Data Set as you need.
These are the mechanics of working with disconnected data.
One of the most compelling capabilities in SSRS is the ability to extend report features with custom code and programming extensions.
I'll then provide step-by-step instructions on how to write a custom assembly with Visual Studio and use it to build a dynamic report dataset.