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

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

Simple Data Extension

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
Hi I have a requirement to apply security filtering (column and row level) above and beyond the capabilities of SSRS Model security. in 2005 and 2008 I achieved this by creating a data Extension and tweaking the Command text and execute reader methods, and all was Well with the world. Now all I wanted was a bit of customisation of the SQL data Extension  (SQL Connection Wrapper)... of course its Sealed so couldn't inherit, so I composite / wrapped it... and all was well with the world......  Now along comes SQL2008 R2 .... and someone has discovered the internal Keyword !  now everything is locked down.  the Constructor of SQL Connection Wrapper  is internal. Luckily my code is not yet producion code, and I know Microsoft are completely within their rights ... but why!!! ... all is not good with the world, I doubt I am alone in this ! Any suggestions how to implement a minor customisation to SQL data Extension, without reimplementing the whole of the dataExtensions DLL ! Any chance the decison might be reversed ?  regards Iain   

View Complete Post

More Related Resource Links

XML in .NET: .NET Framework XML Classes and C# Offer Simple, Scalable Data Manipulation


Microsoft .NET introduces a new suite of XML APIs built on industry standards such as DOM, XPath, XSD, and XSLT. The .NET Framework XML classes also include innovations that offer convenience, better performance, and a more familiar programming model, tightly coupled with the new .NET data access APIs-ADO.NET. XmlWriter, XmlReader, and XmlNavigator classes and classes that derive from them, including XMLTextReader and XMLTextWriter, encapsulate a number of functionalities that previously had to be accomplished manually. A discussion of the XMLDOM-Document is also included.

Aaron Skonnard

MSDN Magazine January 2001

A simple Data Modeling Question


I have a data modeling question that hopefully this fictious example will help explain.  My application is data driven and the classes reflect the tables to a large degree.   In this example my database has two tables:

  • VendorMaster with an int Primary Key of VendorID
  • VendorContact with an int Primary Key of ContactID

The VendorContact table also has a Foreign Key of VendorID in order to associate the contact with a specific Vendor.  In this example a Vendor can only have one contact.

My question is how to represent these two tables in terms of classes.  In my current design I have two classes:

  • VendorMaster
  • VendorContact

In order to represent the relationship between a VendorMaster and VendorContact, my VendorMaster class contains a property called VendorContact.

My questions are about the VendorContact class and how it represents the relationship between a VendorMaster and itself.

Option #1

The VendorContact class should contain an int property of VendorID

Option #2

The VendorContact class should contain a VendorMaster Property

I am not sure which option is the 'best' option to take. My concern is that if I go with option #2 that I would create a cyclical relationship between the VendorMaster and Vendo

Simple data binding question

Newbie binding question here: is it possible to bind a control in XAML to a StaticResource by passing in the key via a data structure? Basically something like this: <TextBlock Text="{Binding ImageKey}" /> <Image Source="{StaticResource ResourceKey={Binding ImageKey}}" /> <-- doesn't work   The TextBlock binding on the first line works correctly, it extracts the key of the StaticResource from my data structure and displays it correctly. What I'm trying to do is get the Image control to bind to the StaticResource with that name (which happens to be a BitmapImage).      

ASP.Net Dynamic Data - DropDownList Field Template with AJAX Cascading DropDown Extension

Hi all,   Have spent hours trying to create a Dynamic Data Field Template holding a DropDownList which is extended by the AJAX Cascading DropDown extension. Final form holds multiple cascading dropdown boxes. User selects Country (Land) then Postcodes, Counties (Provincie) are populated. Once postcode is selected then towns (Plaats) are populated.  The problem I am now facing is that the viewstate for the dropdown lists is not being saved/restored after an insert action or custom validation error. So basically the dropdown lists are being reset to their default values. Some code (if missing parts, just ask and I will post them) - Don't mind the code structures etc... needs some refactoring :) Attribute I created:using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Data { [AttributeUsage(AttributeTargets.Property | AttributeTargets.Field, AllowMultiple = false)] sealed public class CascadingDropDownParametersAttribute : Attribute { //public string TargetControlID; // The ID of the DropDownList to populate. public string Category; // The name of the category this DropDownList represents. public string PromptText; // Optional text to display before the user has selected a value from the DropDownList. public string

Help - simple data binding

As a newbie I am struggling with the data binding syntax. In the code below I have used a class to create a simple data structure. (I need to be able to fill this from an array which I can do.) For this example I have filled it in directly. However, despite exhaustive searching in the web I cannot find a Visual Basic example showing me how to bind this data source to a Datagrid. I have included in the code the xaml for a basic data grid. Can anynbe help me with the xaml to bind the fields to textboxes? Class MainWindow Public test As String ' Public mage() As Integer = {24, 35, 46, 57} Private Sub Window_Loaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded Dim P1 As New myPerson(111, "Bob", 23) Dim P2 As New myPerson(222, "Fred", 34) Dim P3 As New myPerson(333, "Bill", 17) Dim P4 As New myPerson(121, "Alf", 44) Dim st As New SortedList st.Add(P1.name, P1) st.Add(P2.name, P2) st.Add(P3.name, P3) st.Add(P4.name, P4) Dim P As myPerson Dim i As Integer For i = 0 To st.Count - 1 P = CType(st.GetByIndex(i), myPerson) Console.WriteLine("The age of " & P.name & " is " & P.age) Next End Sub End Class Public Class myPerson Public id As Integer Public name As String Public age As In

Simple Data Import Help


