-
Most of the WPF classes derive from Dependency Object . All UI Elements are derived from Dependency Object. The Dependency Object class gives all the functionality of the WPF dependency property system. Dependency Object defines WPF Property System. System.Windows.DependencyObject is used to create Dependency...
-
Today we will make a cascading dropdown application of Country, State and City in JQuery N.B.~ We are using JQuery 1.6.1 Let us first make the entities.We will have 3 entities here viz, Country, State and City Country Entity(Country.cs) /// <summary> /// Summary description for Country /// <...
-
I am learning JQuery and today I did a small program with JQuery Ajax I am using JQuery 1.6.1 The application is very simple. It has a TextBox, a Button and a Label control. Once the user enters something in the textbox control and click on the Button control, then the request will go to the server and...
-
As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to filter the objects in the object explorer. Suppose you have many tables in the database...
-
We may sometime need to display the execution plan . I got one such requirement recently and thought of sharing the same here. I will take two examples into consideration for demonstrating the application . The first with a normal query and then the same with a stored procedure Case 1: Display execution...
-
Often we need to check if the items in the collections are same or not. It comes into action very often during unit testing. Here we will see three ways of doing so Entity Class (Player Entity) namespace ConsoleApplication1 { public class Players { public int PlayerId { get; set; } public string PlayerName...
-
While I was working today on one of my projects, as per habits, I used Conversion functions from Convert class and I noticed a peculiarity. Just sharing this with the readers to keep this in mind: Ideally, Convert.ToInt32("12") is same as integer 12, but this has a big point to note here. Let's...
-
My question in the recent Beyond Relational BI Quiz (see http://beyondrelational.com/quiz/sqlserver/bi/2011/questions/132/use-of-foreign-key-constraints.aspx) sparked a bit of debate about Foreign Keys, and whether they should be used in a Data Warehouse. It's difficult to provide a black-and-white...
-
SSAS Is stands for SQL Server Analysis Services Its is Analytical tool from Microsoft in BIDS Design Scalable Solution with SSAS •Productivity Enhancing Designers – Optimized design experience – Best Practice Design Alerts – Dedicated aggregation designers – Enhanced UBO •Scalable Infrastructure – Heterogeneous...
-
At the times when we need to customize the system, we need to place our own custom prefix string at the time of creation of new entities / option sets etc. To do this, follow the following steps: Open Dynamics CRM 2011 URL and navigate to Settings -> Customization -> Publishers. This should now...
-
In earlier version of Sql Server till Sql 11 (code name: Denali) CTP 2, there was no option to check if a conversion from one data type to another was possible or not.Consider the below example where we are trying to convert a varchar to int Select CONVERT(int,'Just a string') OR Select CAST...
-
In previous posts ( here and here ), I described the methods I use to monitor and maintain indexes. This is a next chapter – let’s try to find candidates for new indexes or hints for extending existing ones. Of course, there are few methods to achieve this goal: Find a candidate query and analyze it...
-
SSRS Stands for SQL Server Reporting Services Future of SSRS SSRS is Reporting Tool From MS for really ease of Developing any type of report It provides a unified, server-based, extensible, and scalable platform from which to deliver and present information. Its scope extends from traditional paper reports...
-
We have encountered this in dot net from framework 2.0. Now we have this in Denali (SQL Server 2012) from CTP 3. Purpose: It basically identifies if the type specified is applicable for parsing or not and returns the appropriate status. Syntax: TRY_PARSE ( string_value AS data_type [ USING culture ]...
-
Recently, while learning Dynamics CRM 2011 in VirtualBox, I had a problem. I placed the data for import and in the status, it kept on showing "Submitted". There was no change. The question that raised in my mind: Why status is not changing from "Submitted" to some other? I thought...