Microsoft Technologies

Date Conversion in SQL

2011-03-10T02:13:00.000-08:00

SELECT convert(datetime,'15/03/18',3) -- 2018-03-15 00:00:00.000

SELECT convert(datetime,'15.03.18',4) -- 2018-03-15 00:00:00.000

SELECT convert(varchar,getdate()) -- Mar 15 2018 10:35AM

SELECT convert(varchar,getdate(),0) -- Mar 15 2018 10:35AM

SELECT convert(varchar,getdate(),1) -- 03/15/18

SELECT convert(varchar,getdate(),2) -- 18.03.15

SELECT convert(varchar,getdate(),3) -- 15/03/18

SELECT convert(varchar,getdate(),4) -- 15.03.18

SELECT convert(varchar,getdate(),5) -- 15-03-18

SELECT convert(varchar,getdate(),6) -- 15 Mar 18

SELECT convert(varchar,getdate(),7) -- Mar 15, 18

SELECT convert(varchar,getdate(),8) -- 10:39:39

SELECT convert(varchar,getdate(),9) -- Mar 15 2018 10:39:48:373AM

SELECT convert(varchar,getdate(),10) -- 03-15-18

SELECT convert(varchar,getdate(),11) -- 18/03/15

SELECT convert(varchar,getdate(),15) -- 180315

SELECT convert(varchar,getdate(),13) -- 15 Mar 2018 10:41:07:590

SELECT convert(varchar,getdate(),14) -- 10:41:25:903

SELECT convert(varchar,getdate(),20) -- 2018-03-15 10:43:56

SELECT convert(varchar,getdate(),21) -- 2018-03-15 10:44:04.950

SELECT convert(varchar,getdate(),22) -- 03/15/18 10:44:50 AM

SELECT convert(varchar,getdate(),23) -- 2018-03-15

SELECT convert(varchar,getdate(),24) -- 10:45:45

SELECT convert(varchar,getdate(),25) -- 2018-03-15 10:46:11.263

SELECT convert(varchar, getdate(), 100) -- Oct 23 2016 10:22AM (or PM)
SELECT convert(varchar, getdate(), 101) -- 10/23/2016

SELECT convert(varchar, getdate(), 102) -- 2016.10.23

SELECT convert(varchar, getdate(), 103) -- 23/10/2016

SELECT convert(varchar, getdate(), 104) -- 23.10.2016

SELECT convert(varchar, getdate(), 105) -- 23-10-2016

SELECT convert(varchar, getdate(), 106) -- 23 Oct 2016

SELECT convert(varchar, getdate(), 107) -- Oct 23, 2016

SELECT convert(varchar, getdate(), 108) -- 09:10:34

SELECT convert(varchar, getdate(), 109) -- Oct 23 2016 11:10:33:993AM (or PM)

SELECT convert(varchar, getdate(), 110) -- 10-23-2016

SELECT convert(varchar, getdate(), 111) -- 2016/10/23

SELECT convert(varchar, getdate(), 112) -- 20161023

SELECT convert(varchar, getdate(), 113) -- 23 Oct 2016 06:10:55:383

SELECT convert(varchar, getdate(), 114) -- 06:10:55:383(24h)

SELECT convert(varchar, getdate(), 120) -- 2016-10-23 06:10:55(24h)

SELECT convert(varchar, getdate(), 121) -- 2016-10-23 06:10:55.383

SELECT convert(varchar, getdate(), 126) -- 2016-10-23T06:10:55.383

SELECT [Date] = CAST('20120228' AS date) -- 2012-02-28

SELECT [Datetime] = CAST('20120228' AS datetime) -- 2012-02-28 00:00:00.000

SELECT [Datetime] = CAST('20120228' AS smalldatetime) -- 2012-02-28 00:00:00

DECLARE @sDate varchar(10)

SET @sDate = '2010/03/15'

-- DATEDIFF (delta) between two dates in months

SELECT GETDATE(), DATEDIFF (MONTH, GETDATE(), @sDate)

SELECT GETDATE(), DATEDIFF (MONTH, GETDATE(), CAST(@sDate as datetime))

SELECT GETDATE(), DATEDIFF (MONTH, GETDATE(), CONVERT(datetime,@sDate))

SELECT GETDATE(), DATEDIFF (MONTH, GETDATE(), CONVERT(datetime,@sDate,111))

-- Seme results for above: 2008-12-29 11:04:51.097 15