I know I am new to SSIS but first impressions mean a lot and what it is telling me is that SSIS is NOT user friendly and is extremely complicated to do simple tasks that can be done using windows services in 5 minutes.  With that opinion being said, all I am trying to do is the following:

1. I have two databases A and B

2. I need to run about 5 different SELECT queries to gather data from A

3. I need to run an insert statement using the 5 result sets from A to move data into a table in B

In a service places the data into datatables which are then merged into a single datatable and then bulk copied to the new database.  I can also do it by hand exporting the results of the queries to a csv file and then importing the data to the new table.  Anyone know how to do this in SSIS because it does not appear straight forward.  I have tried Execute SQL Task but it doesn't support DECLARE statements and everytime I do it per query I get the following error:

"The type of the value being assigned to variable "User::DATA" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object."

Unable to locate System.Data.Extension.dll library in Add Reference.



I want to use LINQ over DataSet in my C# ConsoleApplication project.But i do not find System.Data.Extension.dll in Add Reference section of my project.There is System.Data.DataSetExtension.dll present. I added that file, but then which namespace to use in my project ?

SSRS Data Extension


I hope so I am not the first one who has this requirement. I have the requirement that on the based of the users input I should get the value for another field. Sounds easy but this value should be get from combination of activedirectory and StoreProc.

I have a custom Project that extends ReportingService.Interfaces ie IDB...

1) Create a Connection string based on what input the programmer has set during creating datasource while creating the report. -- COMPLETED and Working fine

2) Based on the commandType -- Send the Command text to the function that will call the storeproc and also active direcotry and get the values  -- This is working fine  only when the CommandType is set to TEXT and "select * from Locations" which will give @StoreNo

But Now I have to pass the storeproc with the parameter ie in the text it will be "exec uspselectdeptByLocations @StoreNo"  WHAT SHOULD BE DONE... How can I pass the parameter value to this custom dataextension. I know this is not at all good explanation but I need help.

My custom dataextension should accept any commandType with dynamic parameter value.



SqlClient access in Data Processing Extension


Hi there,

I think it's a common situation for making a data processing extension, I'm wondering whether something wrong with my server.

When I deployed the dll in "C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin", I updated rsreportserver.config and rssrvpolicy.config as,




Extension Name="FSI"

Does Simple Dynamic Data Fields exist using VWD10?



Hello, everyone.

I created this simple dynamic data form using Dreamweaver cs4, ASP VB technology and a MySQL Database:


I love all of the extended functionality that VWD 10 provided, but the most important functionality for me is to be able to completely design a dynamic data table any way I want.

I noticed after researching extensively that the GridView, ListView and DetailsView templates still leave me very limited in what I can design.

My question: is there a way for me to design a table in a details page with record placeholders that will be fetched from a master/detail page set?

How do I create an XML file from a text file containing simple ascii data? Put another way, how do I


Im trying to take a text file I downloaded from the US Census Bureau website and transform it into an XML file. It is what the Census Bureau calls a ZCTA file. The schema of the file I have reposted as follows:

ZCTA File Record Layout

The ZCTA file contains data for all 5 digit ZCTAs in the 50 states, District of Columbia and Puerto Rico as of Census 2000. The file is plain ASCII text, one line per record.

  • Columns 1-2: United States Postal Service State Abbreviation
  • Columns 3-66: Name (e.g. 35004 5-Digit ZCTA - there are no post office names)
  • Columns 67-75: Total Population (2000)
  • Columns 76-84: Total Housing Units (2000)
  • Columns 85-98: Land Area (square meters) - Created for statistical purposes only.
  • Columns 99-112: Water Area (square meters) - Created for statistical purposes only.
  • Columns 113-124: Land Area (square miles) - Created for statistical purposes only.
  • Columns 125-136: Water Area (square miles) - Created for statistical purposes only.
  • Columns 137-146: Latitude (decimal degrees) First character is blank or "-" denoting North or South latitude respectively

Columns 147-157: Longitude (decimal degrees) First character is blank or "-" denoting East or West longitude respectively

All I want to do is produce an XML file with t

Custom Data Processing Extension doesn't show but should be registered correctly.



I have a custom data processing extension that i can't see to get to work. I followed the steps like in :http://msdn.microsoft.com/en-us/library/ms155086.aspx to register the extension. Yet the extension does not show up in the data source list.

It's an extension made for ssrs 2008 and I want to use it on a SSRS 2008R2 instance. I don't have any reasons to believe that I did not configure the extension correctly, it's the same as the article and and the same on my 2008 instance.

I am using Reporting Services standard edition 2008 R2 with cumulative fix patch 4 so that should support extensibility.

The data sources that I migrated from 2008 that still refer to the extension give a message saying that the extension is not registered or configured correctly. But i swear I did it right.

Any other extension that I use did register fine, none of them are DPE's though.


My config:


  <Extension Name="SecurityDataProce

looking for simple Jquery for fancy data display


In attempting to start using JQ, I want to implement a simple example of clicking a hyperlink/linkbutton in gridview and display that row's detail info in a fancy animated popup. Can anyonepoint me to a good example? I would already have the data captured into vars.

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

The Decorator Pattern & Extension Methods

The decorator pattern provides a formal way to add new functionality to an existing type, without sub-classing. First question: What is wrong with classical inheritance? In and of itself, nothing is wrong with the good old Is-A relationship. It is very common to derive a new class from an existing base class in order to override a few virtual members, and add a pinch of new functionality.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.
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