Note: Most of the Article of this blog has taken from another reputated blogs,Websites so Author will not responsible for any Issue.

How to configure dbmail in sql server 2005 and 2008

Step 1) Create Profile and Account:
You need to create a profile and account using the Configure Database Mail Wizard which can be accessed from the
Configure Database Mail context menu of the Database Mail node in Management Node.
This wizard is used to manage accounts, profiles, and Database Mail global settings which are shown below:





Step 3) Send Email:
After all configurations are done, we are now ready to send an email. To send mail,
we need to execute a stored procedure sp_send_dbmail and provide the required parameters as shown below:



How to decompile .net DLL or EXE

DIS# is better decompiler for .net.You can get back your code within few minutes by using dis#.
Before purchase dis# take a trial for this.If you need full version of with lifetime membership dis# then please send me a mail to at mangeshgangwar@gmail.com.
   
Features of dis#

  • Internal editor for quick editing


    Type new name and press Enter:

    The typical problem with decompilation is the absence of full source information in the executable file. For instance, .NET assembly does not contains names of local variables. Program can automatically assign local names in accordance with their types (what Dis# is really do), but it still too differentiates with the original source.

    Dis# makes next logical step in this direction. You can edit the names and keep the changes in a project file. ( see screenshot )
  • Download DIS# from Here    
  • Dis# project file

    Dis# have it's own metadata structure, which expands PE metadata structure with all necessary for decompilation information, such as local variable names. You can save Dis# metadata in the project file (extension .dis) and keep all changes.

  • Decompilation Speed

    Custom metadata provides outstanding decompilation speed, which 25-700 times faster then have other .NET decompilers. Dis# decompiles more then 2000 methods per second.

  • Multiple Languages decompilation

    Support for C#, Visual Basic.NET, Delphi.NET and Chrome.

  • Well formed code

    Dis# generates code, which is look like the human edited. Dis# .net decompiler have many options to adjust code view for your preferences.

  • Optimization

    Dis# optimize code.

  • .NET 2.0 support

    Dis# support .NET 2.0 assembly format, generics etc.

  • Raw Code

    In some cases you have to view raw code (before high level decompilation algorithms processing).


  • Download DIS# from Here      

Windows Communication Foundation


Windows communication Foundation a part of the .NET Framework that provides a unified programming model for building service-oriented applications that communicate across the web and the enterprise.   


Visual Studio 2010 and .NET Framework 4 are Here!Visual Studio 2010 and .NET Framework 4 are Here!
Visual Studio 2010 and .NET Framework 4 mark the next generation of developer tools from Microsoft. Check it out! 
 
  
Download from here
Get it
Get Started
Beginner's Guide
Learn more
Learn more
 
WS  Interoperability between WCF and Metro
Information for .NET Framework and Java Metro developers on creating standards-based Web Services that enable communication between the two platforms. Demonstrates interoperability across a range of WS-I and other scenarios.
 
New Web Service Interoperability with WCF page on MSDN
We've just released a new page on MSDN where you can get all kinds of information about WS-* interoperability with WCF - How-To White Papers, case studies, and news about Microsoft’s web service interoperability efforts.
Standards-Based Interoperability between SAP NetWeaver and Microsoft .NET Framework
Information for .NET Framework and SAP NetWeaver developers on creating standards-based Web Services that enable communication between the two platforms. Demonstrates simple ping/echo scenarios, as well as a complete end-to-end ERP Purchase order application.
A Developer's Introduction to Windows Communication Foundation (WCF) .NET 4
An overview of the most important new features and improvements in WCF, with enough technical detail and code to help you as a developer understand how to use them. Now updated for the release of .NET 4 and Visual Studio 2010. 
 

New Social API Web Application Toolkit for .NET Web Developers

Latest in this API

We've just published an update to our Web Application Toolkits! Here is a summary of web application toolkits:

Its totally free for .net developers.It help ASP.NET web developers complete common web development tasks and quickly add new features to your apps. Whether it's Bing Maps integration or adding social capabilities to your site, there's a toolkit for you. For the full list of Web Application Toolkits check out this website.

Summary:-

  1. Added a new Social API Web Application Toolkit
  2. Updated all the WATs to be compatible with Visual Studio 2010
Introducing the Social API Web Application Toolkit

image



As social networking Web sites are becoming more and more popular, users often want to access simultaneously the different networks they belong to from one only entry point. For example, one user might want to post the same message they are posting on your site also on Facebook, Twitter, MySpace and so on.

Although many of these social networks provide APIs for accessing their information, you might want to integrate your Web application with several social sites at the same time and be able to do this in a consistent manner, without having to go into numerous modifications in your code with each new social network that you want to incorporate.

This Web Application Toolkit provides a generic "Social Networks" API that allows connecting your Web application with different social networks and managing them through one entry point with a consistent set of methods. In the Toolkit you'll find examples of how to use the Social Networks API provided to connect a Web application with Facebook and Twitter, allowing you to manage the data provided by these networks in a generic way.

Please notice that this Toolkit includes examples only for reduced set of operations (mainly posting status updates) within the two social networks named before. Through this documentation you'll find instructions on how to extend this set into more operations and more social networks.

More Details:-

This toolkit comes with Facebook and Twitter Providers that allow you to perform tasks against different Social Network APIs in a common way.  For example, Facebook and Twitter do authentication in different ways which is a pain because you have to write different code for each network.  The Providers mean that you can call common methods and pass in which social networks you want to perform the action against – behind the scenes the providers call the appropriate methods against Facebook or Twitter to get the job done.  The provider model also makes it easy to extend the API to other Social Networks in the future – we've provided detailed instructions on how to do this in the documentation that comes with the toolkit download – it's in the "next steps" section.

  1. public ActionResult NetworkLogin(string providerName)
  2.         {
  3.             var social = new SocialProxy();
  4.             return this.Redirect(social.GetProvider(providerName).LoginUrl);
  5.         }

The code above shows how you use the SocialProxy class, included in the toolkit to get the login URL for the given social network.  In this example we then redirect the user to that URL instead of an MVC view in our application.

The Social Networks API checks if the user is already authenticated in the application and if not it authenticates him by using the FormsAuthentication.SetAuthCookie method. The API maintains a user repository with the account information for each user's social networks.

  1. public bool Login(string providerName, HttpContextBase httpContext)
  2.         {                        
  3.             var provider = this.GetProvider(providerName);
  4.             var identity = provider.GetLoginIdentity(httpContext);
  5.             
  6.             if (identity == null)
  7.             {
  8.                 return false;
  9.             }
  10.  
  11.             if (!httpContext.User.Identity.IsAuthenticated)
  12.             {
  13.                  var userId = this.usersRepository.FindIdentity(identity) ?? this.usersRepository.CreateUser(identity);
  14.                  FormsAuthentication.SetAuthCookie(userId, false);
  15.             }
  16.             else
  17.             {
  18.                  var userId = this.usersRepository.FindIdentity(identity);
  19.                  if (userId != httpContext.User.Identity.Name)
  20.                  {
  21.                      this.usersRepository.AssociateIdentity(httpContext.User.Identity.Name, identity);
  22.                  }
  23.             }
  24.  
  25.             return true;
  26.         }

Notice that new users do not need to create a separate account when registering on the Web application. The API stores the user's Facebook and Twitter account information, and creates a unique identifier on the user repository for that user to keep them associated.

The API stores the user internal identifier together with the login information for each of its associated social networks, by using the UsersRepository.AssociateIdentity method.

How to decompile any .net DLL

How to decompile any .net DLL

Part -1



Part -2



Part -3



Part -4

Find nth Wor from a table in SQL Server or any row from table

/***************************
FIND NTH ROW FROM A TABLE IN SQL SERVER OR ANY ROW FROM TABLE
BY: MANGESH SINGH
**********************************/

DECLARE @N INT
DECLARE @COUNT INT
SET @N=1
SELECT @COUNT=COUNT(*) FROM TBLAGENTEMPLOYEE
SELECT * FROM(SELECT ROW_NUMBER() OVER (ORDER BY AGENTEMPLOYEEID DESC) AS EID,* FROM TBLAGENTEMPLOYEE) AS AGENTEMPLOYEE
WHERE EID=@COUNT-@N

/*** WHERE NTH=@N */