-- SQL convert to datetime with wrong style (111 correct, 112 incorrect)

SELECT GETDATE(), DATEDIFF (MONTH, GETDATE(), CONVERT(datetime,@sDate,112))

Above SQL query is very much helpfull for me. I refer this from sqlusa.com

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

2011-02-22T15:08:00.000-08:00

Today i tried to restore the backup Database to another SQL Server 2008 R2, but i got the error as

"An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)"

Additional information:
The media family on device 'Backupfile.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

Reason For Failur

The backup was corrupted. The file was transferred using FTP in text mode rather than binary mode.

Format Data in the Windows Forms DataGridView Control

2011-02-19T10:22:00.000-08:00

Useful coding for formation the cells in datagridview in MSDN site

To enable wordwrap in text-based cells

this.dataGridView1.DefaultCellStyle.WrapMode =     DataGridViewTriState.True;

To specify the text alignment of DataGridView cells
this.dataGridView1.Columns["CustomerName"].DefaultCellStyle     .Alignment = DataGridViewContentAlignment.MiddleRight;
To customize the display of null database values
this.dataGridView1.DefaultCellStyle.NullValue = "no entry";
To format currency and date values
this.dataGridView1.Columns["UnitPrice"].DefaultCellStyle.Format = "c"; this.dataGridView1.Columns["ShipDate"].DefaultCellStyle.Format = "d";

And also as below
  dataGridView1.Columns[0].DefaultCellStyle.Format = "dd'/'MM'/'yyyy";
            //Get 13/12/2007
            dataGridView1.Columns[1].DefaultCellStyle.Format = "dd'/'MM'/'yyyy hh:mm:ss tt";
            //Get 13/12/2007 5:00:11 PM

validate Datagridview column

2011-02-19T10:05:00.000-08:00

If you want to validate the column in the datagridview then you can choose "CellValidating"

Sample Codeing is as below

private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
DataGridViewTextBoxCell cell = dataGridView1[e.ColumnIndex, e.RowIndex] as DataGridViewTextBoxCell;

if (cell != null)
{
char[] chars = e.FormattedValue.ToString().ToCharArray();
foreach (char c in chars)
{
if (char.IsDigit(c) == false)
{
MessageBox.Show("You have to enter digits only");

e.Cancel = true;
break;
}
}
}
}

Suppose if you want to validate after pressing enter, then you can use as below

protected override bool ProcessDialogKey(Keys keyData)
    {
        if (keyData == Keys.Enter)
        {
            DataGridViewCell currentCell = CurrentCell;
            EndEdit();
            CurrentCell = null;
            CurrentCell = currentCell;
            return true;
        }
        return base.ProcessDialogKey(keyData);
    }

else you can also use EditControlShowing event

void dataGridView1_EditingControlShowing(object sender,
                 DataGridViewEditingControlShowingEventArgs e)
            {
                if (this.dataGridView1.CurrentCell.ColumnIndex == 0)
                {
                    if (e.Control is TextBox)
                    {
                        TextBox tb = e.Control as TextBox;
                        tb.KeyPress -= new KeyPressEventHandler(tb_KeyPress);
                        tb.KeyPress += new KeyPressEventHandler(tb_KeyPress);
                    }
                }
            }
 
            void tb_KeyPress(object sender, KeyPressEventArgs e)
            {
                if (!(char.IsDigit(e.KeyChar)))
                {
                    Keys key = (Keys)e.KeyChar;
 
                    if (!(key == Keys.Back || key == Keys.Delete))
                    {
                        e.Handled = true;
                    }
                }
            }
        }

Multiplication trick

2011-02-13T04:24:00.000-08:00

To make the multiplication with some trick

12*13=?

Take first digit from each side

1*1=1

Then make cross multiple with other digit and sum the result

(1*3)+(1*2)=5

finally take multiple of last digit in both the side

2*3=6

now con cat all the result will give you the result

1+5+6

Similarly for little bit complex digit

56*98=?

(5*9)=45

(5*8)+(6*9)=94

(6*8)=48

Here while you join the result some time you can find more than one digit as in this case, if so you have to add the highest position of each result with other.

In our case, you have to combine 45 with 95, here 95 is two digit number and not single digit so add 9 it with 45 which result as below 54 now combine remaining one digit 4 with this 54.

544

similarly for last one

544+48=> 54(4+4)8=>5488

