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';
            }
            else {
                columnvisible += '0';
            }
        }
        alert(columnvisible);
    });

table.colReorder.order() -  this will return the ordering of columns

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

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

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

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 
   

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');
            }
        }
    })

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!