ITORIAN BLOG

In this video post, you will learn how to setup a simple project on LINQ to SQL using Console Application.

This is sixth part of the ‘LINQ’ series posts that I have started from here . In the last post we explored selecting records using LINQ and its internals. Now in this post we will be looking at filtering, ordering, grouping and joining using LINQ.

This is fifth part of the ‘LINQ’ series posts that I have started from here . In the last post we talked on how to setup a demo project to explore LINQ queries, I expect you too have a demo project with you, if not then visit Part 4 of this series and setup it. Let’s go ahead and explore selecting records using LINQ and explore internals.

This is fourth part of the ‘LINQ’ series posts that I have started from here . And in this post, you will learn how to setup a demo project to explore LINQ queries. I will use my preinstalled ‘Northwind’ database that you can download from here and install it in SQL Server Management Studio.

Consolidating all blog posts monthly are very refreshing as it gives me chance to go back and see what I did in last month and for readers gives the chance to see what he not followed up.

This is third part of the ‘LINQ’ series posts that I have started from here . And in this post, you will learn something on ‘Generic’ like what are generic types, why we need it in LINQ?

It is a simple error meaning your database is down. To fix this, follow the steps given below: SQL>connect sys/password as sysdba SQL>startup SQL>exit

Any query/command (single line or multiple line) we execute resides in the buffer temporarily and it is lost when we execute new query/command because new one takes that place. In case we try to edit that query/command which is in the buffer we get an error " SP2-0110: Cannot create save file "afiedt.buf" ". There are many ways to fix this, I'm going to show you three different ways. 1. Always run the SQL Command Line as administrator. Once you start this way, you will not see said error. 2. Sometimes w e get this error message because we don't have write permission on the current directory. Either start sqlplus from a different directory, or change the editfile entry in sqlplus: SQL>set editfile d:/sqledit.sql In above code, you can use any drive for this and any file name. 3. Create sqledit.sql file and save it in bin directory (sometimes this file misses cause this error) of oracle where sqlplus.exe is resides.Then run sq

This is second part of the ‘LINQ’ series posts that I have started from here . And in this post, you will see some quick examples on LINQ title. As I said in previous post, with LINQ you just need to perform three distinct actions: Obtain the Data Source, Create the query and Execute the query, you will notice it in sample programs given below. We will create Console Apps and test various LINQ concepts. I will walk through very simple programs here and in coming part will dig in depth.

Error: this template attempted to load component assembly 'NuGet.VisualStudio.Interop, Version=*, Culture=neutral, PublicKeyToken=*'. For more information on this problem and how to enable this template, please see documentation on Customizing Project Templates.

Recently I had started exploring ‘LINQ to Entities’ new features. So, I thought to start a series of posts on ‘LINQ’ title and accumulate it on my blog for the beginner’s. Hope, this series will be helpful to you to understand the ‘LINQ’ and before jump start to the application development let’s talk on basics something like: what is linq and its benefits.

So, it's 15th August 2012 (Independance Day of India) and as per the previous announcement by Microsoft, Windows 8 and Visual Studio 2012 is now available for downloads.

Introduction Read my previous two posts ‘ Code First Approach in Entity Framework ’ & ‘ Database First Approach in Entity Framework ’ for EF basics. In this post I’m directly going to jump on Model First Demo Project.

Friends, recently I subscribed a YouTube channel to boost-up my .NET and C# skills by just watching videos. These videos are being recorded by our start tech leader ‘Shivprasad Koirala’ sir ( http://www.questpond.com ). I recommend you to go and subscribe the channel to receive the upcoming videos in your inbox and even watch the uploaded videos that is already recorded. I watched all of the recordings and eagerly waiting for new alert in my inbox.  LearnDotNet60days

Want to learn Entity Framework then I got some videos for you in HINDI Language, go ahead and watch it.

Introduction Read my last post ‘ Code First Approach in Entity Framework ’ for EF introduction even for the basic touch.

