Converting Excel Worksheets and CSV files to a DataSet

http://weblogs.asp.net/donxml/archive/2003/08/21/24908.aspx

Send Email from Gmail in asp.net 2.0

http://dotnetguts.blogspot.com/2006/10/send-email-from-gmail-in-aspnet-20.html

Using Excel Sheets as a Database Backend

http://www.beansoftware.com/NET-Tutorials/Excel-ADO.NET-Database.aspx

How to remove duplicate rows from a SQL Server table by using a script

SELECT DISTINCT * INTO duplicate_table FROM original_table GROUP BY key_value HAVING COUNT(key_value) > 1

DELETE original_table WHERE key_value IN (SELECT key_value FROM duplicate_table)

INSERT original_table SELECT * FROM duplicate_table DROP TABLE duplicate_table

Connection to XLS using .NET

It is the simple program. it explains how to connect MS-Excel Database.
Background
Creating Table in Excel is very simple and easy. also fetch from Excel table is also very easy.
Using the codeFor Connect the Excel, we have to use the normal OLEDB connection as follows :
Collapse string Con_Str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DB_Path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";";

Here DB_Path is the location of the .XLS file.
"HDR=Yes;" indicates that the first row contains columnnames, not data."HDR=No;" indicates the opposite.
"IMEX=1;" tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. Note that this option might affect excel sheet write access negative.

License

Concurrency in asp.net

http://blah.winsmarts.com/2007-6-The_definitive_Concurrency_Management_in_ADONET_20_article.aspx

Regular Expresion validator strings

http://www.beansoftware.com/ASP.NET-Tutorials/Validation-Controls.aspx

Client side script for selected index changed of Drop Dwon list

function ddlAcquirerSelectedIndexChanged()
{
var ListBox1Id = '<%= ddlAcquirer.ClientID %>';
var TextBox1Id = '<%=txtAcquirer.ClientID %>';
var lblId='<%=lblAcquirer1.ClientID %>';
if (document.getElementById(ListBox1Id).selectedIndex >= 0)
{
var selectedIndex = document.getElementById(ListBox1Id).selectedIndex;
if(document.getElementById(ListBox1Id).options[selectedIndex].value=='Barclaycard')
{
document.getElementById(TextBox1Id).disabled=true;
document.getElementById(lblId).disabled=true;
document.getElementById('<%=lblBarclayardMerchantNo.ClientID %>').disabled=false;
document.getElementById('<%=txtBarclayardMerchantNo.ClientID %>').disabled=false;
}
else
{
document.getElementById(TextBox1Id).disabled=false;
document.getElementById(lblId).disabled=false;
document.getElementById('<%=lblBarclayardMerchantNo.ClientID %>').disabled=true;
document.getElementById('<%=txtBarclayardMerchantNo.ClientID %>').disabled=true;
}
}

And in Page load event in code behind

ddlAcquirer.Attributes.Add("onchange", "ddlAcquirerSelectedIndexChanged();")

Recipe: Implementing Role-Based Security with ASP.NET 2.0 using Windows Authentication and SQL Server

http://weblogs.asp.net/scottgu/pages/Recipe_3A00_-Implementing-Role_2D00_Based-Security-with-ASP.NET-2.0-using-Windows-Authentication-and-SQL-Server.aspx

calander Extender AJAX Control

http://www.dotnetcurry.com/ShowArticle.aspx?ID=149&AspxAutoDetectCookieSupport=1

calander extender Ajax Control

Tip 3: Enable Year Navigation in CalendarExtender
When the calendar appears, click on the title of the calendar to change the view to Months in the current year. Clicking it again, switches the view to Years, showing 10 years at a time.
If you plan to do this programmatically, here’s some code for you. Use the OnClientShown event and switch the mode using javascript. This tip was shared by one of the Microsoft® support person at the asp.net forums.


runat="server" TargetControlID="TextBox1" OnClientShown="ChangeCalendarView" />
Then add this to the section

ASP.NET 2.0: URL Mapping with RegEx Support

http://pietschsoft.com/post/2005/11/ASPNET-20-URL-Mapping-with-RegEx-Support.aspx

Selecting the row based on the row number in sql server 2005

select * from (SELECT ROW_NUMBER() OVER (ORDER BY pkuserid ASC) AS ROWID, * FROM users) as t where t.rowid=3