Recent Articles

System.Security.SecurityException in Asp.Net

| April 23, 2013 | 0 Comments

I was trying to host Intranet website based on .Net Framework 2.0 on remote share with fewer privileges. But the web application got failed and showed exception as : Server Error in ‘/rso/intranet’ Application. Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the […]

Continue Reading

Concatenate strings in .aspx page

| November 5, 2011 | 0 Comments

Problem I am trying to set label value dynamically in .aspx page. Additionally I need to concatenate strings in the .aspx page. Solution We would need to use string.Concat() function for same. Here is solution for concatenating string values in .aspx page: Code Snippet for .aspx: Above code results in string as http://80Hello.

Continue Reading

Round corners on Image by Adobe Photoshop CS3

| December 31, 2010 | 1 Comment

You want to convert square image into round corners image by using Adobe Photoshop CS3.  There are lot of articles available on net explaining about round corners in very easy and efficient way. But I am writing this article for future reference and for rest of fresher designers who wish some easy step-by-step instructions. So […]

Continue Reading

The database ‘file.mdf’ cannot be opened because it is version 655

| December 28, 2010 | 0 Comments

Problem: This was weird & probably first problem I faced related to Sql Server version(s). I was trying to learn Asp MVC with the help of sample application MvcMusicStore. I open it in VS 2010 and debug. On debugging it throw runtime exception: System.Data.EntityException was unhandled by user code. Message=The underlying provider failed on Open. […]

Continue Reading

Apply Style to ListItem in List Controls

| December 26, 2010 | 0 Comments

We can apply CSS class or styles to our List Controls (CheckBoxList, RadioButtonList, DropDownList and ListBox). But there is no way to add or apply style to ListItem within them in .aspx. So this article deals with how to add attributes to ListItems in all ListControls. We would apply required style or attributes at runtime […]

Continue Reading

Image in TextBox & RichTextBox

| December 25, 2010 | 0 Comments

This article deals with how to show Image in TextBox and RichTextBox control. I googled for same but found little or was too complex to implement as per my understanding. Well! The noteworthy point is that in either of methods shared here uses alternative solution. There is no such direct way to do. Second thing is […]

Continue Reading

Update database from DataGridView

| December 21, 2010 | 0 Comments

Most of time developer want their users to be able to update database from DataGridView in Window Forms. So this article deals with concept of how to update tables in database from DataGridView. The main task of updating database is done with the help of System.Data.SqlClient.SqlDataAdapter.Update() method.  System.Data.SqlClient.SqlCommandBuilder generates required command for SqlDataAdapter when Select […]

Continue Reading

Modify MessageBox by MessageBoxManager

| December 18, 2010 | 0 Comments

You want to modify your default System.Windows.Forms.MessagBox look. You want to modify its fonts or its own size. In all you want to modify its appearance. And sometimes you wish to modify or change its functionality to some extent. Well … then there is some good news for you. But its not from Microsoft and […]

Continue Reading

Print integers in reverse order using LinkedLists

| December 15, 2010 | 0 Comments

Scenario: You need to make program in C that can accept numbers from user and print integers in reverse order using LinkedLists. Solution: There are three functions: Insert – Insert each number or integer into LinkedList from user. Reverse – Reverse each number in linkedlist starting from first number in linkedlist. PrintList – Print each […]

Continue Reading

Add first ten odd numbers in C

| December 15, 2010 | 0 Comments

This article demonstrates how to add first ten odd numbers in C starting from 1. I am writing this article as I was preparing assignment of SMU MCA First Semester August 2010 MC0061. So I too faced problem for that. Well … this is solution for those students.

Continue Reading

