admin, Author at Coding Sharp

Author: admin

Site Admin is a writer of http://www.codingsharp.com website. He is a software professional with hands on 4+ years of experience. Generally he writes an article about Javascript, SQL Server and JQuery. Here he shares his notes, experiences, examples.

Explore the SQL Server Cursors basics

SQL Server
Cursor is the database object in MS SQL Server to retrieve the data from the result set one row at a time either in backward direction or forward direction. Generally in T-SQL command it will direct operates on all the rows of result at one time, so when ever we want to process based on the condition 1 by 1 for our process or data is dependent on the previous actions cursor is the suitable feature to use. Now lets see the Life cycle of the cursor as below Declare the cursor Like any other object we need to declare the cursor first, we can declare the cursor by defininf SQL statement which returs a result set. Open the cursor Once cursor is declared we can open and populate by executing the SQL statement defined in the cursors. Fetch records one by one from the Cursor One cursor is...
Serialization & Deserialization using JSON In C#

Serialization & Deserialization using JSON In C#

Asp.Net, C#.Net, JSON
Introduction The very useful method of converting JSON object to .Net object and .Net object to Json object is using the JsonConvert. It converts Json objects to .Net object and with the Same property with value and .Net objects to equivalent JSON object. In this article we will see how to serialize .NET type objects into JSON object and then deserialize data in the JSON format back into .NET types using the JsonConvert class. What is JSON? JSON (JavaScript Object Notation) is one lightweight and efficient data exchange format or we can say like JSON is most desirable data encoding format which allows fast exchanges of small amounts of data between client browsers and web services or web api. JsonConvert JsonConvert class is in the namespace "Newtonsoft.Json" and for this...
Easiest way to find row count of each tables in a MS-SQL Database using  Queries

Easiest way to find row count of each tables in a MS-SQL Database using Queries

SQL Server
Introduction I was working in a project where I need to compare my Production database and Staging database each time I upload code to the production server. Being developer it is tedious task to check manually for each table in source and target database as it is taking more time. Using script/query which can get the number of rows from all the tables in selected database can be really effective. So I was thinkg to check it using query where we can run the query again each database and it returns name of the table and number of rows for each table. I have prepared a script for that and now let me share that query with my blog readers in this article. In SQL Server there are tables called sys.tables, sys.sysindexes and many others like this, which stores table related data and all...

Process with an ID #### is not running in visual studio community edition 2015

Special Posts
Today I was working on a project and my team member has push the changes to repository first time and I get the latest from git. When I tried to run the project I get an error like "Process with an ID #### is not running". It's showing Id number different every time. If I check the error window It showing me an error like below "The program '[3148] iisexpress.exe' has exited with code -1073741816 (0xc0000008) 'An invalid handle was specified'." In browser it's shows me message like "The webpage is not available." I have tried different different solutions and check but non of them fixed my issue. After googling I found some different different solution and finally 1 solution worked for me. So let me show you how to resolve that issues in visual studio. Solution 1. Cl...
Explore the Use of System.Environment Class

Explore the Use of System.Environment Class

Asp.Net, Asp.Net MVC, C# Interview, C#.Net
System.Environment class can not be inherited. It provides valuable information about current platform and environment of the system. It uses to retrieve environment variable settings, version of the CLR and call stack contents etc. It has various methods and property to get the useful information about current working environment. Lets have a look on some of most used properties. Get the Machine Name - To Get the current system's machine name we can use MachineName property of Environment class. For example : Console.WriteLine("Machine Name :" + Environment.MachineName); Get the Current Working Directory - To Get the current working directory we can use CurrentDirectory property of Environment class. For example : Console.WriteLine("Current Directory :" + Environme...
What is the Difference between Build, Rebuild and Clean in Visual Studio?

What is the Difference between Build, Rebuild and Clean in Visual Studio?

Asp.Net, Asp.Net MVC, C# Interview, C#.Net, Difference
If you are a Microsoft Asp.Net Developer then usually you came across this words like Build, Rebuild and Clean. This article gives you explanation about Difference between Build, Rebuild and Clean If you are using Visual studio you might have question that what is difference between Build, Rebuild and Clean ? here we are going to understand the diversity between them. Build Solution : When we build any solution then Visual studio will build/compile all assemblies (Dlls and EXE's) that are changed, it is basically incremental or partial process in which only CHANGED assemblies are compiled if there is no changed assemblies it won't get build Rebuild Solution: It is full compiled case, in which all assemblies (either changed or not) are deleted and recompiled again, irrespect...
Difference between .Net DLL and Normal DLL file

Difference between .Net DLL and Normal DLL file

Asp.Net, Asp.Net MVC, C# Interview, C#.Net, Difference
DLL is stands for Dynamic Link Library. DLL is a file format which holds multiple codes and procedures for windows applications. Generally DLL files are created so that multiple application can use it at the same time. It has common code which may be used by multiple programs so it can reduce the disk space, load faster and consume less memory. DLLs can be converted to static libraries by using MSIL (Microsoft Intermediate Language) diassempler. It is very similar to .EXE file but it can not be execute directly like EXE, but holds same information like code, data and resources. What is .NET dll file? When we create a .NET DLL or Assemply in .Net Languages like VB.Net or C#.Net it will create a Managed Assembly. Managed Assembly is the component standard specified by Microsoft .Net. S...
What are the Differences between the Debug class and Trace class?

What are the Differences between the Debug class and Trace class?

Asp.Net, Asp.Net MVC, C# Interview, C#.Net, Difference
Debug and Trace both classes are included in Systems.Diagnostics namespace and have very similar methods. The main difference is that call to Debug class is included in Debug mode only while call to Trace class will be included in Debug as well as Release mode also. So in short we can say it is advisable to use Debug at the time of application development, while Trace option is used at the time of application deployment, like we can trace any error and write it into log files etc. What is the differences between a Debug and Release build? When we are building any .Net project there are two configuration we can select 1 is Debug and another is for Release, While we are developing an application default mode is Debug and programmers keeps is Debug mode for debugging code step by ste...
C# interview question answers

C# interview question answers

C# Interview
Q-1: Which of the following statement is true? a. try block must be followed by catch and finally block both. b. try block must be followed by catch or finally block or both. c. try block cannot include another try block. d. All of the above. Correct Answer: (b) try block must be followed by catch or finally block or both. Q-2: Which of the following datatype can be used with enum? a. Int b. String c. Boolean 4. All of the above Correct Answer: (a) Int Q-3: A partial class allows ________ a. Implementation of single class in multiple .cs files. b. Declaration of multiple classes in a single .cs file. c. Implementation of multiple interfaces to single class. d. Multiple class inheritance. Correct Answer: (a) Implementation of single class in multiple .cs files. ...
XmlDocument class

XmlDocument class

Asp.Net, C#.Net
In the previous article we have seen how to write an XML file using XmlWriter class, in this article we will see how to write an XML file using XmlDocument class. Both are writing the XML file only, however when we want to update an existing XML file then XmlDocument class will be easy to use. Because XmlWriter class will use higher memory consumption. Now look at the below sample code Above code will produce below output As we can see, first we have created an object of XmlDocument class. It will be used to create new element and new attribute both using the CreateElement() and CreateAttribute() methods. Each time we will do the same process, what I mean here is if we want to create 3 nodes in the root element developers then we will do use document object 3 times to cre...