Mohd Azharuddin Ansari

SQL Server In a glance Data manipulation Language (DML) – Insert/Update/Delete/Select Data Dynamic Language (DDL) – Create/Alter/Drop/Truncate Data Control Language (DCL) – Grant/Revoke Dynamic Management View (DMV) – Server State/Monitor health of system Transactional Control Language (TCL) – Commit/Rollback ACID Properties A – Atomicity – All or no transaction C – Consistency – Move a transaction from one state to another I - Isolation – Keep transaction separate D – Durability – Make sure no data lost Keys Primary Key – Uniquely identifying each row in a table Foreign Key – It is used to generate the relationship between the tables. Composite/Compound Key –key that consist of two or more columns that uniquely identify rows in a table. Unique Key - Uniquely identifying a row in a table. It can also store Null values Candidate Key – key that consist of two or more columns that uniquely identify rows in a table and one key chosen as primary key....

Open Dialog Box from Server side code If your requirement is to open a dialog box from the code behind, this post will help you in this. Mainly we need this when we are performing the validation on server side and wants to open the error messages in dialog box. Follow the below steps to implement this in your web application Step 1 – Prerequisite                 Jquery CDN < script   type ="text/javascript"   src ="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></ script > < script   src ="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.9/jquery-ui.js"   type ="text/javascript"></ script > Step 2 – Html Code             < div id ="dialog" title ="Warning" style =" display :none;">                 ...

Add Item to SharePoint List with attachment using client object model If your requirement is to add the item to a SharePoint list with attachment using the client object model, this post will help you in this. You can achieve this by following the below steps.   Step 1 – Define some constant variables those will hold the values of SharePoint web service, List Id, etc. private const string siteUrl = "http://appsuat.portal.intranet.aegonuk.com/sites/genapps/CashFlowsCashPositions" ;         private const string spWebServiceUrl = "http://appsuat.portal.intranet.aegonuk.com/sites/genapps/CashFlowsCashPositions/_vti_bin/Lists.asmx" ;         private const string updateSOAPAction = "http://schemas.microsoft.com/sharepoint/soap/UpdateListItems" ;         private const string addAttachSOAPAction = "http://schemas.microsoft.com/sharepoint/soap/AddAtta...

ASP.Net MVC with Mongo DB If your plan is to use the MongoDB as a database in your next project or you want to learn how to perform CRUD operation in MongoDB using the ASP.Net MVC, so this article is going to help you in this. In this example I am going to user the MVC 4.0 and MongoDB 3.6.1. Prerequisite – Before we jump on the coding, we need to install below software’s on development machine.                 MongoDB 3.6.1 (Or the latest version)                 MongoDB Compass Community (GUI for MongoDB) Let’s get started Step 1 – Create a new MVC project Step 2 – Add the MongoDB driver using the NuGet. Just search for MongocsharpDriver and it find the driver for you. Step 3 – Install MongoDB on your machine Step 4 – Make sure that “Data” folder is created on th...