Introduction Entity Framework is the Microsoft preferred method of data access for .NET applications. It supports strongly-typed access through LINQ. Entity Framework also allows developers to program against a conceptual model that reflects application logic rather than a relational model that reflects the database structure. Entity Framework can be used from an ASP.NET Application, (using Entity Data Source) or in ASP.NET MVC etc. In this article we will be creating this using MVC App and we’ll be using Visual Studio 2012 for demo.

After the installation of newly released Office 2013 Preview I noticed Visual Studio 2012 RC won’t running anymore. And it said error “The procedure entry point_Atomic_fetch_sub_4 could not be located in the dynamic library: C:\Program Files\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe.”

In this post I would like to share my strategies for web performance optimization and speeding up website, here's my list with tools or technologies I use: 1. Code minification and bundling By this process we remove comments and extra spaces as well as crunch variable names in order to minimize code. Code minification applies to CSS, JavaScript or HTML codes and code bundling applies to CSS and JavaScript codes, in some cases we bundle HTML codes also. If you use Visual Studio, then it has an extension Bundler & Minifier (by  Mads Kristensen) this tool can easily bundle and minify codes inside IDE. You can configure this extension for automatic bundling on build as well as you can use this to manually select files and then bundle and minify. Another way with Visual Studio web applications which I like the most, is by using bundling and minification NuGet packages, this automatically bundles and minifies when you publishing project in release mode. There

Consolidating all blog posts monthly are very refreshing as it gives me chance to go back and see what I did in last month and for readers gives the chance to see what he not followed up.

Bundling and minification are two new techniques introduced with ASP.NET 4.5 Beta to improve request load time.   It improves load time by reducing the number of requests to the server and reducing the size of requested assets (such as CSS and JavaScript).

In previous versions of Windows, to set startup programs we just open Run > msconfig.exe and in appeared window find ‘Startup’ tab or click on Start > All Programs > Startup (and list the programs here by dragging icons) but in Windows 8 there is bit changes.

My friend Karthikeyan (aka. @f5Debug ) published a free e-Book on Windows Phone titled "Windows Phone Development Step by Step Tutorial" . This eBook covers most of the topics of developing an application with Windows Phone with a step by step approach on using each of the components that are available with the Windows Phone framework. The eBook is targeted towards audience of level 100 to level 400 to get complete idea of application development from the scratch.

Again, one of my follower on Facebook asked me a question, here it is. Hello Sir I'm new in C#, i tried lot to understand the get/set properties but still can't understand. Please help, why and how we use this? by Manish Kumar And this blog post is my response to his ask. So, let’s get started.

How many ways do you know to send the data between ASP.NET Pages? In this post I’m going to list 5 different ways. First 2-3 ways are very well-known and last 2-3 ways are not much popular. You will find here mostly inline methods to receive the data on different pages. You can download the complete code here .

This is a quick post in response to a question asked by my one of the follower on Facebook and the answer is pretty simple. Here is the question I have been asked:-

The main advantage of parameterized query is to protect the database from SQL Injection. Today I used this concept in my one of the project. Do you know using ‘Like’ operator in parameterized query is bit different?

This is a quick hit post. If you are developing a form in ASP.NET you may be noticed that when we press enter key even without writing any information in textboxes, form gets post (submitted). So, how do you stop it?

Another title of this post would be “Say bye-bye to Postbacks”. Sometimes we need to stop annoying post-backs on ASP.NET Web Pages. For example, when one click the ASP.NET button on webpage, by default page gets post-back. So, how we stop this by keeping proper code-behind method calls. Let’s look at one case.

In Windows 8 we have three password options i) Live Account Password (works like normal password) ii) Picture Password and iii) PIN Password. In this post we will see how to setup Picture Password.

In Windows 8 we have three password options i) Live Account Password (works like normal password) ii) Picture Password and iii) PIN Password. In this post we will see how to setup PIN Password.

