how to run sql script from command prompt in sql server window

Just type in cmd prompt following command . Please change servername\instanceName with your original Database server name and file location before running this script. 

 sqlcmd -S ServerName\InstanceName -i E:\31october\demo.sql

the type or namespace webget could not be found

In "project properties" make sure your "target framework" is set to : .NET Framework 4

and not: .NET Framework 4 Client Profile, or any lower .NET version.

You need to reference the System.ServiceModel.Web DLL.

Right-click the 'References' folder in your project and choose 'Add Reference...'. Scroll down 

to System.ServiceModel.Web and click 'OK'.

how can i check which app using port 443

Open command prompt(start -> run -> cmd) and type the following command :

C:\> netstat -aon | findstr 0.0:443
Last column of the output is the PID of the application using port 443.

You can find the application name in Task Manager. Go to Process Tab then in Menu Bar of Task Manager go to View -> Select Column -> Check "PID" and press Ok. Search for the PID in the list(Click Below "Show processes from all users" in case if you don't find the PID)

For installing and uninstalling any service

InstallUtil.exe E:\31october\SP\WS-Export\WS-Export\bin\Debug\WS-Export.exe



InstallUtil.exe/u  E:\31october\SP\WS-Export\WS-Export\bin\Debug\WS-Export.exe

get selected dropdown value using jquery

                Please Select One                Semi-Weekly                Monthly                Quarterly            

$('#ddlSDIDepositSchedule').change(function () {
    alert($("#ddlSDIDepositSchedule").val());
});

http://jsfiddle.net/rahularyansharma/KSwcd/ 

how to make collapsable region in js file

http://blog.devarchive.net/2008/04/using-region-directive-with-javascript.html


http://visualstudiogallery.msdn.microsoft.com/872d27ee-38c7-4a97-98dc-0d8a431cc2ed?SRC=VSIDE



http://visualstudiogallery.msdn.microsoft.com/0696ad60-1c68-4b2a-9646-4b5f4f8f2e06

nesting of computed properties in knockoutjs

I am trying to use one computed properties into another computed properties which use toUpperCase function to show string in UPPERCASE .


so here is my HTML

<p><input data-bind="value: firstName"></p>

<p><input data-bind="value: lastName"></p>

<p><input data-bind="value: fullName"></p>

<p> <span data-bind="text: upperFullName"> </span> </p>

And ViewModel is as follow : 

 function AppViewModel() {

    var self = this; 
    self.firstName = ko.observable('rahul');
    self.lastName = ko.observable('sharma');
    self.fullName = ko.computed(function() {
      return self.firstName() +' ' + self.lastName();
    });
    self.upperFullName = ko.computed(function() {
      return self.fullName().toUpperCase();
    });  
}
// Activates knockout.js
ko.applyBindings(new AppViewModel()); 

JS FIDDLE LINK