so the result is 56*98=5488

Create identity to create table with data

2011-02-03T22:29:00.000-08:00

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

insert into table1(column1 )

select column1 from table1

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

2011-02-03T22:27:00.000-08:00

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 nextRow(int curentgridindex, int currentpage, int totalrowcount)

2) List previuosRow(int curentgridindex, int currentpage, int totalrowcount)

3) List nextPage(int curentgridindex, int currentpage, int totalrowcount)

4) List previousPage(int currentpage, int totalrowcount)

5) List LastRecord(int totalrowcount)

6) List FirstRecord()

7 ) List RefreshRow(int curentgridindex, int currentpage, int totalrowcount)

8 ) List GetPagePosition(int rowindex, int totalNumberofRow)

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:

//Move to Next Row

private void NextRow_Click(object sender, EventArgs e)

{

int totalrowcount = ds.Tables[0].Rows.Count;

dsPaging.NumberOfRecordPerPage = Convert.ToInt32(textBox1.Text);

List poition = dsPaging.nextRow(currentindex, currentpage, totalrowcount);

currentindex = poition[0];

currentpage = poition[1];

Noofrow = poition[2];

ReFillGrid();

}

Any bug or Paging API question are always welcome.

22 Ways to Become Spectacularly Inspirational

2011-02-03T22:25:00.000-08:00

1. Do important work vs. merely offering opinions.

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

How to add new site collection in separate content database

2010-11-15T00:58:00.000-08:00

http://blogs.msdn.com/b/mcsnoiwb/archive/2007/08/20/how-to-create-site-collection-in-a-specific-content-database.aspx

How can i play multiple media files in moss2007

2010-11-11T22:07:00.000-08:00

Am in the situation i need to run different media file(*.flv, *.wma, *.dat etc...) in my Sharepoint portal. Media player web part help me to achieve my goals. I download MediaPlayerWebpart.dll and i make use of it.

Small introduction about 'Media Player Web part'

The Media Player Web Part makes it easier to integrate media into SharePoint.It is a universal Media Player Web Part.It queries a media player HTML template from a SharePoint list located anywhere in your farm.Media-file URL, size, title, description, autoplay options can be set.

FAQ

2010-11-11T00:01:00.001-08:00

Access

Access World Forum http://www.access-programmers.co.uk/forums/
Utter Access Discussion www.utteraccess.com

AspDotNetStorefront

http://forums.aspdotnetstorefront.com/

BizTalk

MSDN forum http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=398&SiteID=1

BlogEngine.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

http://ultidev.com/Forums/default.aspx

Cat.Net (static code checker for SQL and XSS Injection)

http://social.msdn.microsoft.com/Forums/en-US/catnet/threads

Cheat Sheets

CkEditor

Classic ASP