pe = 'attachment' AND ((wp_posts.post_status = 'inherit')) ORDER BY wp_posts.menu_order ASC, wp_posts.ID ASC LIMIT 0, 1 99 | 0.0007 | enabled | not cached | 3313 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (3) ORDER BY t.name ASC 100 | 0.0003 | enabled | not cached | 8026 | SELECT * FROM wp_posts WHERE ID = 59 LIMIT 1 101 | 0.0003 | enabled | not cached | 2240 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (59) ORDER BY meta_id ASC 102 | 0.0003 | enabled | not cached | 7978 | SELECT * FROM wp_posts WHERE ID = 57 LIMIT 1 103 | 0.0002 | enabled | not cached | 2037 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (57) ORDER BY meta_id ASC 104 | 0.0002 | enabled | not cached | 7971 | SELECT * FROM wp_posts WHERE ID = 56 LIMIT 1 105 | 0.0003 | enabled | not cached | 1928 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (56) ORDER BY meta_id ASC 106 | 0.0003 | enabled | not cached | 7978 | SELECT * FROM wp_posts WHERE ID = 58 LIMIT 1 107 | 0.0004 | enabled | not cached | 2037 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (58) ORDER BY meta_id ASC 108 | 0.0008 | enabled | not cached | 3313 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (4) ORDER BY t.name ASC 109 | 0.0004 | enabled | not cached | 698 | SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 4 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status = 'inherit')) ORDER BY wp_posts.menu_order ASC, wp_posts.ID ASC LIMIT 0, 1 110 | 0.0006 | enabled | not cached | 3313 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (5) ORDER BY t.name ASC 111 | 0.0005 | enabled | not cached | 3310 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (5) ORDER BY t.name ASC 112 | 0.0002 | enabled | not cached | 7984 | SELECT * FROM wp_posts WHERE ID = 63 LIMIT 1 113 | 0.0002 | enabled | not cached | 2200 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (63) ORDER BY meta_id ASC 114 | 0.0006 | enabled | not cached | 3313 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (6) ORDER BY t.name ASC 115 | 0.0005 | enabled | not cached | 3310 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (6) ORDER BY t.name ASC 116 | 0.0003 | enabled | not cached | 8020 | SELECT * FROM wp_posts WHERE ID = 71 LIMIT 1 117 | 0.0002 | enabled | not cached | 2073 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (71) ORDER BY meta_id ASC 118 | 0.0007 | enabled | not cached | 3313 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_format') AND tr.object_id IN (7) ORDER BY t.name ASC 119 | 0.0005 | enabled | not cached | 3310 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (7) ORDER BY t.name ASC 120 | 0.0003 | enabled | not cached | 8041 | SELECT * FROM wp_posts WHERE ID = 81 LIMIT 1 121 | 0.0003 | enabled | not cached | 2185 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (81) ORDER BY meta_id ASC 122 | 0.0004 | enabled | not cached | 698 | SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 9 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status = 'inherit')) ORDER BY wp_posts.menu_order ASC, wp_posts.ID ASC LIMIT 0, 1 123 | 0.0005 | enabled | not cached | 699 | SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 10 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status = 'inherit')) ORDER BY wp_posts.menu_order ASC, wp_posts.ID ASC LIMIT 0, 1 124 | 0.0004 | enabled | not cached | 699 | SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 11 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status = 'inherit')) ORDER BY wp_posts.menu_order ASC, wp_posts.ID ASC LIMIT 0, 1 125 | 0.0018 | enabled | not cached | 3107 | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid', ( SUM(v.pageviews)/(IF ( DATEDIFF('2016-05-02 17:40:10', DATE_SUB('2016-05-02 17:40:10', INTERVAL 1 WEEK)) > 0, DATEDIFF('2016-05-02 17:40:10', DATE_SUB('2016-05-02 17:40:10', INTERVAL 1 WEEK)), 1) ) ) AS 'avg_views' FROM wp_popularpostssummary v LEFT JOIN wp_posts p ON v.postid = p.ID WHERE 1 = 1 AND p.post_type IN('post','page') AND v.last_viewed > DATE_SUB('2016-05-02 17:40:10', INTERVAL 1 WEEK) AND p.post_password = '' AND p.post_status = 'publish' GROUP BY v.postid ORDER BY avg_views DESC LIMIT 5; 126 | 0.0014 | enabled | not cached | 11284 | SELECT * FROM wp_posts WHERE ID = 17 LIMIT 1 127 | 0.0004 | enabled | not cached | 10061 | SELECT * FROM wp_posts WHERE ID = 15 LIMIT 1 128 | 0.0005 | disabled (query) | not cached | 0 | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 5 129 | 0.0001 | disabled (query) | not cached | 0 | SELECT FOUND_ROWS() 130 | 0.0022 | enabled | not cached | 7307 | SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_author_email, comment_date_gmt, comment_approved, comment_type,comment_author_url, SUBSTRING(comment_content,1,100) AS com_excerpt FROM wp_comments LEFT OUTER JOIN wp_posts ON (wp_comments.comment_post_ID = wp_posts.ID) WHERE comment_approved = '1' AND comment_type = '' AND post_password = '' ORDER BY comment_date_gmt DESC LIMIT 5 131 | 0.0003 | enabled | not cached | 14705 | SELECT * FROM wp_posts WHERE ID = 42 LIMIT 1 132 | 0.0005 | enabled | not cached | 2074 | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC 133 | 0.0003 | enabled | cached | 4714 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC 134 | 0.0008 | enabled | not cached | 8853 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('post_tag') AND tt.count > 0 ORDER BY tt.count DESC LIMIT 200 135 | 0.0004 | enabled | not cached | 3470 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'nav_menu' AND t.term_id = 33 LIMIT 1 136 | 0.0003 | enabled | not cached | 946 | SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('33') ORDER BY tr.object_id ASC 137 | 0.0005 | enabled | not cached | 11910 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (231,232,234,244,289,306) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC 138 | 0.0003 | enabled | not cached | 2109 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (234) ORDER BY meta_id ASC 139 | 0.0003 | enabled | not cached | 2092 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (231) ORDER BY meta_id ASC 140 | 0.0003 | enabled | not cached | 2086 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (232) ORDER BY meta_id ASC 141 | 0.0003 | enabled | not cached | 2086 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (289) ORDER BY meta_id ASC 142 | 0.0003 | enabled | not cached | 2086 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (244) ORDER BY meta_id ASC 143 | 0.0003 | enabled | not cached | 2086 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (306) ORDER BY meta_id ASC 144 | 0.0007 | enabled | not cached | 26416 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (207,209,279,239,301) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC -->