31 January 2008

Download 59 learning video of Silver Light from Silver.net site.

Create PROCEDURE usp_MoveSequence]

@ID int,

@Sequence int,

@MoveBy varChar(4)

AS

BEGIN—PROCEDURE

SET NOCOUNT ON;

DECLARE @compateTo INT

DECLARE @compateToMax INT

DECLARE @currentSequence INT

DECLARE @NextSequence INT

DECLARE @NextRecordID INT

IF @MoveBy='UP'

Select TOP 1 @NextSequence=Sequence, @NextRecordID=ID from TableName where sequence<@Sequence ORDER BY sequence DESC

ELSE IF @MoveBy='DOWN'

Select TOP 1 @NextSequence=Sequence, @NextRecordID=ID from TableName where sequence>@Sequence ORDER BY sequence

--ENDIF

IF @NextRecordID<>0

BEGIN

UPDATE TableName SET Sequence=@NextSequence WHERE ID=@ID

UPDATE TableName SET Sequence=@Sequence WHERE ID=@NextRecordID

END

END--PROCEDURE

13 January 2008

Do you want to show 1 rupees note of year 1949?

Click Here to find really very great information about currency of our country with image preview and it year.
Did you started to learn new features of Visual Studio 2008?

  • What's New in Microsoft Visual Studio 2008
  • Microsoft LINQ
  • Microsoft ASP.NET AJAX
  • Microsoft Silverlight.
Download eBook of this new version of Visual Studio from Microsoft learning center.

07 January 2008

Microsoft Office provides very good temples for Year 2008.

This templates are available in many formats like Word, Excel, Powerpoint, Once note, Visio

Download many attractive calenders form here.


01 December 2007

You may have seen Microsoft Download Center so many times.


But now there is a new look:



Visit Microsoft Download Center Beta!

25 November 2007

ASP.NET site have some new video series.

Download learnig video ASP.NET 3.5 and Visual Studio 2008. And Click here to download Linq videos.

20 November 2007

Add validation to WebUserControl, Normally when we click on ControlToVelidate property, it automatically show as all the list of WebControls of that from, But you will not find WebUserControl name there.

Solution is that just write down that WebUserControl name and type "$" sign and write down WebControl name which one is going to validate form that WebUserControl.

for example:
  • I created a webusercontrol and there is a textbox in that control.
  • I will drag that webusercontrol in my aspx page.
  • It's default name will be "WebUserControl1"
  • Now I will put a RequiredFieldValidator in my aspx page.
  • Then I will write down in ControlToVelidate = "WebUserControl1$TextBox1"
Because "WebUserControl1" is my web control name in my aspx page. and "TextBox1" this the name of that control in that Web User Control.

This is very ease and useful method to validate WebUserControl.

18 November 2007

28 September 2007

FireFox has a grate Add-In which allows to save any web page to JPEG or PNG format.

It's Save As Image.

Click here to Download.

Save whole web page or you can also crop any part of that web site.

It's very useful.