Last weak, two Telerikers Joshua Holt and Carl Bergenhem introduced a very nice free e-book for developer community to get job done quickly with less code. Very nice book, read it once.

If you are from web technology and using jQuery then you might be knowing that jQuery third-party plugins provides a bevy of options for enhancing our application user experience but sometimes we need to reach a bit farther and write our code that could be reused by others by just placing it on servers or even want to package it up as a brand new plugin. So, this post will give you complete knowledge of jQuery Plugins Development. Download the Project

I'm so delighted to see an email with subject "Congratulations Microsoft MVP" in my mailbox this morning. I'm honored to be recognized in Microsoft MVP Program, this is one of the most prestigious award and one of the great achievement of my life. I am feeling very proud because this time I got it from Microsoft and also got opportunity to join the experts in the Microsoft MVP Community.

Consolidating all blog posts monthly are very refreshing as it gives me chance to go back and see what I did in last month and for readers gives the chance to see what he not followed up.

iText is a library that allows you to create and manipulate PDF documents. It enables developers looking to enhance web and other applications with dynamic PDF document generation and/or manipulation.

Another easy but interesting stuff I found today on http://in.jagran.yahoo.com/epaper/ (Hindi Language e-News Paper) and decided to develop it on my PC. If you open Google and search by typing “Image Map in HTML” you will get huge response and you can start learning this from there but here I got something different for you. I will take the advantage of jQuery Library for this. I’ll start discussion from very basic. Wanna see how? Let’s begin.

I know it is very easy for all, think of me as blogging addicted guy. Ehehe. Shortcut Keys:- Format Entire Document : Ctrl + K, Ctrl + D Format Selection : Ctrl + K, Ctrl + F

Introduction In this quick post you are going to learn how to bind the data to DropDownList and ListBox controls in ASP.NET. I know this is very easy but today a novice ASP.NET guy who is my friend on Facebook asked this to me and I created this solution for him.

Introduction You can merge two or more DataSet objects that have largely similar schemas to present in the same Data Container. In my case, I have two different database tables and I am wishing to display all records from both tables in a single Data Container. For this we can take the advantage of Merge() method in C#.

System.Data.SqlClient.SqlException: Cannot open database "Northwind" requested by the login.  The login failed.  Login failed for user 'IIS APPPOOL\DefaultAppPool'. In this quick post you will learn how to fix this issue. Today in the morning when I was executing one of my web applications I fall in titled error and the same I’m sharing, that how I fixed this.

Today I watched a very nice set of videos “Advanced Web Debugging with Fiddler Videos” captured at Microsoft MIX10 and the session by Eric Lawrence (Program Manager, Internet Explorer). I would like to share these videos with you.

Today when I uninstalled the Windows 8 Consumer Preview OS to install newly released Windows 8 Release Preview version OS and when I started using this OS I realized keyboard my responding very-very slow. I checked my keyboard connections and even replaced the keyboard by USB version but no use. After huge googling I found the solution that worked for me and the same I'm sharing this here.

In this post you are going to learn all about jQuery Accordion Widget. jQuery Accordion Widget is a jQuery based expandable and collapsable content holder that is broken into sections and probably looks like tabs. Look at the animated screen given below:

If you think of current web application development trend then this solution will not fit for you, because this scenario post-backs complete web page. Today, we have many controls that update any defined section of website (web page) instead of whole web page gets post-back.

Friends, I am running 3 Facebook Groups for all our technical discussions. You can share the blog links or ask your technical difficulties or even share your views about technology etc. Please join the group and start exploring technologies. Windows Phone (WP) ASP.NET MVC C# Thanks.

Top 500 Only, use search box (top-right corner) or post list or technology cloud to find more.

Today I watched a very nice video “How to put website is under maintenance by using App_offline.htm” by Shivprasad Koirala and the same I am sharing this with you.  

To open “IIS Manager” on Windows 7 or earlier OS, we were typed “inetmgr” in run window. But for a while I got confused that how I open “IIS Manager” in my Windows 8 PC? Here is the step.