Microsoft WebMatrix–Easy to use IDE

  Microsoft WebMatrix–Easy to use IDE for Web Development Hello Friends, In resent years Microsoft is coming with lot more things for developers, specially web developers. They have introduced various development tools and IDE’s. Now I am going to tell you about new IDE from Microsoft, it is called as “Microsoft® WebMatrix”, following are the details. Microsoft® WebMatrix is a brand...

Windows phone 8?

  Windows phone 8? Is this next version of Windows phone? Hello Guys, Here is cool video for Windows next phone, it will be coming till end of this year 2011. Lot of work has been done in user interface (UI) but most importantly it is looking same as of Windows 8 which will be next OS from Microsoft. I guess, like Windows 8 we can also build apps for Windows phone 8 (presumably it will be name...

STUFF function in SQL

  Recently in one of our assignment we have utilized STUFF function of SQL Server 2005. So just want to share the same. Stuff is very simple function to delete specified length of symbols and insert new symbols in string. We can say it’s a next version for REPLACE function. Following is simple test environment for STUFF function Above SQL script is simple to understand; so use this in your...

Failed to access IIS metabase

  Resolution for error: “Failed to access IIS metabase” while browsing a web site from local host on XP machine with IIS 5.1 version Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Follow following steps to resolve the issue - 1. Unregistered...

Xml Basics in SQL Server 2005

Xml Basics – SQL Server 2005 Hello All, We have used some basic features for Xml structure in SQL Server 2005 in one of our assignment; just want to share the same. When we heard Xml phenomena in context of SQL Server 2005; it creates lot of curiosity about motivation after using the same. In this article we will concentrate on some Xml standard methods which are part of SQL Server 2005, and...

Anonymous Types in Visual Basic

Anonymous Types  in Visual Basic Visual Basic 2008 introduces anonymous types, which enable you to create objects without writing a class definition for the data type. Instead, the compiler generates a class for you. The class has no usable name, inherits directly from Object, and contains the properties you specify in declaring the object. Because the name of the data type is not specified, it...

10 reasons why SQL Server 2008 is going to rock!

Differentiator Features of SQL sever 2008 Here are the top 10 reasons why 10 reasons why SQL Server 2008 is going to rock. 10.  Plug-in model for SSMS.   SSMS 2005 also had a plug-in model, but it was not published, so the few developers that braved that environment were flying blind.  Apparently for 2008, the plug-in model will be published and a thousand add-ins will bloom. ...

SQL Error: Database diagram support objects cannot be installed

Solution to MS SQL Error: Database diagram support objects cannot be installed If you ever get a message like this when trying to create a diagram in SQL 2005 “Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database...

Microsoft Visual Studio LightSwitch – Introduction

What is Microsoft Visual Studio LightSwitch?   Microsoft has finally announced the Visual Studio LightSwitch, which is featured as the newest member of the Visual Studio product family. Microsoft Visual Studio LightSwitch gives you a simpler and faster way to create professional-quality business applications for the desktop, the web, and the cloud. Microsoft has revealed that LightSwitch dramatically...

Understanding INNER join in detail

Understanding INNER join in detail The objective of this article is dig into detail of how INNER joins produce the result set. The INNER join is the common join type used in many cases. Even though it is used very often I have seen most people are not certain how it produces the result set when changing the join condition.   Before go into the article contents, I need to create the two tables...

Total instances running of application in C# .NET

Total number of instances running of application in C# .NET Many times we needs to find how many instances of particular application or process are running. This can be used in allowing to run only single instance of application or at most 2 etc. Also count can be useful for licensing and other stuff. So here is simple code to find out how many number of instances are running for particular application...

Setting up Master Page at runtime in asp.net

Setting up Master Page at runtime in asp.net   Many times we needs to decide master page at runtime. Here is quick help for the same. You will have to use ‘Page_PreInit’ method. In that set MasterPageFile attribute of current page to required master page. And Done ! protected void Page_PreInit(object sender, EventArgs e) { this.Page.MasterPageFile = “~/MasterPages/” + mymaster...

Delete All Stored Procedures and Views in SQL

  Delete All Stored Procedures declare @procName varchar(500)declare cur cursor for select [name] from sys.objects where type = 'p'open cur fetch next from cur into @procName while @@fetch_status = 0 begin if @procName <> 'DeleteAllProcedures' exec('drop procedure ' + @procName) fetch next from cur into @procName end close...

Delete All Tables in MS SQL

Delete All Tables  – MS SQL Query --Delete All Keys DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSORSET @Cursor = CURSOR FAST_FORWARD FORSELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + ']'FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAMEOPEN @Cursor FETCH...

Custom Installer Class to create setup tasks in Visual Studio Setup Project

Custom Installer Class to create setup tasks in Visual Studio Setup Project Sometimes we have to perform custom tasks that are not there in ‘Visual Studio setup project’. Installer Classes are great tools that you can develop and integrate with your Setup and Deployment Projects in order to perform additional tasks while running any application’s installation or un-installation process, though...

Visual Studio 2010 Samples for C# 4.0

Visual Studio 2010 Samples for C# 4.0 We break out the C# samples into two different categories: Language Samples LINQ Samples Language Samples The language samples familiarize you with various C# language features. They are available in the LanguageSamples folder. The C# 4.0-specific samples are called: Named and Optional Office Sample Python Sample Simple Variance Here is the complete list...

Take and Skip Partition Operator in LINQ

Many times we have requirement, to fetch partial result set from collection like Arrays, DataTable. To achieve the same we can use Take and Skip Partition Operator of LINQ. Skip Partition Operator Reference: http://msdn.microsoft.com/en-us/library/bb358985.aspx Take Partition Operator Reference: http://msdn.microsoft.com/en-us/library/bb503062.aspx For this we will consider following example of Array...

app.config modification issue in Windows 7

File modification issue in Windows 7 for program files content We have developed many windows application using C# or VB.NET. In that we stored connection string and other required data in ‘app.config’ file, and we modify that file using our application to store latest connection or other information. This is standard practice and works as well. But in ‘Windows 7’ OS architecture is changed...

Which Smartphone or mobile platform should developers aim for?

For start-ups without a lot of time or money, is it smarter to develop for the iPhone first or the Android OS? iPhone is more popular, it has got more user base so does we go for it? Or, although Android is less popular now but can be popular in future so does we go for it? Also competition is less for Android than iPhone. So considering all this factor, it is really difficult to suggest which development...

What is Google App Engine”

What is Google App Engine?   Google App Engine enables developers to build their web applications on the same scalable systems that power Google’s own apps. Google App Engine enables you to build web applications on the same scalable systems that power Google applications. Google App Engine gives you access to the same building blocks that Google uses for its own applications, making...