Friday, October 31, 2014

Remove sql server 2005 express tools to Install SQL Server 2008

Solution
  1. Open Run Menu and type regedit.
  2. It will open Registry Editor
  3. Now go to following location.
(32Bit) HKLM> Software > Microsoft > Microsoft SQL Server > 90

(64Bit) HKLM> Software > Wow6432Node > Microsoft > Microsoft SQL Server > 90

Remove Registry Key 90.

Move focus to next row in table on enter

$('......').keypress(function (e) {
    if (e.which == 13) {
        $(this).closest('tr').next().find('.....').select();
        return false;
    }
});

SSDT – Error SQL70001 This statement is not recognized in this context

Change the build action of the script file to None from Build

The file 'src' is not a valid here because it doesn't expose a type.

The problem may stem from
[assemblyAssemblyCulture(".....")]
in your Properties/AssemblyInfo.cs file

try removing or commenting out the line

Monday, October 20, 2014

How to Set Active Tab in jQuery Ui

<script>
    $( "#tabs" ).tabs({ selected: # });
</script>

How to create a three column table in ASP.Net Repeater

<asp:Repeater runat="server" DataSourceID="testds">
    <HeaderTemplate>
        <table class="items">
    </HeaderTemplate>
    <ItemTemplate>
        <%# (Container.ItemIndex + 3) % 3 == 0 ? "<tr>" : string.Empty%>
        <td>
            <img src='/blablabla/<%# Eval("id"%>.jpg' alt="" /></td>
        <%# (Container.ItemIndex + 3) % 3 == 2 ? "</tr>" : string.Empty%>
    </ItemTemplate>
    <FooterTemplate>
        </table>
    </FooterTemplate>
</asp:Repeater>

Wednesday, October 1, 2014

How do you kill all current connections to a SQL Server database

-- set your current connection to use master otherwise you might get an error
USE master
GO
ALTER DATABASE YourDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
GO
ALTER DATABASE YourDatabase SET MULTI_USER
GO

Unable to Log In --Cookies Are Blocked Due To Unexpected Output

Just make sure wp-config.php file is in utf-8 encoding; if not save file in utf-8 encoding

To save file in utf-8 encoding use notepad, notepad++ or equivalent editor then do a save as to save file in proper encoding