Sitecore, Asp.Net,C#, SQL Server

Posts

Fileupload using AngularJS in asp.net c#

Fileupload using AngularJS in asp.net c# AngularJS built-in ng-model directive. I added an attribute called ng-files in to the file input element. Now, I need to create a directive in the controller matching with the attribute The attribute has a function named getTheFiles() with a parameter $files . I’ll initialize the parameter $files in my directive and later call the function getTheFiles() using the controller’s scope, along with $files parameter. <!DOCTYPE html> <html> <head> <title>AngularJS File Upoad Example with $http and FormData</title> <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.4.4/angular.min.js"></script> </head> <body ng-app="fupApp"> <div ng-controller="fupController"> <input type="file" id="file1" name="file" multiple ...

How to Create XML File in asp.net C# ?

How to Create XML File in asp.net C# ? Create XML file in c# asp.net . If you want to write xml file in c# code behind file of asp.net web application and pass data to write it into XML file . Use using System.Xml; using ( XmlWriter xWr = XmlWriter .Create(Server.MapPath( "MailMessage.xml" ))) { xWr.WriteStartDocument(); xWr.WriteStartElement( "Library" ); xWr.WriteStartElement( "List" ); xW...

Method Chaining

angular.module("myModule",[]).controller("myController",function($scope) { //Method chaining $scope.message="Angular JS Tutorial"; });

Creating The Controller And Registering With The Module All Done In Single Line

var myApp=angular.module("myModule",[]) //Create The Module myApp.controller("myController",function($scope) { //Creating The Controller And Registering With The Module All Done In Single Line $scope.message="Angular JS Tutorial";

How to Register The Controller With The Module ?

var myApp=angular.module("myModule",[]) //Create The Module var myController=function($scope) { // Create The Controller $scope.message="Angular JS Tutorial"; myApp.controller("myController",myController); // Register The Controller With The Module

How to do partition of table in sql server

CREATE PARTITION FUNCTION myDateRangePF (datetime) AS RANGE RIGHT FOR VALUES ('20110101', '20120101','20130101') GO CREATE PARTITION SCHEME myPartitionScheme AS PARTITION myDateRangePF ALL TO ([PRIMARY]) ALTER TABLE dbo.TABLE1 DROP CONSTRAINT PK_TABLE1 GO ALTER TABLE dbo.TABLE1 ADD CONSTRAINT PK_TABLE1 PRIMARY KEY NONCLUSTERED (pkcol) WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO CREATE CLUSTERED INDEX IX_TABLE1_partitioncol ON dbo.TABLE1 (partitioncol) WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON myPartitionScheme(partitioncol)

How to get last identity value after inserted in table of sql server ? or How to use scope identity in sql server ?

SCOPE_IDENTITY in sql server It returns the last identity value which is just inserted into an identity column. It returns value only if it in same scope. using (var conn = new SqlConnection(ConnectionString)) { int ID; var cmd = "INSERT INTO foo (column_name)VALUES (@data);SELECT CAST(scope_identity() AS int)"; using (var insertCom = new SqlCommand(cmd, conn)) { insertCom.Parameters.AddWithValue("@data", "Shashi Keshar"); conn.Open(); ID = (int)insertCom.ExecuteScalar(); } }

Multilevel Inheritance in C#

Example of Multilevel Inheritance in C# using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Test { class Program { static void Main( string [] args) { b bb = new c (); Console .ReadKey(); } } class a { public a() { Console .WriteLine( "I am a" ); } } class b : a { ...