Code Converters (convert VB to C# and C# to VB)

Cognos

Commerce Server

http://social.msdn.microsoft.com/Forums/en/category/commserver/

ComponentArt

http://www.componentart.com/community/forums/default.aspx

Cross Browser Compliance

http://www.anybrowser.org/campaign/forum/

Cruise Control

http://old.nabble.com/CruiseControl-f2425.html

Crystal Reports

CSS (Cascading Style Sheets)

CSS Layout Techniques: for Fun and Profit http://glish.com/css/

Delphi

For queries on Delphi see http://www.delphiforums.com/

Developer Express

http://community.devexpress.com/forums/

Dojo

http://o.dojotoolkit.org/forum

Doloto

http://social.msdn.microsoft.com/Forums/en-US/doloto/threads

Dot Less

http://groups.google.com/group/dotless

Dot Net

MSDN Dot Net forum see http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=12&SiteID=1

DotnetNuke

http://www.dotnetnuke.com/tabid/795/Default.aspx

Dreamwaver

Dundas Chart

http://support2.dundas.com/forum/

Entity Framework

http://social.msdn.microsoft.com/forums/en-US/adodotnetentityframework/threads/

Expression Web

Facebook

http://developers.facebook.com/

FckEditor - see CKEditor

FFMPEG

http://ubuntuforums.org/tags.php?tag=ffmpeg

Firebird

Flash

Foxpro

Free Asp.Net Web Hosting

FreeTextBox

http://freetextbox.com/forums/

FXCOP

http://social.msdn.microsoft.com/Forums/en-US/vstscode/threads?sort=lastpostdesc

http://cs.hubfs.net/forums/default.aspx

Generic Programming Sites

http://stackoverflow.com/

GhostDoc

http://community.submain.com/forums/30/ShowForum.aspx

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

http://news.infragistics.com/forums/default.aspx

Internet Explorer

iTextSharp

http://www.nabble.com/iTextSharp-f4188.html

Java

jQuery

http://docs.jquery.com/Discussion

JSON

LINQ

MSDN Linq - http://forums.microsoft.com/MSDN/ShowForum.aspx?siteid=1&ForumID=123

LinqPad

http://forums.oreilly.com/category/22/C-3-0-in-a-Nutshell/

Live Meeting

http://social.technet.microsoft.com/Forums/en/onlineserviceslivemeeting/threads

MBUnit

http://groups.google.com/group/mbunituser

Microsoft Charting Control

http://social.msdn.microsoft.com/Forums/en-US/MSWinWebChart/threads/

Microsoft Infopath

Microsoft Office

Microsoft Project

MOQ

MySQL

NANT Forum

http://www.nabble.com/NAnt-f15390.html

NHbernate

http://forum.hibernate.org/viewforum.php?f=25

NOPCommerce

Notepad++

http://sourceforge.net/projects/notepad-plus/forums

Open Source Projects and Libraries

http://www.codeplex.com/

Oracle

Pex

http://social.msdn.microsoft.com/Forums/en-US/pex/threads/

PHP

Powershell

Print XML

http://www.princexml.com/bb/viewforum.php?f=5

Regular Expressions

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

http://community.sharpdevelop.net/forums/

Siebel

http://siebel.ittoolbox.com/groups/technical-functional/siebel-dev-l/

Silverlight

Silverlight http://silverlight.net/default.aspx

Smart Devices

MSDN http://social.msdn.microsoft.com/forums/en-US/vssmartdevicesvbcs/threads/

Source Control (including Source Safe)

SQL Compact/Mobile

http://social.msdn.microsoft.com/forums/en-US/sqlce/threads/

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

http://social.msdn.microsoft.com/Forums/en-GB/sqlexpress/threads

SQL Server Setup and Getting Started

http://social.msdn.microsoft.com/Forums/en-GB/sqlgetstarted/threads

SSAS

http://social.msdn.microsoft.com/Forums/en-GB/sqlanalysisservices/threads

SSIS

http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/threads

SSRS

http://social.msdn.microsoft.com/Forums/en-GB/sqlreportingservices/threads

StyleCop (a.k.a. CodeCop)

http://code.msdn.microsoft.com/sourceanalysis

SugarCRM

http://www.sugarcrm.com/forums/

SVN

Sybase

Terminal Services

TinyMCE

http://tinymce.moxiecode.com/punbb/index.php

Telerik Controls

http://www.telerik.com/community/forums.aspx

Tortoise SVN

http://www.svnforum.org/

Ultidev

http://ultidev.com/Forums/Default.aspx?g=forum

Umbraco

http://forum.umbraco.org/

Unity

http://unity.codeplex.com/discussions

Upload Source Projects to

VideoLAN

http://forum.videolan.org/

Visual Basic

Visual Studio Debugger

http://social.msdn.microsoft.com/Forums/en/vsdebug/threads

Visual Studio Express Edition

http://social.msdn.microsoft.com/Forums/en/Vsexpressvb/threads

Visual Source Safe (VSS)

Visual Source Safe Forum http://social.msdn.microsoft.com/Forums/en-US/vssourcecontrol/threads/

Visual Studio Team System (VSTS)

http://social.msdn.microsoft.com/forums/en-US/category/vsts/

Visual Studio Team Version Database Version

MSDN http://social.msdn.microsoft.com/Forums/en-US/vstsdb/threads/

Visual Studio Extensibility

VS Extensibility forum http://social.msdn.microsoft.com/forums/en-US/vsx/threads/

Visual Studio and .NET Framework documentation

http://social.msdn.microsoft.com/Forums/en-US/devdocs/threads

VSTO Visual Studio Tools for Office

MSDN http://social.msdn.microsoft.com/forums/en-US/vsto/threads/

Web Hosting:

Web Hosting http://www.webhostingtalk.com/

Windows 7

Windows Azure Development

http://social.msdn.microsoft.com/Forums/en/category/azure/

Windows Communication Foundation (WCF)

Windows Forms

Windows Mobile

Windows Presentation Form (WPF)

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

http://forum.sysinternals.com/default.asp

Windows Workflow

http://social.msdn.microsoft.com/forums/en-US/windowsworkflowfoundation/threads/

Windsor Castle

http://forum.castleproject.org/index.php

Yet Another Forum

http://forum.yetanotherforum.net/

Sharepoint UserProfile Sync. links

2010-11-10T23:13:00.000-08:00

1) http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/adf1c861-0bd4-436f-9744-f85d229eace5

