The author of Blog.Joggee is the same person of the Rana Blog in the codeproject.wordpress.com. The reason why this new blog was created because Rana wanted to share more diverse range of services such as the latest technology, variation of ideas and universal advice in more user friendly and customizable way.Join and become a part of an international community dedicated to excellence, service and knowledge creation.

Browse by Tags

All Tags » Tips and tricks » ASP.NET   (RSS)

• C#.NET
• Database
• Excel
• Microsoft
• MySQL
• PHP
• Project Management
• Queries
• SharePoint
• SQL SERVER
• Stored Procedures
• VB.NET
• Visio
• Webservice

• SQL SERVER - UDF - User Defined Function - Get Number of Days in Month

  User Defined Function returns the numbers of days in month. It is very simple yet very powerful and full proof UDF. CREATE FUNCTION [dbo] . [udf_GetNumDaysInMonth] ( @myDateTime DATETIME ) RETURNS INT AS BEGIN DECLARE @rtDate INT ......... http://blog.joggee.com/?p=51 Read More... Posted Wednesday, July 09, 2008 2:26 PM by joggee | 2 Comments Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• Stephen Forte's Database Training

  Last June 19, 2007, at the Pearl Continental Hotel here in Lahore, I attended the Pakistan Developer Conference 2007. The speaker was Stephen Forte . He had shared the latest Database Training techniques on SQL Server 2005 and I would like to share these Read More... Posted Wednesday, July 09, 2008 2:24 PM by joggee | (Comments Off) Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• SQL Server 2005- How to prevent Execution - Goto (T-SQL)

  I am familiar with Goto Command since i was using Visual Basic 6.0. I wanted to prevent or bypass the execution in a stored procedure and i used the same command in Sql Server 2005. Some details:................ http://blog.joggee.com/?p=49 Share this Read More... Posted Wednesday, July 09, 2008 2:20 PM by joggee | 1 Comments Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• New Feature in VB.NET 2005 - The Continue Statement,Next iteration

  If i feel this will help others i posted. The Continue statement skips the remaining statements in the loop body of a repetition statement and causes control to proceed to the next iteration of the loop. Code example for Visual Studio 2005 May 2004 Community Read More... Posted Wednesday, July 09, 2008 2:14 PM by joggee | 1 Comments Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• ASP.NET - How to get current webpage name.

  Here is the single line of code for getting current webpage name. Dim pag As String.................... http://blog.joggee.com/?p=66 Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Sponsor Read More... Posted Wednesday, July 09, 2008 2:11 PM by joggee | 2 Comments Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• SQL Server 2005 - How to shrink the truncated log file.

  To shrink the Trucated Log file. Following code always shrinks the Trucated Log File to minimum size possible. USE Master --You can replace with the database name but if it doesnt --works then replace with master databas)..... http://blog.joggee.com/?p=65 Read More... Posted Wednesday, July 09, 2008 2:05 PM by joggee | (Comments Off) Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• Javascript - Display alternate message in textbox

  You can set timeout as your wish. ———————————————————————- <html> <script language="JavaScript" Read More... Posted Wednesday, July 09, 2008 1:55 PM by joggee | (Comments Off) Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• Sql Server Tips - Removing or Replacing non-alphanumeric characters in strings

  –Create a table with all bad codes DECLARE @mycode INT CREATE TABLE #badcodes ( badcode INT ) SET @mycode = 33 WHILE @mycode <= 255 ....................... http://blog.joggee.com/?p=52 Share this post: email it! | bookmark it! | digg it! | reddit! Read More... Posted Wednesday, July 09, 2008 1:45 PM by joggee | 1 Comments Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• SQL SERVER 2005 , How to Partition the table.

  All we know SQL Server 2005 has new features are going to discuss in this article is the Row Number function and Partitioning. Normally developers used temporary tables and co-related sub-queries to generate calculated row numbers in a query. Now SQL Read More... Posted Wednesday, July 09, 2008 1:34 PM by joggee | 1 Comments Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• SQL SERVER 2005 - What is NULLIF ?

  Returns a null value. NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression. .......... http://blog.joggee.com/?p=57 Share this post: email Read More... Posted Wednesday, July 09, 2008 1:29 PM by joggee | (Comments Off) Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• ASP.Net 2005 - How to Restore all the break point

  So many friends ask me is there any way to clear all the break point and restore them In Visual Studio there are builtin functionality where by you can enable all the break point and disable all the break point.......... http://blog.joggee.com/?p=27 Share Read More... Posted Wednesday, July 09, 2008 1:26 PM by joggee | 1 Comments Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• Google searches web’s dark side

  One in 10 web pages scrutinised by search giant Google contained malicious code that could infect a user’s PC Researchers from the firm surveyed billions of sites, subjecting 4.5 million pages to “in-depth analysis”. .......... http://blog.joggee.com/?p=31 Read More... Posted Wednesday, July 09, 2008 1:11 PM by joggee | (Comments Off) Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• ASP.NET - Format datagrid columns.

  There are two ways to modify the format of the data in a Da tagrid/GridView. One is through the design view. Right click on the Grid View / DataGrid select Property Builder and Column view, under the selected column for which you wan to set the format........ Read More... Posted Wednesday, July 09, 2008 12:38 PM by joggee | 1 Comments Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• Stephen Forte’s Database Training

  Last June 19, 2007, at the Pearl Continental Hotel here in Lahore, I attended the Pakistan Developer Conference 2007. The speaker was Stephen Forte . ........ http://blog.joggee.com/?p=34 Share this post: email it! | bookmark it! | digg it! | reddit! Read More... Posted Wednesday, July 09, 2008 12:38 PM by joggee | (Comments Off) Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER

• View as HTML

  Today i received an email from one of my blog’s reader. Dear Code project, Actually I am a Biology teacher in one of the private school. I had prepared my lesson plan in a word document and a part of the lesson was a graph diagram. I then send it Read More... Posted Wednesday, July 09, 2008 12:32 PM by joggee | (Comments Off) Filed under: ASP.NET, PHP, C#.NET, Project Management, Stored Procedures, Queries, Database, Visio, Excel, VB.NET, Tips and tricks, Microsoft, MySQL, SharePoint, Webservice, SQL SERVER