.Net Tech tips

Configure Folder or Web Site to Use SSL/HTTPS

noreply@blogger.com (Mahi) — Fri, 30 Nov 2012 09:13:00 +0000

Configure Folder or Web Site to Use SSL/HTTPS

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

Log on to the Web server computer as an administrator.
Click Start, point to Settings, and then click Control Panel.
Double-click Administrative Tools, and then double click Internet Services Manager.
Select the Web site from the list of different served sites in the left pane.
Right-click the Web site, folder, or file for which you want to configure SSL communication, and then click Properties.
Click the Directory Security tab.
Click Edit.
Click Require secure-channel (SSL) if you want the Web site, folder, or file to require SSL communications.
Click Require 128-bit encryption to configure 128-bit (instead of 40-bit) encryption support.
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.
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).
Click OK.

Speed up your queries

noreply@blogger.com (Mahi) — Fri, 30 Nov 2012 09:11:00 +0000

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

Date format error while migrating to sql 2008

noreply@blogger.com (Mahi) — Thu, 15 Nov 2012 09:49:00 +0000

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.

noreply@blogger.com (Mahi) — Wed, 12 Sep 2012 11:08:00 +0000

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

noreply@blogger.com (Mahi) — Tue, 19 Jun 2012 11:02:00 +0000

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

What is a DTS package?

noreply@blogger.com (Mahi) — Fri, 23 Mar 2012 07:32:00 +0000

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

noreply@blogger.com (Mahi) — Mon, 13 Feb 2012 18:07:00 +0000

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

MS word Automation

noreply@blogger.com (Mahi) — Tue, 20 Dec 2011 16:18:00 +0000

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

noreply@blogger.com (Mahi) — Mon, 14 Nov 2011 07:21:00 +0000

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

noreply@blogger.com (Mahi) — Thu, 10 Nov 2011 07:18:00 +0000

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

.Net Interview Questions for experienced Candidates

noreply@blogger.com (Mahi) — Thu, 10 Nov 2011 06:38:00 +0000

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?

noreply@blogger.com (Mahi) — Wed, 26 Oct 2011 10:22:00 +0000

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

noreply@blogger.com (Mahi) — Wed, 26 Oct 2011 10:19:00 +0000

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

noreply@blogger.com (Mahi) — Wed, 26 Oct 2011 10:16:00 +0000

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

noreply@blogger.com (Mahi) — Wed, 26 Oct 2011 10:12:00 +0000

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

noreply@blogger.com (Mahi) — Fri, 12 Aug 2011 04:41:00 +0000

Delete multiple records from grid view by selecting using check boxes

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

noreply@blogger.com (Mahi) — Thu, 11 Aug 2011 04:35:00 +0000

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

noreply@blogger.com (Mahi) — Tue, 02 Aug 2011 05:43:00 +0000

Import excel sheet into sql server using .net technologies

Regular expression library

noreply@blogger.com (Mahi) — Sat, 30 Jul 2011 09:14:00 +0000

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

noreply@blogger.com (Mahi) — Fri, 29 Jul 2011 06:53:00 +0000

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

Popup window using javascript

noreply@blogger.com (Mahi) — Thu, 28 Jul 2011 07:01:00 +0000

<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

noreply@blogger.com (Mahi) — Thu, 28 Jul 2011 06:34:00 +0000

Add this script inside head tag in html page

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

setTimeout("preventBack()", 0);

window.onunload=function(){null};

</script

Cross Browser HTML and CSS Compatibility

noreply@blogger.com (Mahi) — Thu, 28 Jul 2011 06:06:00 +0000

If you follow XHTML and CSS standards according to the XHTML and CSS version then no need to worry about the browser compatibility ..

Check your pages whether it follow using ,

http://validator.w3.org/

http://jigsaw.w3.org/css-validator/

http://www.w3.org/QA/Tools/

Disable Enter Key

noreply@blogger.com (Mahi) — Wed, 27 Jul 2011 12:29:00 +0000

<script language=javascript type=text/javascript>

function stopRKey(evt) {
   var evt = (evt) ? evt : ((event) ? event : null);
   var node = (evt.target) ? evt.target : ((evt.srcElement) ? evt.srcElement : null);
   if ((evt.keyCode == 13) && (node.type=="text")) {return false;}
}

document.onkeypress = stopRKey;

</script>

How browsers understand ASP.NET or PHP pages?

noreply@blogger.com (Mahi) — Wed, 27 Jul 2011 12:26:00 +0000

How browsers understand ASP.NET or PHP pages?

If visit any web site, no matter what technology is used to develop the site, your browser will be able to display the page for you. The only thing a browser can understand is "HTML". It does not know ASP.NET or PHP. So, even if your web site is developed using ASP.NET, still your browser can understand only HTML.

This is how it works:

You type a URL in your browser. (Eg: http://www.xyz/asp.net/lesson1.aspx)
Your browser will compose a request for this page and send to the web server in
internet. The web server analyzes the request and it understands that the request is for an ASP.NET page called "lesson1.aspx". So, the web server hand over the request to the aspnet service running as part of the web server. (If the page is a .php file,then there must be a php service running on the webserver).The aspnet service loads the page "lession1.aspx". Inside this page, we have written code to read the TutorialId passed as a parameter (parameters are called "Query String"). Our code gets this tutorial id and then retrieves the corresponding content from the database. Then our code embeds this content into the page and returns the dynamically modified page content to the web server. Web server returns the dynamically generated page to the browser. This dynamically generated page has only HTML in it, even though this html came from database. When the browser receives the page, it has only HTML. So, as far as a browser is concerned, it does not care what type of web site it is. It can be any technology like ASP.NET or PHP. It is the responsibility of the web server to generate dynamic content from database or wherever and give only HTML page content to the browser.