Skip to main content

Posts

Datatable.net - Get Reordering of the columns & Get Column visible

Datatable.net - Get Reordering of the columns & Get Column visible Please add a button on the form like below <a class="btn btn-success visiblecheck" href="javascript:void(0);" id="visiblecheck" value="test">visiblecheck</a> Here is 'table' is variable of Datatable.net like var table = $('#example').dataTable(); $('.visiblecheck').click( function () {         alert(table.colReorder.order() );         var columnvisible = '';         for (i = 0; i < table.columns().count(); i++) {             if (columnvisible != '') {                 columnvisible += ',';             }             if (table.column(i).visible() === true) {                 columnvisible += '1';             }  ...

whats the difference between == and === ?

The difference between == and === is that: 1. == converts the variable values to the same type before performing comparison. This is called type coercion. 2. === does not do any type conversion (coercion) and returns true only if both values and types are identical for the two variables being compared. Example: var one = 1 ; var one_again = 1 ; var one_string = "1" ; // note: this is string console . log ( one == one_again ); // true console . log ( one === one_again ); // true console . log ( one == one_string ); // true. See below for explanation. console . log ( one === one_string ); // false. See below for explanation

SQL Server - Running large Sql files

When we try to open a large Sql file in SQl Server, it's gives the error "The operation could not be completed. not enough storage is available to complete this operation The template specified cannot be found. Please check that the full path is correct" Solution: use the  sqlcmd  tool to execute the file. To execute a SQL script: Start the Command Prompt Run the below command   sqlcmd -S DatabaseServer -d Database -i C:\Users\Administrator\Downloads\script.sql -x

Error "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe"

Error "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe" Solution: This is login authenticate problem. Please check the following things: In the SQL Server Properties, please check that "SQL Server and Windows Authentication Mode" is enabled, if not enable, please enable and restart the SQL Server.   Is Login have the permission to particular Database?   This might be a firewall issue as you mentioned it only happens when security agent installed. Please make sure you have properly configured security agent to allow Database Engine Services accesses.  

How to Update Private Nameserver / Child Nameserver in BigRock?

Register and Update Private Name Servers / Child Name Servers in Big Rock Login to your Bigrock Account and Select the domain for which you would like to update the nameserver details. Click on the ‘Child Name Servers’ link. You have to provide Appropriate Host Name and its appropriate IP address Go back to the main page and select the “Name Servers” option  Now, Enter the already registered private nameservers here and update name servers 

file upload not working in updatepanel asp.net

The Fileupload Control is not working in the UpdatePanel in asp.net. To use the FileUpload control in the Updatepanel. We need to add the Post back trigger to the UpdatePanel Like the below Code < asp : UpdatePanel ID = "UpnlFileUpload" runat = "server" > < ContentTemplate > < asp : FileUpload ID = "FlUpload" runat = "server" /> < asp : Button ID = "btnFileUpload" runat = "server" Text = "Upload" OnClick = "btnFileUpload_OnClick" /> </ ContentTemplate > < Triggers > < asp : PostBackTrigger ControlID = "btnFileUpload" /> </ Triggers > </ asp : UpdatePanel > Here we need to pass the Button Control ID in the PostBackTrigger Like the above code. Generally after adding the PostBackTrigger it works accurate but some time it will not work. In this case you need to add the below code in the  Page_Lo...