.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Reusable datasets

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server
I use a common set of parameters in several Reporting Services reports.  The parameters are populated with queries defining datasets.  Is there any way to maintain these queries centrally and reuse them in multiple reports without having to cut and paste SQL into each report definition?

View Complete Post

More Related Resource Links

Typed DataSets in .NET

we can specify the data type when we create a DataColumn for a DataTable. This is to enforce the runtime type-safety for the column so that only data of specified data type can be stored in the column

UnTyped DataSets and Strongly Type DataSets

We all are use datasets as a means of carrier of data from one layer to another. Most of the time we are using weakly typed datasets. In this article I will explain the differences between weakly typed datasets and strongly type datasets

Visual Studio 2005: Create Reusable Project And Item Templates For Your Development Team


Visual Studio 2005 introduces a new model that lets you define your own project templates and starter kits, something developers have been requesting for some time. Here Matt Milner shows you how to consume, create, and customize these templates.

Matt Milner

MSDN Magazine January 2006

Cutting Edge: DataSets vs. Collections


In software, five years is like a geological era. Five years ago, the Microsoft® . NET Framework had just been announced. Since then, the DataSet has emerged as the key object for performing a variety of data-related tasks in .

Dino Esposito

MSDN Magazine August 2005

Data Points: Efficient Coding With Strongly Typed DataSets


Someone once said to me that the hallmark of a good developer is the desire to spend time efficiently. Developers are continually pursuing ways to make coding easier and faster, and to reduce the number of errors.

John Papa

MSDN Magazine December 2004

Cutting Edge: Binary Serialization of DataSets


The ADO. NET DataSet object plays an essential role in most of today's distributed, multitiered applications. Instances of the DataSet class are used to move data across the tiers and to exchange data with external services.

Dino Esposito

MSDN Magazine October 2004

The XML Files: Web Services and DataSets


Programmers using Visual Basic® 6. 0 have long bowed to the altar of the ADO recordset. It's probably the most commonly used data structure in Windows®-based applications today. The ADO. NET DataSet is poised to play a similar role in the realm of managed Windows-based applications.

Aaron Skonnard

MSDN Magazine April 2003

Web Services: Building Reusable Web Components with SOAP and ASP.NET


XML and HTTP are cross-platform technologies especially suited for building applications that can communicate with each other over the Internet, regardless of the platform they are running on. Web Services in the Microsoft .NET Framework make it easy to write components that communicate using HTTP GET, HTTP POST, and SOAP. An understanding of these concepts, along with knowledge of synchronous and asynchronous operations, security, state management, and the management of proxies by the .NET Framework is essential in building these applications. This article has been adapted from David Platt's upcoming book introducing the Microsoft .NET Platform to be published by Microsoft Press in Spring 2000.

David S. Platt

MSDN Magazine February 2001

Typed DataSets/Connection Pooling


 Hey all,

I've got an ASP.net application that has about 100-120 sites connecting to punch in/out in the beg of shift, lunch, and end of shift. I've found that the app gets slow/non-responsive during peak times. Also, I'm noticing that the app will throw Oracle End of File Communication errors periodically during the day. I'm using Strongly typed Datasets to interact with the DB. I have a couple of questions:

1. What type of cleanup should I be performing? Should I be closing/disposing the connection or Adapter instance or is this handled internally by the dataSet?

2. I have the connection pooling set to the default - 100. Should I increase this or will this cause other performance issues? How would one test to see if the connection pool is maxing out? Could this be causing the Oracle EOF (ORA-03113) errors?


reusable components and unique ids


I'm trying to create reusable "zones" but am having trouble figuring out how to give them all unique ids.

What I'd like is to be able to create a component which can be put on an mvc page using the usercontrol syntax or using RenderAction or RenderPartial.  I want to be able to update these components' content using ajax, so I need someway to reference them by id.  However, there is no mechanism in MVC that wraps anything in a div or something like that.

