▼
Thursday, 15 March 2018

MVC asp.net Multi Level Menu Bind

›
Model: public class M_MenuModel     {         #region Variable         public Int32   MMID { get; set; }         public string MM_N...
Friday, 9 March 2018

Update a table using JOIN in SQL Server

›
UPDATE  t1   SET  t1.TID = t2.DOID   FROM  dbo.Table1  AS  t1   INNER   JOIN  dbo.Table2  AS  t2   ON  t1.CommonField = t2.[Common Fie...
Saturday, 3 March 2018

Populate (Bind) DropDownList using AngularJS AJAX and JSON

›
Angular JS  var AnguarModule = angular.module('CMS', []); AnguarModule.controller('DashBoard', function ($scope, $http, ...
Wednesday, 31 January 2018

SQL CharIndex Example

›
DECLARE  @PW_MPID NVARCHAR( max )   set  @PW_MPID= '1555|2555|35|'       DECLARE  @PW_MPIDPostion  Varchar ( max ) = CHARINDEX(...
Tuesday, 30 January 2018

ROLES AND RESPONSIBILITIES

›
Sr .Net Developer Responsibilities and Duties If you are considering a job as Sr .Net Developer here is a list of the most standard respo...
Monday, 15 January 2018

SQL Server: Make all UPPER case to Proper Case/Title Case

›
CREATE FUNCTION [dbo].[fnConvert_TitleCase] (@InputString VARCHAR(4000) ) RETURNS VARCHAR(4000) AS BEGIN DECLARE @Index INT DECLARE @C...
Friday, 12 January 2018

Using WebGet and WebInvoke with example

›
Using WebGet and WebInvoke Services can be exposed using the WebHttpBinding binding using either the WebGet or WebInvoke attributes. Each ...