2) http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/a6e5daf1-fb7d-4e80-93f5-3b0f9218c2a0

3) http://stsadm.blogspot.com/2007/08/stsadm-commands_09.html

4) http://www.marcvalk.net/2010/04/sp2010-user-profile-synchronization-service-will-not-start/

5) http://blog.jussipalo.com/2010/02/sp2010-fimsynchronizationservice-errors.html

6) http://blogs.technet.com/b/tothesharepoint/archive/2010/01/22/3307662.aspx

7) http://sharepoint.mindsharpblogs.com/Kathy/archive/2009/11/20/Configuring-User-Profiles-in-SharePoint-Server-2010.aspx

Programatically copy document from list to library

2010-11-08T22:44:00.000-08:00

Using this below code you can copy the document from list to library, with in the same web application. The logic is as below

Source :Kethare.in

Upload the Document Programmatically to SharePoint Library

2010-11-08T22:42:00.001-08:00

The below code will Upload the document from server drive to SharePoint Library, using SPDocumentLibrary class

Source: kethare.in

Download the Sharepoint List Attachment

2010-11-08T22:34:00.000-08:00

You can download the attachment from the any SharePoint List to your local drive in your Server using the following code. Based on the article from Microsoft "How to Programmatically Download attachment from list items in WSS" i iterate the list item and also i checked for Exist of attachment for each list item.

Inherited Web-part Class and create the button control and attach the click event, in the "CreateChildControls" method as below code

(Click on above image to Enlarge the Image)

Now write the code to download the attachment from the List as below in the Button Click event Method

(Click on above image to Enlarge the Image)

Now you create a custom web-part for download the attachment of the list. Create Strong key and build the class deploy it in your Server and update the Web.Config. Add it in web-part gallery and edit the page select the web-part to download attachment. that it. When you click on the web-part, it will automatically download all attachment to the specified path.

Source :Kethare.in

How to Hide SharePoint Column based on user login in Newform.aspx

2010-10-29T04:18:00.001-07:00

For last two days i scratch my head, to hide the required column based on the user login in NewForm.aspx and EditForm.aspx of the list. Initially i tried it by using SharePoint designer without using code and later i tried by using inline code but am unable to achieve it , even though i have an option to achieve.

Finally i achieved hiding of share-point column based on user login in NewForm.aspx and EditForm.aspx by creating custom Webpart.

Create a Class Library in Visual studio and add reference 'System.Web', 'Microsoft.SharePoint'. In the class file include the required namespace specify below.

Add the below code

Create the Strong Name Key in Visual Studio and build the project and deploy the code in Assembly and add the Source Safe tag in web.config under which site you want to enable this web part. Now Activate the web-part under Web-part gallery from the top site.

Now add the custom web part in the NewForm or EditForm page where you want to hide the control. That all

To know about Custom Web part Click here

Stsadm operations

2010-10-27T08:01:00.000-07:00

· Activatefeature

Activates a feature in the feature collection.

· Addalternatedomain

Adds an internal URL and maps it to one of the five URL zones of a Web application or external resource.

· Addcontentdb

Creates a new content database or adds a database that needs to be upgraded when the url and databasename parameters are specified.

· Adddataconnectionfile

Adds a new DataConnectionFile to the DataConnectionFiles collection for InfoPath Forms Services.

· Add-ecsfiletrustedlocation

Lets an administrator add a file to the trusted location list.

· Add-ecssafedataprovider

Lets an administrator add a supported provider type to the safe provider list.

· Add-ecstrusteddataconnectionlibrary

Adds a trusted data connection to a library.

· Add-ecsuserdefinedfunction

Adds a user defined function.

· Addexemptuseragent

Adds a user agent, which is typically in the form of a search bot, to receive the XML file that contains the data of the form for indexing instead of the HTML rendering of the form.

· Addpath

Adds a managed path inclusion to a Web application.

· Addpermissionpolicy

