Sunday, February 13, 2011
Multiplication trick
Thursday, February 3, 2011
Create identity to create table with data
Normally we can't create the identity in the existing column, it must be created while creating the table. Suppose if you have a data in the table you want to add the identity in the table, we can do it in indirect way as below.
Consider the table as table1 and it contain a column as column1
Now am rename the table1 as table1_new as below
sp_rename 'table1','table1_new'
Now create a new table as table1
create table table1(column1 int primary key identity(1,1))
then turn off identity
set identity_insert table1 on
Now copy all data from old table to new table as below
Now turnon the identity
set identity_insert table1 off
Find the max value of column
select MAX(column1) from table1
Reseed the identity as below
DBCC CHECKIDENT (table1, RESEED, 220);
Now you can make use of the table along with identity as before
Custom Paging API
Normally in Win Application you have Paging option is available only for moving to Next or Previous record, and move to First or Last Record. Suppose if you want to set page wise navigation then you have to go for custom paging.
In codeplex you can find CustomPaging API this is an alpha release, they provide an set of inbuild methods for Record Navigation, and page navigation. You can make use this CustomPaging API to any Application both Windows or Web Application. You can download this CustomPaging API form here [Click Here To Download]
Class Description
Available Function in dsPaging
Properties
1) NumberOfRecordPerPage
Note:- This NumberOfRecordPerPage must be specify before you call any static method from below for paging at first time. This property hold how many number of records can disply per page.
Static Methods
1) List
2) List
3) List
4) List
5) List
6) List
7 ) List
8 ) List
Note:-
Here curentgridindex:- Refer Current Select index of the grid
currentpage:- Current Page that is displayed on the grid
totalrowcount:- Total number of record that holds (Full row count and not per page row count)
rowindex:- Same as Currentgridindex.
Sample Code:
Any bug or Paging API question are always welcome.
22 Ways to Become Spectacularly Inspirational
2. Lift people up vs. tear others down.
3. Use the words of leadership vs. the language of victimhood.
4. Don’t worry about getting the credit for getting things done.
5. Become part of the solution rather than part of the problem.
6. Take your health to a level called superfit.
7. Commit to mastery of your craft instead of accepting mediocrity in your work.
8. Associate with people whose lives you want to be living.
9. Study for an hour a day. Double your learning and you’ll triple your success.
10. Run your own race. “No one can possibly achieve real and lasting success by being a conformist,” wrote billionaire J. Paul Getty
11. Do something small yet scary every single day.
12. Lead Without a Title.
13. Focus on people’s strengths vs. obsessing around their weaknesses.
14. Remember that potential unused turns into pain. So dedicate yourself to expressing your best.
15. Smile more.
16. Listen more.
17. Read the autobiography of Nelson Mandela.
18. Reflect on the words of Eleanor Roosevelt who said: “Great minds discuss ideas; Average minds discuss events; Small minds discuss people.”
19. Persist longer than the critics suggest you should.
20. Say “please” and “thank you”.
21. Love your loved ones.
22. Do work that matters.
Resource : RobinSharma
Monday, November 15, 2010
How to add new site collection in separate content database
Thursday, November 11, 2010
How can i play multiple media files in moss2007
FAQ
Access
- Access World Forum http://www.access-programmers.co.uk/forums/
- Utter Access Discussion www.utteraccess.com
AspDotNetStorefront
BizTalk
BlogEngine.NET
- http://www.blogengineforum.net/
- http://www.codeplex.com/blogengine/Thread/List.aspx
- http://www.blogengineforum.net/
Bug Reports and Suggestions for Microsoft
- Posting suggestions, bug reports etc to Microsoft at https://connect.microsoft.com/dashboard/?wa=wsignin1.0
- Visual Studio 2008 Bug Submission Form https://connect.microsoft.com/VisualStudio/feedback/CreateFeedbackForm.aspx?FeedbackFormConfigurationID=3792&FeedbackType=1
- Visual Studio 2008 Suggestion form https://connect.microsoft.com/VisualStudio/feedback/CreateFeedbackForm.aspx?FeedbackFormConfigurationID=3793&FeedbackType=2
Cassini Web Server
Cat.Net (static code checker for SQL and XSS Injection)
Cheat Sheets
CkEditor
Classic ASP
- http://forums.iis.net/1032.aspx
- http://www.sitepoint.com/forums/forumdisplay.php?f=148
- http://www.aspmessageboard.com/forumdisplay.php?s=1b5dc094ec23fdf421f86fe4e1af36f8&f=4
- http://p2p.wrox.com/asp-3-classic-asp-active-server-pages-3-0-440/
- http://groups.google.com/group/microsoft.public.inetserver.asp.general
- http://www.tek-tips.com/threadminder.cfm?pid=333
Code Converters (convert VB to C# and C# to VB)
- http://converter.telerik.com/
- http://www.developerfusion.com/tools/convert/csharp-to-vb/
- http://www.dotnetspider.com/convert/Csharp-To-Vb.aspx
Cognos
- http://www.tek-tips.com/threadminder.cfm?pid=401
- http://www.cognoise.com/main/
- http://www.bi-dw.info/cognos/forums.htm
- http://www.topix.com/forum/com/cogn
Commerce Server
ComponentArt
Cross Browser Compliance
Cruise Control
Crystal Reports
- http://www.access-programmers.co.uk/forums/forumdisplay.php?f=65
- http://www.crystalreportsbook.com/forum/default.asp
- http://www.codeguru.com/forum/forumdisplay.php?f=64
- http://www.tek-tips.com/threadminder.cfm?pid=149
CSS (Cascading Style Sheets)
- CSS Layout Techniques: for Fun and Profit http://glish.com/css/
C#
- MSDN http://forums.microsoft.com/msdn/default.aspx?siteid=1&ForumGroupID=9
- C# Corner http://www.c-sharpcorner.com/Forums/
Delphi
- For queries on Delphi see http://www.delphiforums.com/
Developer Express
Dojo
Doloto
Dot Less
Dot Net
- MSDN Dot Net forum see http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=12&SiteID=1
DotnetNuke
Dreamwaver
- http://forums.adobe.com/community/dreamweaver
- http://www.dreamweaverclub.com/forum/
- http://forums.tutorialized.com/dreamweaver-84/
- http://forums.creativecow.net/adobedreamweaver
- http://www.tek-tips.com/threadminder.cfm?pid=248
Dundas Chart
Entity Framework
Expression Web
- http://social.expression.microsoft.com/Forums/en-US/web/threads
- http://www.expression-web-designer-help.com/forum/
FckEditor - see CKEditor
FFMPEG
Firebird
Flash
- Adobe http://www.adobe.com/cfusion/webforums/forum/index.cfm?forumid=15
- Flashmove http://www.flashmove.com/board/index.php
- Flashkirt http://board.flashkit.com/board/
Foxpro
- http://www.universalthread.com/
- www.foxite.com
- http://tek-tips.com/threadminder.cfm?pid=184
- http://social.msdn.microsoft.com/Forums/en-US/visualfoxprogeneral/threads
Free Asp.Net Web Hosting
FreeTextBox
FXCOP
F#
Generic Programming Sites
GhostDoc
Git
Googlemaps
IIS and Classic Asp
- IIS http://forums.iis.net/
- IISFAQ http://www.iisfaq.com/default.aspx?tabid=2679&g=topics&f=8
- Devshed http://forums.devshed.com/iis-97/
- AspFree http://forums.aspfree.com/microsoft-iis-12/
Infragistics
Internet Explorer
- http://social.msdn.microsoft.com/Forums/en-US/category/iedevelopment
- http://social.answers.microsoft.com/Forums/en-US/InternetExplorer/threads
iTextSharp
Java
- http://forums.sun.com/forum.jspa?forumID=31
- http://www.java-forums.org/
- http://www.javaranch.com/
- http://www.javaprogrammingforums.com/
- http://www.tek-tips.com/threadminder.cfm?pid=269
jQuery
JSON
LINQ
LinqPad
Live Meeting
MBUnit
Microsoft Charting Control
Microsoft Infopath
- http://social.technet.microsoft.com/Forums/en/sharepointinfopath/threads
- http://msdn.microsoft.com/en-us/office/aa905445.aspx
- http://social.msdn.microsoft.com/forums/en-US/sharepointinfopath/threads/
- http://www.infopathdev.com/
Microsoft Office
- http://www.microsoft.com/office/community/en-us/flyoutoverview.mspx
- http://www.tek-tips.com/threadminder.cfm?pid=68
- http://community.compuserve.com/n/pfx/forum.aspx?folderId=1&listMode=13&nav=messages&webtag=ws-msoffice
- http://www.msofficeforums.com/
Microsoft Project
- http://forums.techarena.in/microsoft-project/
- Microsoft Project NewsGroups
- Microsoft Project User Group (European)
- Microsoft Project User Group (UK & International)
- http://www.tek-tips.com/threadminder.cfm?pid=913
- http://www.eng-tips.com/threadminder.cfm?pid=776
- http://forums.techarena.in/microsoft-project/
MOQ
MySQL
- http://forums.mysql.com/
- http://www.dbforums.com/mysql/
- http://www.tek-tips.com/threadminder.cfm?pid=436
- http://forums.devshed.com/forumdisplay.php?forumid=4
NANT Forum
NHbernate
NOPCommerce
- http://www.nopcommerce.com/Boards/
- http://strivingprogrammers.com/boards/f/11/nopcommerce-project.aspx
Notepad++
Open Source Projects and Libraries
Oracle
- http://www.dba-oracle.com/oracle_forum.htm
- http://forums.oracle.com/forums/category.jspa?categoryID=13
- http://www.dba-oracle.com/oracle_forum.htm
Pex
PHP
- http://forums.devnetwork.net/
- http://www.phpfreaks.com/
- http://phpbuilder.com/board/
- http://www.sitepoint.com/forums/forumdisplay.php?f=34
Powershell
- http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.windows.powershell
- http://www.powershellcommunity.org/Forums/tabid/54/Default.aspx
- http://social.technet.microsoft.com/Forums/en/winserverpowershell/threads
- http://www.scriptinganswers.com/forum2/forum_topics.asp?FID=27
- http://www.vistax64.com/powershell/
Print XML
Regular Expressions
- http://regexadvice.com/Forums/
- http://forums.devnetwork.net/viewforum.php?f=38
- http://www.aspmessageboard.com/forumdisplay.php?s=e84ecbea18a040c34e9a07f632e3f72d&f=15
Sharepoint
- Technet Sharepoint forum http://social.technet.microsoft.com/Forums/en-US/category/sharepoint/
- Tec-Tips Sharepoint forum http://www.tek-tips.com/threadminder.cfm?pid=820
- MSDN Sharepoint forum - http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=328&SiteID=1
- Sharepoint User Group - http://www.sharepointforum.com/en-US/Pages/default.aspx
- Codeplex Sharepoint forum - http://www.codeplex.com/SPFORUMS
- http://social.msdn.microsoft.com/forums/en-US/category/sharepoint/
Sharpdevelop
Siebel
Silverlight
- Silverlight http://silverlight.net/default.aspx
Smart Devices
Source Control (including Source Safe)
- http://social.msdn.microsoft.com/Forums/en-US/vssourcecontrol/threads
- http://forums.dynamsoft.com/microsoft-visual-sourcesafe-vss-forum-f17.html
SQL Compact/Mobile
SQL Server:
- SQL Server Team http://www.sqlteam.com/forums/
- SQL Server Central http://www.sqlservercentral.com/
- SQL Server at MSDN http://social.msdn.microsoft.com/Forums/en-US/categories (page down to the SQL section)
- SQL at TEk-TIPS http://tek-tips.com/threadminder.cfm?pid=183&page=1
- Less Than Dot http://forum.lessthandot.com/viewforum.php?f=17
SQL Server Express
SQL Server Setup and Getting Started
SSAS
SSIS
SSRS
StyleCop (a.k.a. CodeCop)
SugarCRM
SVN
Sybase
- http://www.sybase.com/detail_list?id=11507
- http://www.ap.sybase.com/jive3/index.jspa?categoryID=1
- http://www.tek-tips.com/threadminder.cfm?pid=187
- http://www.dbforums.com/sybase/
- http://forums.tutorialized.com/sybase-114/
Terminal Services
- http://forums.msterminalservices.org/
- http://social.technet.microsoft.com/Forums/en/winserverTS/threads
TinyMCE
Telerik Controls
Tortoise SVN
Ultidev
Umbraco
Unity
Upload Source Projects to
VideoLAN
Visual Basic
- http://social.msdn.microsoft.com/Forums/en-US/category/visualbasic/
- http://www.xtremevbtalk.com/
- http://www.codeguru.com/forum/forumdisplay.php?f=42
- http://www.vbforums.com/
Visual Studio Debugger
Visual Studio Express Edition
Visual Source Safe (VSS)
Visual Source Safe Forum http://social.msdn.microsoft.com/Forums/en-US/vssourcecontrol/threads/
Visual Studio Team System (VSTS)
Visual Studio Team Version Database Version
Visual Studio Extensibility
- VS Extensibility forum http://social.msdn.microsoft.com/forums/en-US/vsx/threads/
Visual Studio and .NET Framework documentation
VSTO Visual Studio Tools for Office
Web Hosting:
Web Hosting http://www.webhostingtalk.com/
Windows 7
- http://social.technet.microsoft.com/Forums/en/category/w7itpro/
- http://www.sevenforums.com/
- http://windows7forums.com/
- http://www.w7forums.com/
Windows Azure Development
Windows Communication Foundation (WCF)
Windows Forms
Windows Mobile
- MSDN https://forums.microsoft.com/windowsmobile/default.aspx?siteid=65
- PDA Street http://www.pdastreet.com/forums/forumdisplay.php?f=4
Windows Presentation Form (WPF)
- MSDN http://social.msdn.microsoft.com/forums/en-US/wpf/threads/
- Code Guru http://www.codeguru.com/forum/forumdisplay.php?f=99
- Code Project http://www.codeproject.com/script/Forums/View.aspx?fid=1004114
Windows Server 2008
- Windows Server 2008 http://windows2008forum.com/
- TekTips http://www.tek-tips.com/threadminder.cfm?pid=1674
- Computing.Net http://www.computing.net/forum/windows2008/1.html
Windows Services
- http://social.msdn.microsoft.com/Forums/en-US/windowsgeneraldevelopmentissues/threads (and other general windows issues without a specific forum)
Windows SysInternals
Windows Workflow
Windsor Castle
Yet Another Forum