Tables without a clustered index are not supported in this version of SQL Server

CREATE UNIQUE CLUSTERED INDEX Idx_TableName ON TableName(yourGUIDColumn);

List of all Tables,views,Stored Procedure


List of all Tables

select
* from sys.objects where type='u'



List of all Stored Procedure

select
* from sys.objects where type='p'

List of all views

select
* from sys.objects where type='v'

Sent Post API and Response Message Split

  using (var client = new HttpClient())
        {
            client.BaseAddress = new Uri("https://www.onecard.net");
            var content = new FormUrlEncodedContent(new[]
            {
                new KeyValuePair<string, string>("OneCard_MerchID", OneCard_MerchID),
                new KeyValuePair<string, string>("OneCard_TransID", OneCard_TransID),
                new KeyValuePair<string, string>("OneCard_HashKey", OneCard_HashKey)
            });
            var result = client.PostAsync("/remote/paymentIntegrationQuery.html", content).Result;

            try
            {
                string[] resultItem = result.Content.ReadAsStringAsync().Result.Split('|');
                string _code = resultItem[0].Split('=')[1].ToString();
                string _message = resultItem[1].Split('=')[1].ToString();
                string _hashKey = resultItem[2].Split('=')[1].ToString();

                if (_code == "00" || _code == "18")
                {
                    Lblresult.Text = "Your transaction successfully";
                }
                else
                {
                    Lblresult.Text = _message;
                }
            }

MD5 Algorithm

public static string GetMd5Hash(MD5 md5Hash, string input)
        {

            // Convert the input string to a byte array and compute the hash.
            byte[] data = md5Hash.ComputeHash(Encoding.UTF8.GetBytes(input));

            // Create a new Stringbuilder to collect the bytes
            // and create a string.
            StringBuilder sBuilder = new StringBuilder();

            // Loop through each byte of the hashed data
            // and format each one as a hexadecimal string.
            for (int i = 0; i < data.Length; i++)
            {
                sBuilder.Append(data[i].ToString("x2"));
            }

            // Return the hexadecimal string.
            return sBuilder.ToString();
        } 

Color picker site

http://www.colorzilla.com/firefox/

http://0to255.com/

Redirect on frame checking


             if (window.parent.document.getElementsByTagName("iframe").length == 0) {
               
                 window.top.location.href="home.aspx";          
             }

Get the system date and split day, month and year

String date = DateTime.Now.Date.ToString();
    String Month = DateTime.Now.Month.ToString();
    String Year = DateTime.Now.Year.ToString();

Keyboard Shortcut

More than 100 Keyboard Shortcuts must read & Share Keyboard Shortcuts (Microsoft Windows)

1. CTRL+C (Copy)
 2. CTRL+X (Cut)
3. CTRL+V (Paste)
4. CTRL+Z (Undo)
5. DELETE (Delete)
 6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
7. CTRL while dragging an item (Copy the selected item)
 8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
 9. F2 key (Rename the selected item)
 10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
 12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
15. CTRL+A (Select all)
16. F3 key (Search for a file or a folder)
17. ALT+ENTER (View the properties for the selected item)
18. ALT+F4 (Close the active item, or quit the active program)
19. ALT+ENTER (Display the properties of the selected object)
 20. ALT+SPACEBAR (Open the shortcut menu for the active window)
21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneously)
22. ALT+TAB (Switch between the open items)
23. ALT+ESC (Cycle through items in the order that they had been opened)
 24. F6 key (Cycle through the screen elements in a window or on the desktop)
 25. F4 key (Display the Address bar list in My Computer or Windows Explorer)
 26. SHIFT+F10 (Display the shortcut menu for the selected item)
27. ALT+SPACEBAR (Display the System menu for the active window)
28. CTRL+ESC (Display the Start menu)
 29. ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command)
 30. F10 key (Activate the menu bar in the active program)
31. RIGHT ARROW (Open the next menu to the right, or open a submenu)
32. LEFT ARROW (Open the next menu to the left, or close a submenu)
33. F5 key (Update the active window)
34. BACKSPACE (View the folder onelevel up in My Computer or Windows Explorer)
35. ESC (Cancel the current task)
36. SHIFT when you insert a CD-ROMinto the CD-ROM drive (Prevent the CD-ROM from automatically playing) Dialog Box - Keyboard Shortcuts

Search This Blog

Arsip Blog

Powered by Blogger.

Recent

Comment

Author Info

Like This Theme

Popular Posts

Video Of Day

Sponsor

Most Popular