Adds a user to a policy role for the Web application based on the specified permission level name and corresponding zone.

· Addsolution

Adds a solution file to the solution store.

· Addtemplate

Adds a site template to the template gallery.

· Adduser

Adds a user account to the specified site collection and assigns it to the specified site group.

· Authentication

Authentication provides the user identity input to the authorization process which determines what actions the current user is allowed to perform on a given object.

· Backup

Describes how to back up a site collection, an individual database, a Web application, or an entire farm.

· Backuphistory

Displays a history of backup and restore operations that have been run.

· Creategroup

Lets site collection administrators create new groups from any site collection.

· Createsite

Creates a site collection at the specified Uniform Resource Locator (URL) with the specified user as site collection owner and site collection administrator.

· Deletecontentdb

Detaches a content database when the Web application, database name, and database server are specified.

· Deleteconfigdb

Unprovisions the local machine from the farm and deletes the configuration database (but does not drop the configuration database).

· Deletegroup

Deletes a group created in Microsoft Office SharePoint Server 2007.

· Deletesite

Deletes the site collection with the specified URL from the Web application.

· Deletesolution

Removes a Windows SharePoint Services Solution Package (*.wsp) from the solution store.

· Deletessp

Deletes a Shared Services Provider (SSP) in a Web application when the title parameter is specified.

· Deletessptimerjob

Deletes all of the timer jobs in the Shared Services Provider (SSP).

· Deletetemplate

Deletes a specified site template from the site template gallery.

· Deleteuser

Deletes a user account from the specified site collection and specified site.

· Deleteweb

Deletes a subsite using the specified Uniform Resource Locator (URL).

· Deploysolution

Deploys files related to a solution from the configuration database to individual front-end Web servers in the farm.

· Displaysolution

Displays specific solution or Web Part information in a solution store.

· Editssp

Allows the site collection administrator for the Shared Services Administration site to perform the following functions:

· Change the databases that a Shared Services Provider (SSP) uses.

· Change the SQL credentials associated with the SSP databases.

· Modify the service account credentials.

· Rename an SSP

· Email

Sets the e-mail configuration settings for your server.

· Export

Exports site and subsite data from your Microsoft Office SharePoint Server 2007 installation.

· Import

Imports site and subsite data from your Microsoft Office SharePoint Server 2007 installation.

· Installfeature

Installs a feature.

· Renameserver

Changes the name of the specified server in the configuration database.

· Renamesite

Changes a URL of a host-named site collection to a new URL.

· Renameweb

Changes the URL of a subsite.

· Restore

Explains how a restoration of a site collection, an individual database, a Web application, or an entire farm is performed.

· Restoressp

Creates a Shared Service Provider using a restored database.

· Retractsolution

Retracts the specified solution’s deployment, and removes files from the front-end Web server.

· Scanforfeatures

Scans for new features in the file system, and if new features are present, installs them.

· Setconfigdb

Creates a new configuration database in a farm or joins the local computer to an existing farm's configuration database.

· Setdefaultssp

Sets a Shared Services Provider (SSP) as the default SSP in a farm.

· Setlogginglevel

Sets the Windows event log and trace log logging level for one or more diagnostic logging categories registered in the farm.

· Setsitelock

Sets a value that specifies whether the site collection is locked and unavailable for read or write access.

· Siteowner

Sets the primary or secondary administrator of a site collection.

· Setworkflowconfig

Enables or disables the workflow settings

· Upgradesolution

Upgrades an existing solution. The solution to be upgraded could be either deployed or not deployed; however, the immediate or time parameters apply only if the solution has been deployed.

· Userrole

Adds or deletes permission levels to site groups.

How to create Custom webpart in sharepoint

2010-10-27T06:54:00.000-07:00

To Get Started with creating Custom Web Part for MOSS 2007 in Microsoft Visual Studio 2008, Open the IDE and create a new C# project, Select Class Library as Project Type. Name It.

Add references to System.Web, Microsoft.Sharepoint.dll

Extend the MyNewWebPart Class from the WebPart Class ( System.Web.UI.WebControls.WebParts.WebPart), and add the code as shown below. The CreateChildren Control would create and add controls to current class. In the below coding I have only added a WebControl.Calender Object. The RenderControl Method is an override for the WebPart Base Class and calls the RenderChildren Method, this causes the Children Controls to be rendered on the Particular HtmlTextWriter passed as a parameter to the method.