I've learned that if I extend ViewUserControl and put the controls on the page like so:

<Zones:TestControl runat="server" ID="TestControl1" />

Then I can use the 'ClientID' property to get the unique ID generated.  However, if I use RenderAction or RenderPartial in another request, obviously the control hierarchy is missing, so the ID is just 1.  So to get around this I made a simple base class like so:

public class BaseZone<TModel> : System.Web.Mvc.ViewUserControl<TModel>
        protected string zoneId;

        public string ZoneId
                string zoneId = ViewData["ZoneId"] as string;
                if (String.IsNullOrEmpty(zoneId))
                    return this.C

proper pattern for list of reusable controls


Say you have a for loop which renders a bunch of the exact same control.  This is probably done with RenderAction or RenderPartial.

What is a way to ensure that each of these controls in the list gets wrapped in a div with a unique ID?


pass parameter between datasets



I've a user table, and contact table linked to it, and appointments where contact are linked to it with users in this in it.

I need a report which show ...by user number of contact created by this user and number of appointment created

so i guess i need two datasets but how can I pass parameters between them to know what is the current user id ..?

thanks so much  

How to create strongly typed datasets with access parameter queries



How can you create strongly typed datasets using an access database against access select statements that use parameters?

The problem is VS.Net doesn't allow select queries with parameters to be dragged onto a form, it only allows access queries without parameters!

I also tried the dataadapter wizard, but again it only allows me to select queries without parameters?

Many thanks in advance


asp.net insert into 3 related tables using three tier architecture and typed datasets

I am using ASP.NET (C# and sql server express 2005) for my web application project. I have three related tables.I want to do an insert using typed datasets,tableadapters and three tier architecture.I wish to know how to do simultaneous inserts in 3 tables.So i wish to insert a row in first table and get its primary key.Same with the second table.I will use the primary keys of those first two tables to do the insert in the third table.How can i accomplish this using formview control and what methods should i use??Please give me suggestions.thanks in advance for reading this. I really appreciate it.

manage with two datasets - Who like tricky query ???

I've a big issue I don't know how to manage this with report builder 2.0 I've four table. - SystemUser (systemUserId) - FilteredContact (onwerid, owneridname, contactid, lastname..) - FilteredAppointment (ownerid, stateCode, Subject, ActivityId, CreatedBy, OwnerIdName..) - FilteredActivityParty (ActivityId, PartyId, participationTypeMask...) So basicly the user can create contact, so it becomes the owner of the contact. And user can create appointments, but need to choose a contact as required to the appointment. This contact can be created by the current user or not. So FilteredContact.contactID = FilteredActivityParty.partyId , as a contact is in a list of activityParty. FilteredAppointment.activityId = FilteredActivityParty.activityId So FilteredSystemUser.systemUserId = FilteredContact.ownerId FilteredAppointment.activity.ownerId = FilteredContact.contactId   With all that, I need to get by FilteredSystemUser.systemUserId, the amount of FilteredContact that Im the owner and I need to know how many people(partyid) where Filteredappointment.ownerId=Filteredsystemuser.systemuserid. And I cant find a way to manage this without two datasets. I've no idea how to link thus two datasets between them. Thanks for your help

Multiple DataSets in One Page

Hi, I'm using SSRS 2005. I'm working on a SSRS that has three data set: one for client information display, the other for chart (graph) and third for Report Parameter to select Clients Name. Clients can have one of more facilities. The issue I'm running into is that when a user selects a client from the parameter, I get multiple facilities info for the client selected and and one Graph at the end. For example, if I have client ABC and client ABC has 3 facilities: Fac1, Fac2 and Fac3. The info for each facilities is displayed, but only one Graph is displayed at the end of the page; I understand this is because I'm using a List to display the info using a separate Dataset and a separate dataset for the chart. My question is there a way that facilities information and chart can be displaced on one page? For example, Fac1 information and the chart associated with it on one page and next page would be Fac2's info and chart and so on.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend