Date format error while migrating to sql 2008

Reason for error
1.    Application pool configured for your application in iis was ‘Default Application Pool’ and default framework for  ‘Default Application Pool’ was 2.0.
2.   your application supports only framework 1.1.
3.    Calendar control used in your application was not functioning properly because of the above frame work issue.
4.    Server date time was in different format.

(This reasons were not predictable as we used iis 6 with framework 1.1)

Actions taken for resolution
1.    Changed server date format to ‘M/d/yyyy’.
2.    Restarted the server.
3.    Uninstalled and installed framework 1.1 using ‘aspnet_regiis.exe –u/-i’ (When multiple version of framework in same server)
4.    Created separate application pool for your application with 1.1 framework.
5.    Changed ‘Managed Pipeline Mode’ to ‘Classic’ from ‘Integrated’ as 1.1 will not support ‘Integrated’ (Application pool >> Advanced settings >>MANAGED Pipeline Mode)
6.    Added below line in Machine.config file.to avoid “unrecognized configuration section 'system.webserver' “(Microsoft.NET\Framework\v1.1.4322\CONFIG) . added before  </configSections>
          <section name="system.webServer" type="System.Configuration.IgnoreSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

Solution provided for Mail triggering:

Reason: In Windows 2003 app pool will be serving with default Identity as “Network Service” but in Windows 2008 R2 app poll will be serving with Default Identity as ApplicationPoolIdentity.

What is a DTS package?

What is a DTS package?
A DTS package is a set of related objects (connections, tasks, and workflows) that can be used to access, transform and manipulate data from a wide range of sources including text files and relational databases. DTS was introduced with the release of SQL Server 7.0 and was carried across to SQL Server 2000 because of its immense popularity. ...(more)

Free E-book , moving to visual studio 2010

http://blogs.msdn.com/b/microsoft_press/archive/2010/09/13/free-ebook-moving-to-microsoft-visual-studio-2010.aspx

Great Free Video Training on ASP.NET Web Forms and ASP.NET MVC

                            Created by Pluralsight (a great .NET training company), these video courses are available free of charge and provide a great way to learn (or brush-up your knowledge of) ASP.NET Web Forms 4 and ASP.NET MVC 3.  Each course is taught by a single trainer, and provides a nice end-to-end curriculum (from basic concepts to working with the new Entity Framework “code first” model to security, deployment, and testing).  

Enter the link

Import excel sheet into sql server using .net technologies

Import excel sheet into sql server using .net technologies

Popup window using javascript

<script language="javascript" type="text/javascript">

var win=null;
function NewWindow(mypage,myname,w,h,scroll,pos)

{
if(pos=="random"){LeftPosition=(screen.width)?

Math.floor(Math.random()*(screen.width-w)):100;

TopPosition=(screen.height)?Math.floor

(Math.random()*((screen.height-h)-75)):100;}
if(pos=="center"){LeftPosition=(screen.width)?

(screen.width-w)/2:100;TopPosition=(screen.height)

?(screen.height-h)/2:100;}
else if((pos!="center" && pos!="random") ||

pos==null){LeftPosition=0;TopPosition=20}
settings='width='+w+',height='+h+',top='+

TopPosition+',left='+LeftPosition+',scrollbars='

+scroll+',location=no,directories=no,status

=no,menubar=no,toolbar=no,resizable=no';
win=window.open(mypage,myname,settings);}
</script>

Copy the following where you want to generate popup link

<a href="http://www.google.com" 
onclick="NewWindow(this.href,'mywin',
'120','120','no','center');return false" 
onfocus="this.blur()">YourLinkText</a>

Disable back key in browser

Add this script inside head tag in html page 

<script type = "text/javascript" >

   function preventBack(){window.history.forward();}

    setTimeout("preventBack()", 0);

    window.onunload=function(){null};

</script

Clear all controls in a webform

private void Clear(Control Parent)
{
foreach (Control Child in Parent.Controls)
{
if (Child.HasControls())
Clear(Child);
else
{
if (Child.GetType() == typeof(TextBox))
((TextBox)Child).Text = "";
}
}
}
protected void Button1_Click(object sender, EventArgs e)

{

Clear(this.Page);
}
} 

Auto complete textbox in asp.net

http://www.aspsnippets.com/Articles/Using-jQuery-AutoComplete-Plugin-in-ASP.Net.aspx

Check username availability in .Net

http://www.aspsnippets.com/Articles/Check-Username-Availability-in-ASP.Net-using-AJAX-PageMethods.aspx

.Net Document Viewer

http://www.aspsnippets.com/Articles/Display-Word-document-on-web-page-in-ASP.Net.aspx

Formatted Emails

Send format emails using asp.net   :

http://www.aspsnippets.com/Articles/Create-and-send-HTML-Formatted-Emails-in-ASP.Net-using-C-and-VB.Net.aspx

Image preview after upload

http://www.aspsnippets.com/Articles/Display-image-after-upload-without-page-refresh-or-postback-using-ASP.Net-AsyncFileUpload-Control.aspx

Format date time

String.Format("{0:dd MMM yyyy }", Convert.ToDateTime(your value in datetime format));

.Net programmers needed urgently

Company :impulse technology
Email :
Website : www.impulse-technologies.com
Qualification :Degree
Expeience :1 year
Vaccancy posted :
Tehnology :C#, ASP.Net, SQL Server 2005
Location: Banglore