Configure Folder or Web Site to Use SSL/HTTPS

Configure Folder or Web Site to Use SSL/HTTPS

This procedure assumes that your site has already has a certificate assigned to it.

1. Log on to the Web server computer as an administrator.
2. Click Start, point to Settings, and then click Control Panel.
3. Double-click Administrative Tools, and then double click Internet Services Manager.
4. Select the Web site from the list of different served sites in the left pane.
5. Right-click the Web site, folder, or file for which you want to configure SSL communication, and then click Properties.
6. Click the Directory Security tab.
7. Click Edit.
8. Click Require secure-channel (SSL) if you want the Web site, folder, or file to require SSL communications.
9. Click Require 128-bit encryption to configure 128-bit (instead of 40-bit) encryption support.
10. To allow users to connect without supplying their own certificate, click Ignore client certificates.
    
    Alternatively, to allow a user to supply their own certificate, use Accept client certificates.
11. To configure client mapping, click Enable client certificate mapping, and then click Edit to map client certificates to users.
    
    If you configure this functionality, you can map client certificates to individual users in Active Directory. You can use this functionality to automatically identify a user according to the certificate they supplied when they access the Web site. You can map users to certificates on a one-to-one basis (one certificate identifies one user) or you can map many certificates to one user (a list of certificates is matched against a specific user according to specific rules. The first valid match becomes the mapping).
12. Click OK.

Speed up your queries

http://www.dotnetfunda.com/articles/article1949-tricks-to-speed-up-your-sql-query.aspx

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.

http://www.macronimous.com/resources/stored_procedures_tips.asp

" M4Mahi " crossing 5000 hits ............. Thanks for all visitors and bloggers

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)

String or binary data truncated

Check the db column size and type ... catch me for furthur clarifications

MS word Automation

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using Microsoft.Office;

using Microsoft.Office.Interop.Word;

using Word = Microsoft.Office.Interop.Word;

namespace CreditRequest

{

public partial class CreditRequest : Form

{

int iTotalFields = 0;

public CreditRequest()

{

InitializeComponent();

}

private void btn_Generate_Click(object sender, EventArgs e)

{

Object oMissing = System.Reflection.Missing.Value;

Object oTrue = true;

Object oFalse = false;

Word.Application oWord = new Word.Application();

Word.Document oWordDoc = new Word.Document();

oWord.Visible = true;

Object oTemplatePath = "C:\\Template.dot";

oWordDoc = oWord.Documents.Add(ref oTemplatePath, ref oMissing, ref oMissing, ref oMissing);

foreach (Word.Field myMergeField in oWordDoc.Fields)

{

iTotalFields++;

Word.Range rngFieldCode = myMergeField.Code;

String fieldText = rngFieldCode.Text;

if (fieldText.StartsWith(" MERGEFIELD"))

{

Int32 endMerge = fieldText.IndexOf("\\");

Int32 fieldNameLength = fieldText.Length - endMerge;

String fieldName = fieldText.Substring(11, endMerge - 11);

fieldName = fieldName.Trim();

if (fieldName == "Name")

{

myMergeField.Select();

oWord.Selection.TypeText(txt_CustName.Text);

}

if (fieldName == "Date")

{

myMergeField.Select();

oWord.Selection.TypeText(dtp_CreditDate.Text);

}

if (fieldName == "Country")

{

myMergeField.Select();

oWord.Selection.TypeText(txt_DestCountry.Text);

}

}

}

}

}

} Refer : http://social.msdn.microsoft.com/Forums/en-US/csharplanguage/thread/1a100644-da0f-482c-8042-339a8ff1658a

Pass Values Between ASP.NET Web Pages

There are mainly five ways to pass values between asp.net web pages ...
1.By using query string.
2. Using HTTP POST
3. Using Session
4. Using Public properties
5.Using control information of controls

.... ( Detail reading )

Import data from Excel sheet to SQL server using .Net

http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx

.Net Interview Questions for experienced Candidates

http://www.pritambaldota.com,

http://himabinduvejella.blogspot.com
http://sysntaxhelp.com/asp.net
http://groups.google.com/group/mugh

http://www.andymcm.com => for c# and dot net frame work faqs
http://www.syncfusion.com/faq/windowsforms/default.aspx
http://www.c-sharpcorner.com/faq.asp
http://msdn.microsoft.com/vcsharp/productinfo/faq/default.aspx
http://www.yoda.arachsys.com/csharp/faq/
http://www.gotdotnet.com/team/csharp/learn/faq/
http://www.syncfusion.com/faq/windowsforms/default.aspx


ASP.net
http://msdn.microsoft.com/asp.net/beta2/faq/default.aspx
http://www.4guysfromrolla.com/webtech/faq/faqtoc.shtml
http://www.syncfusion.com/FAQ/aspnet/Default.aspx
http://www.aspnetfaq.com
http://www.eggheadcafe.com/articles/20021016.asp
http://www.cmap-online.org/Default.aspx?tabindex=4&tabid=-17

What is Visual Studio LightSwitch?

What is Visual Studio LightSwitch?

Microsoft Visual Studio LightSwitch is a simplified self-service development tool that enables you to build business applications quickly and easily for the desktop and cloud. What can your business do with LightSwitch? Watch this brief introduction to find out. .. (-- 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

Visual Studio's collection of books

Visual Studio's collection of books span across all versions and editions of the products. In many cases, the information contained within are applicable to whichever version and/or edition you are using. Click here

Security Development Lifecycle Process Template for VSTS 2008

Overview

MSF-A+SDL is a TFS process template that incorporates the Security Development Lifecycle (SDL) for Agile process guidance into the MSF Agile development framework. With the MSF-A+SDL template, any code checked into the Visual Studio Team System source repository by the developer is analyzed to ensure that it complies with SDL secure development practices. The template also automatically creates security workflow tracking items for manual SDL processes such as threat modeling to ensure that these important security activities are not accidentally skipped or forgotten...... for more details click here

Delete multiple records from grid view

Delete multiple records from grid view  by selecting using check boxes

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

Regular expression library

http://regexlib.com/%28X%281%29A%28veT2YrYs6oiekXsLokG37Fc2mfxjYmViaR4eW0zuOEP1CBjGIgwDHLXIrg1zhhwk6_erWPt6NjWtU1-6PeLbawT5VfFqS2SmYao_lf6LjPAwFXUojZs13Y9NoHPphmf4isJf_uCicvYjRUCHuaNJ294Hc8v0W-xQaZncUlLzwRtIOMLCzSnXYjE7nlvK5NTD0%29%29/DisplayPatterns.aspx

Set visible property of a control inside girdview using Eval

your control id.visible='<%# Convert.ToString(Eval("Status"))=="" ? Boolean.Parse("True"):Boolean.Parse("False") %>'>