Articles (2163) - Page 1

Articles posted by registered members of DotNetFunda.com. You can also post an article and win monthly prizes as well as gain community credit points.

2163 records found.
 
Rajnilari2015
Tips to write a better TSQL Query for enhancing the performance of Stored Procedure - Part II 
Last updated on: 03 Feb 2016 03:41:17 AM by Rajnilari2015 | Views: 535 | Category: Sql Server |
Votes: 2 | Rating: 5 out of 5
This is a series of article that will guide us how to write a better TSql query for enhancing the performance of Stored Procedure.This is the Part II of the series.In this series we will address the problems that a WHILE LOOP (AKA Pseudo Cursor) and a CURSOR pose and also a SET BASED approach as how to overcome them with pratical example will be demonstrated.
Rajnilari2015
Tips to write a better TSQL Query for enhancing the performance of Stored Procedure - Part I 
Last updated on: 03 Feb 2016 03:36:08 AM by Rajnilari2015 | Views: 471 | Category: Sql Server |
Votes: 2 | Rating: 4.5 out of 5
Many times it so happens that we write a query but that is not optimized and henceforth it takes a long time to get execute. This is a series of posts that will address various problems of bad way of writing a TSQL program and what is the suggested way of writing which on the other hand will boost the query performance.
SheoNarayan
Frequently used LINQ Extension methods 
Last updated on: 31 Jan 2016 10:11:13 PM by SheoNarayan | Views: 32262 | Category: LINQ |
Votes: 6 | Rating: 5 out of 5
In this article, I shall show how to use frequently used LINQ extension methods. In order to work with LINQ we need to use from System.Linq namespace.
Rajnilari2015
Find values from outside braces using T-SQL and XQuery 
Last updated on: 12 Jan 2016 10:25:08 PM by Rajnilari2015 | Views: 586 | Category: Sql Server |
Votes: 2 | Rating: 4.5 out of 5
Suppose we have a text like "Hello!!!This is text1 (text1).This is text2(text2).This is text3(text3) and text4(text4)".And the objective is to figure out the value outside the brackets [ ( and ) ].In this article, we will look into one of the techniques as how can we achieve this.
Rajnilari2015
Reading Excel and CSV file using LinqToExcel 
Last updated on: 11 Jan 2016 07:11:02 AM by Rajnilari2015 | Views: 700 | Category: C# |
Votes: 1 | Rating: 5 out of 5
Linq to Excel is a open source .Net library that allows us to query Excel spreadsheets or CSV files using the LINQ way. The project was created by Paul Yoder. In this article, we will look into reading an Excel spreadsheets and a CSV file using Linq to Excel project.
Rajnilari2015
Understanding Code Coverage in Visual Studio Premium 2013 
Last updated on: 08 Jan 2016 08:19:13 AM by Rajnilari2015 | Views: 3532 | Category: C# |
Votes: 2 | Rating: 5 out of 5
In this article, we will look into various aspects of Code Coverage in Visual Studio Premium 2013 with a case study.
Vuyiswamb
Coding Android applications Part 3 
Last updated on: 08 Jan 2016 05:08:47 AM by Vuyiswamb | Views: 536 | Category: Android |
Now that we understand the basics of the IDE Eclipse, we should understand the file structure that is presented to us. A .NET Developer will notice that the file structure is somehow complex as compared to what one is used to.
  • Vuyiswamb
    Developing Android applications Part 2 
    Last updated on: 06 Jan 2016 05:20:29 AM by Vuyiswamb | Views: 623 | Category: Mobile Development |
    Votes: 2 | Rating: 5 out of 5
    After setting up your environment, your fingers might be itchy to start writing code. Hold on there, it is not yet time, Lets take a tour of the IDE itself. You will not see code in this Part 2.
    Vuyiswamb
    Developing Android applications Part 1 
    Last updated on: 06 Jan 2016 03:36:15 AM by Vuyiswamb | Views: 602 | Category: Mobile Development |
    The world has been moving towards mobile and it will be naive of a developer not to acquire skills to develop mobile applications. The most simple and common mobile applications are done in Android. Three of out five uses an android phone. This article and the series concentrate on Android development to a point of publication.
    Questpond
    Learn MSBI Step by Step Part 1 (Installation) 
    Last updated on: 05 Jan 2016 02:55:16 AM by Questpond | Views: 1460 | Category: Sql Server |
    Votes: 2 | Rating: 5 out of 5
    In this article we will learn SQL Server MSBI Step by step.
    Ranjancse
    Beginners Guide to Underscore.JS 
    Last updated on: 03 Jan 2016 08:04:21 PM by Ranjancse | Views: 403 | Category: JavaScript |
    Votes: 2 | Rating: 5 out of 5
    This article is targeted for beginners in learning and using the features of underscore.js javascript library.
    Rajnilari2015
    Extract Text from Image using Tesseract in C# 
    Last updated on: 02 Jan 2016 07:28:24 PM by Rajnilari2015 | Views: 731 | Category: C# |
    Votes: 2 | Rating: 5 out of 5
    This article will present us a way of extracting data from image file using Tesseract in C#.NET.
    Rajnilari2015
    Ascii Sort on a Collection in C# 
    Last updated on: 02 Jan 2016 08:28:56 AM by Rajnilari2015 | Views: 453 | Category: C# |
    Votes: 1 | Rating: 5 out of 5
    In this article, we will look into making ASCII Sort on a Collection in C# using LINQ.
    Panthmadan
    Create a simple ASP.NET MVC Project (Part 3) Validations 
    Last updated on: 02 Jan 2016 12:13:56 AM by Panthmadan | Views: 800 | Category: ASP.NET MVC |
    Votes: 1 | Rating: 4 out of 5
    In this article will create a simple ASP.NET MVC Project.
    Rajnilari2015
    Jquery Show/Hide example 
    Last updated on: 01 Jan 2016 11:57:35 PM by Rajnilari2015 | Views: 455 | Category: jQuery |
    This article will demonstrate a way of Jquery Show/Hide.