Now, strongly name it, Build the dll, and use sn-t or reflector to find the public key token.

After that follow the below steps to deploy

1) Now you have to deploy to your website, so locate the Sharepoint WebSite you wish to deploy this webpart in. This can be done via the IIS Manager under administrative tools. The default ones would be virtual directories that look like GUIDs under "C:\INETPUB\WWROOT\WSS\".

2) Place the dll under the bin directory in the virtual directory.

3) Under the same virtual directory, find the web.config, and add the following to the SafeControls section -

Insted of above step you can also directly deploy it in the Assembly if you are an Administrator, and add the SafeControl in webconfig file.

4) Then browse to the WebSite, and go to Site Actions -> Site Settings.

5) On the site settings page under Galleries column click on the Web Parts

6) Click on "New" in the toolbar,as shown below -

7) Find the ClassLibrary2.MyNewWebPart

8) Now switch to 'Edit Mode' of the page where you want to add the calender control,then click on Add a webpart, you should see it in the list that pops up. Add the MyNewWebPart, and under Miscellaneous.

9) Click 'Exit Edit Mode' you will find the output as below.

Source :kethare.in

How The Average US Consumer Spends Their Paycheck

2010-10-27T06:48:00.000-07:00

Based on the Survey in 2009

Base on the latest survey, how US Consumer spend their paycheck

Sharepoint 2010 links for beginners

2010-10-12T06:29:00.000-07:00

1) http://channel9.msdn.com/learn/courses/SharePoint2010Developer/

2) http://www.microsoft.com/downloads/en/details.aspx?familyid=CFFB14E8-88A9-43BD-87AA-4792AB60D320&displaylang=en

3) http://msdn.microsoft.com/en-us/sharepoint/default.aspx

4) http://www.microsoft.com/downloads/en/details.aspx?FamilyID=83A80A0F-0906-4D7D-98E1-3DD6F58FF059

5) http://blogs.msdn.com/b/pstubbs/

6) http://msdn.microsoft.com/en-us/sharepoint/ff405669.aspx

7) http://blogs.msdn.com/b/sharepoint/

8) http://blogs.msdn.com/b/sharepointdesigner/

9) http://blogs.msdn.com/b/ericwhite/

10) http://blogs.technet.com/b/sharepointexperts/

11) http://blogs.msdn.com/b/ecm/

12) http://blogs.msdn.com/b/erikaehrli/

13) http://blogs.msdn.com/b/pandrew/

14) http://blogs.technet.com/b/speschka/

15) http://blogs.msdn.com/b/sharepointdeveloperdocs/

16) http://blogs.msdn.com/b/bcs/

17) http://technet.microsoft.com/en-us/library/cc263199.aspx

18)

Basic FAQ link

2010-10-12T00:19:00.000-07:00

Some of the FAQList in C#, oracle, and JavaScript, useful for beginners

http://www.eggheadcafe.com/faqlist.aspx?userid=931eda77-75b1-4247-bbb7-7c3311f95540

Links for sharepoint blogs

2010-10-09T13:14:00.000-07:00

Some of sharepoint Blog links

1) http://community.zevenseas.com/Blogs/Robin/default.aspx

2) http://glorix.blogspot.com/

3) http://www.vyapin.com/blogs/

4) http://www.andrewconnell.com/blog/

5) http://www.bluedoglimited.com/SharePointThoughts/ViewPost.aspx?ID=90

6) http://weblogs.asp.net/jan/

7) http://thedailyreviewer.com/top/sharepoint

8) http://weblogs.asp.net/bsimser/

9) http://blogs.msdn.com/b/mikefitz/

10) http://blogs.msdn.com/b/danielmcpherson/

11) http://weblogs.asp.net/bsimser/archive/2005/10/26/428538.aspx

12) http://blogs.technet.com/b/corybu/

Some of the MSDN Sharepoint Classes for WSS3.0

2010-10-09T12:57:00.000-07:00

