Tuesday, January 28, 2020

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:

  1. var one = 1;
  2. var one_again = 1;
  3. var one_string = "1"; // note: this is string
  4. console.log(one == one_again); // true
  5. console.log(one === one_again); // true
  6. console.log(one == one_string); // true. See below for explanation.
  7. console.log(one === one_string); // false. See below for explanation

Wednesday, January 15, 2020

System.InvalidCastException: 'Unable to cast object of type 'System.Net.FileWebRequest' to type 'System.Net.HttpWebRequest'

System.InvalidCastException: 'Unable to cast object of type 'System.Net.FileWebRequest' to type 'System.Net.HttpWebRequest'

 The error because the URL is not proper. please pass the proper url containing http:// or https://.

and also check that URL is correct.

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:
  1. Start the Command Prompt
  2. Run the below command  

sqlcmd -S DatabaseServer -d Database -i C:\Users\Administrator\Downloads\script.sql -x


Tuesday, January 14, 2020

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.
     


Monday, January 13, 2020

How to Update Private Nameserver / Child Nameserver in BigRock?

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


Tuesday, October 22, 2019

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_Load .

Page.Form.Attributes.Add("enctype", "multipart/form-data");


DataTable.js, Change the Color of Row based on the Cell Value

DataTable.js, Change the Color of Row based on the Cell Value


Suppose you wants to change the color of Table Row on the bases of column value, then we have to use rowCallback as the below code

rowCallback: function (row, data, index) {
            if (data[3] ==="some value") {
                $(row).css('color', 'red');
            }           
        }

This code should be used like the below:

var table = $('#TableName').DataTable({
        'paging': true,
        'lengthChange': true,
        'searching': true,
        'ordering': true,
        'info': true,
        'autoWidth': false,
        'ajax': 'JsonData.json',
        'columnDefs': [{
            'targets': -1,
            'data': null,
            'defaultContent': 'html">'
        }],
        dom: 'Bfrtip',
        buttons: [{
            extend: 'colvis',
            text: 'Hide/Show Columns',
            columnText: function (dt, idx, title) {
                return (idx + 1) + ': ' + title;
            }
        }],
        rowCallback: function (row, data, index) {
           if (data[3] ==="some value")  {
                $(row).css('color', 'red');
            }
        }
    })

Sunday, September 29, 2019

Why is my website URL blocked on Facebook? How can I unblock it?

Why is my website URL blocked on Facebook? How can I unblock it?


My website link was blocked by the facebook and i have review my website at debugging/feedback/reporting tools and got the below message

We can’t review this website because the content doesn’t meet our Community Standards. If you think this is a mistake, please let us know.

And we were 100% certain that we were not violating any “community standards” but still, every effort returned the same message as above.

Solution

i have contacted facebook support and facebook support unblock my website, So, please reach the live support  by take these easy steps:


  1. visit Facebook for businesses
  2. click on support on the top right corner
  3. scroll down a bit until you come across “Find answers or contact support” and click on “Get Started”
  4. choose business pages
  5. scroll all the way down to the bottom and click on “Chat with a representative”
  6. and finally, describe your problem by choosing some predefined fields and hit “Start Chat”.
  7. When I finally got to chat with a representative he told me that there was no obvious problem on his end which was quite relieving. He also told me that he would pass on the issue to the “team” to look into this and that he would contact me by phone or email in case they needed anything.


Live support will resolve my problem in 72 hours. thanks to facebook support team.

Hope you find this post useful.

Visual Studio - Attempted to access an unloaded AppDomain

Attempted to access an unloaded AppDomain

Solution

If this error comes with VS follow these steps

Just restart your VS.

  1. Start VS again
  2. Clean the solution (Build> Clean Solution)
  3. Rebuild your project again
  4. If this error comes with IIS


Restart (recycle) the IIS Application Pools in IIS Manager, After restarting check run the solution again!

bootstrap, Modal - How to get Bootstrap Modal's invoke or source element?

How to get Bootstrap Modal invoke or source element?

$('#your-modal').on('show.bs.modal', function (e) {
  var $invoker = $(e.relatedTarget);
});

Various events of modal popup are:


  1. show.bs.modal: fired just before the modal is open.
  2. shown.bs.modal: fired after the modal is shown.
  3. hide.bs.modal: fired just before the modal is hidden.
  4. hidden.bs.modal: fired after the modal is closed.

How to open a Bootstrap modal window using jQuery?


$('#myModal').modal('show') // initializes and invokes show immediately

Bootstrap has a few functions that can be called manually on modals:

$('#myModal').modal('toggle');

You can check more documentation here
https://getbootstrap.com/docs/3.4/javascript/

$('#myModal').modal('show');
$('#myModal').modal('hide');