Microsoft.SharePoint.SPSecurity.SPOperationCode MSDN link
Microsoft.SharePoint.Administration.SPAdministrationServiceJobDefinition MSDN link
Microsoft.SharePoint.Administration.SPJobDefinitionCollection MSDN link
Microsoft.SharePoint.Administration.SPRunningJob MSDN link
Microsoft.SharePoint.Administration.SPRunningJobCollection MSDN link
Microsoft.SharePoint.Help.SPHelpMerge MSDN link
Microsoft.SharePoint.WebControls.BackLinksIterator MSDN link
Microsoft.SharePoint.WebControls.BaseXmlDataSource MSDN link
Microsoft.SharePoint.WebControls.ContentDatabaseSection MSDN link
Microsoft.SharePoint.WebControls.ContentDatabaseSectionMode MSDN link
Microsoft.SharePoint.WebControls.DataTableDataSourceView MSDN link
Microsoft.SharePoint.WebControls.DiffSelectorIterator MSDN link
Microsoft.SharePoint.WebControls.GroupPermissions MSDN link
Microsoft.SharePoint.WebControls.IDesignTimeHtmlProvider MSDN link
Microsoft.SharePoint.WebControls.IFormDelegateControlSource MSDN link
Microsoft.SharePoint.WebControls.InputFormCheckBox MSDN link
Microsoft.SharePoint.WebControls.ItemHiddenVersion MSDN link
Microsoft.SharePoint.WebControls.IXPathNavigator MSDN link
Microsoft.SharePoint.WebControls.LinkSection MSDN link
Microsoft.SharePoint.WebControls.LinksTable MSDN link
Microsoft.SharePoint.WebControls.ListViewSelector MSDN link
Microsoft.SharePoint.WebControls.MenuSeparatorTemplate MSDN link
Microsoft.SharePoint.WebControls.RadioButtonChoiceField MSDN link
Microsoft.SharePoint.WebControls.RecentChangesIterator MSDN link
Microsoft.SharePoint.WebControls.RepeatedControls MSDN link
Microsoft.SharePoint.WebControls.ServerSelector MSDN link
Microsoft.SharePoint.WebControls.SiteAdministrationSelector MSDN link
Microsoft.SharePoint.WebControls.SiteActions MSDN link
Microsoft.SharePoint.WebControls.SPSqlDataSource MSDN link
Microsoft.SharePoint.WebControls.SPXmlDataSource MSDN link
Microsoft.SharePoint.WebControls.SubMenuTemplate MSDN link
Microsoft.SharePoint.WebControls.VersionDiffIterator MSDN link
Microsoft.SharePoint.WebControls.WebApplicationSelector MSDN link
Microsoft.SharePoint.WebControls.XmlUrlDataSource MSDN link

Sharepoint 2010 Tutorials for Developers.

2010-10-09T12:35:00.000-07:00

Part 1 - Developing a Visual Web Part in Visual Studio 2010
Part 2 - Developing a List Definition and Event Receiver in Visual Studio 2010
Part 3 - Developing Advanced Web Parts for SharePoint 2010 with Visual Studio 2010
Part 4 - Developing with LINQ to SharePoint in Visual Studio 2010
Part 5 - Developing for SharePoint 2010 with the Client OM and REST in Visual Studio 2010
Part 6 - Developing a BCS External Content Type with Visual Studio 2010
Part 7 - Developing a SharePoint 2010 Workflow with Initiation Form in Visual Studio 2010
Part 8 - Developing SharePoint 2010 User Interface with Silverlight in Visual Studio 2010
Part 9 - Developing SharePoint 2010 Sandboxed Solutions in Visual Studio 2010
Part 10 - Developing SharePoint 2010 User Interface Ribbon and Dialog Customizations

Other Links
Getting Started with Development on SharePoint 2010
Developing SharePoint 2010 User Interface Ribbon and Dialog Customizations
Developing SharePoint 2010 Sandboxed Solutions in Visual Studio 2010
Developing SharePoint 2010 User Interface with Silverlight in Visual Studio 2010
Developing a SharePoint 2010 Workflow with Initiation Form in Visual Studio 2010
Developing a BCS External Content Type with Visual Studio 2010
Developing for SharePoint 2010 with the Client OM and REST in Visual Studio 2010
Developing with LINQ to SharePoint in Visual Studio 2010
Developing Advanced Web Parts for SharePoint 2010 with Visual Studio 2010
Developing a List Definition and Event Receiver in Visual Studio 2010
Developing a Visual Web Part in Visual Studio 2010

Create a Featured News Section with jQuery

2010-10-09T12:33:00.000-07:00

One of the fine article that helped me to develop Recent Update in my Sharepoint site using JQuery. The Article is as below
http://wssdevelopment.blogspot.com/2010/04/create-featured-news-section-with.html