C# string formation

// two decimal places
String.Format("{0:0.00}", 324.4567); // "324.46"
String.Format("{0:0.00}", 324.4); // "324.40"
String.Format("{0:0.00}", 324.0); // "324.00"

// maximum two decimal places
String.Format("{0:0.##}", 324.4567); // "324.46"
String.Format("{0:0.##}", 324.4); // "324.4"
String.Format("{0:0.##}", 324.0); // "324"

// at least 2 digits before decimal point
String.Format("{0:00.0}", 324.4567); // "324.5"
String.Format("{0:00.0}", 23.4567); // "23.5"
String.Format("{0:00.0}", 3.4567); // "03.5"
String.Format("{0:00.0}", -3.4567); // "-03.5"

Javascript valdation for textbox langth valdation

< script type="text/javascript" language="javascript" >
function checkCharacterLimit(TB)
{
var maxCharacters = 200;
var withinCharacterLimit = true;
var ValidateTB = document.getElementById(TB.id);
var charCode = ( event.which ) ? event.which : event.keyCode;
var bool=(charCode =="8" || charCode =="46");
if (ValidateTB.value.length > maxCharacters && !bool)
{
withinCharacterLimit = false;
}
return withinCharacterLimit;
}
< /script >

in c# code Add following code

txtJobDiscription1.Attributes.Add("onKeyDown", "return checkCharacterLimit(this);");

Command field - Giving a confirmation when deleting C#

protected void gvProjectList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
// loop all data rows
foreach (DataControlFieldCell cell in e.Row.Cells)
{
// check all cells in one row
foreach (Control control in cell.Controls)
{
//Links as the command button.
LinkButton button = control as LinkButton;
if (button != null && button.CommandName == "Delete")
// Add delete confirmation
button.OnClientClick = "if (!confirm('Are you sure " +
"you want to delete this record?')) return false;";
}
}
}
}

Cannot create database diagrams Issue - Configuration Fix

--Run this Code in sql qurry window

EXEC sp_dbcmptlevel 'your Database Name', '90';
go
ALTER AUTHORIZATION ON DATABASE::[DatabaseName] TO "YourLoginName"
go
use [DatabaseName]
go
EXECUTE AS USER = N'dbo' REVERT
go

String Format for DateTime [C#]

String Format for DateTime [C#]


DateTime dt = new DateTime(2008, 3, 9, 16, 5, 7, 123);

String.Format("{0:y yy yyy yyyy}", dt); // "8 08 008 2008" year
String.Format("{0:M MM MMM MMMM}", dt); // "3 03 Mar March" month
String.Format("{0:d dd ddd dddd}", dt); // "9 09 Sun Sunday" day
String.Format("{0:h hh H HH}", dt); // "4 04 16 16" hour 12/24
String.Format("{0:m mm}", dt); // "5 05" minute
String.Format("{0:s ss}", dt); // "7 07" second
String.Format("{0:f ff fff ffff}", dt); // "1 12 123 1230" sec.fraction
String.Format("{0:F FF FFF FFFF}", dt); // "1 12 123 123" without zeroes
String.Format("{0:t tt}", dt); // "P PM" A.M. or P.M.
String.Format("{0:z zz zzz}", dt); // "-6 -06 -06:00" time zone

// date separator in german culture is "." (so "/" changes to ".")
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9/3/2008 16:05:07" - english (en-US)
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9.3.2008 16:05:07" - german (de-DE)


// month/day numbers without/with leading zeroes
String.Format("{0:M/d/yyyy}", dt); // "3/9/2008"
String.Format("{0:MM/dd/yyyy}", dt); // "03/09/2008"

// day/month names
String.Format("{0:ddd, MMM d, yyyy}", dt); // "Sun, Mar 9, 2008"
String.Format("{0:dddd, MMMM d, yyyy}", dt); // "Sunday, March 9, 2008"

// two/four digit year
String.Format("{0:MM/dd/yy}", dt); // "03/09/08"
String.Format("{0:MM/dd/yyyy}", dt); // "03/09/2008"

Could not load type 'System.Web.UI.Compatibility.CompareValidator' from assembly 'System.Web.Extensions' Issue Fixing

Things were working good but after installing ASP.NET AJAX 1.0 I was Getting most probably this error


FIXES Bellow

Step 1. I have downloaded validators from:
http://blogs.msdn.com/mattgi/attachment/1516974.ashx

Step 2. I had below mappings in web.config:
Step 2. I had below mappings in web.config:
<tagMappingglt;
<add tagType="System.Web.UI.WebControls.CompareValidator" mappedTagType="System.Web.UI.Compatibility.CompareValidator, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/glt;
<add tagType="System.Web.UI.WebControls.CustomValidator" mappedTagType="System.Web.UI.Compatibility.CustomValidator, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/glt;
<add tagType="System.Web.UI.WebControls.RangeValidator" mappedTagType="System.Web.UI.Compatibility.RangeValidator, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/glt;
<add tagType="System.Web.UI.WebControls.RegularExpressionValidator" mappedTagType="System.Web.UI.Compatibility.RegularExpressionValidator, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/glt;
<add tagType="System.Web.UI.WebControls.RequiredFieldValidator" mappedTagType="System.Web.UI.Compatibility.RequiredFieldValidator, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/glt;
<add tagType="System.Web.UI.WebControls.ValidationSummary" mappedTagType="System.Web.UI.Compatibility.ValidationSummary, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/glt;
</tagMappingglt;

Replaced above with :
<tagMappingglt;
<add tagType="System.Web.UI.WebControls.CompareValidator" mappedTagType="Sample.Web.UI.Compatibility.CompareValidator, Validators, Version=1.0.0.0"/glt;
<add tagType="System.Web.UI.WebControls.CustomValidator" mappedTagType="Sample.Web.UI.Compatibility.CustomValidator, Validators, Version=1.0.0.0"/glt;
<add tagType="System.Web.UI.WebControls.RangeValidator" mappedTagType="Sample.Web.UI.Compatibility.RangeValidator, Validators, Version=1.0.0.0"/glt;
<add tagType="System.Web.UI.WebControls.RegularExpressionValidator" mappedTagType="Sample.Web.UI.Compatibility.RegularExpressionValidator, Validators, Version=1.0.0.0"/glt;
<add tagType="System.Web.UI.WebControls.RequiredFieldValidator" mappedTagType="Sample.Web.UI.Compatibility.RequiredFieldValidator, Validators, Version=1.0.0.0"/glt;
<add tagType="System.Web.UI.WebControls.ValidationSummary" mappedTagType="Sample.Web.UI.Compatibility.ValidationSummary, Validators, Version=1.0.0.0"/glt;
</tagMappingglt;

Asp.net datagrid Using template field det particular datakey

protected void gvleaveHistory_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strLeaveId = e.CommandArgument.ToString();//gvleaveHistory.DataKeys[e.RowIndex]["LeaveId"].ToString().Trim();
if (strLeaveId != string.Empty)
{

Leave objLeave = new Leave();
objLeave.DeleteLeaveByLeaveId(Convert.ToInt32(strLeaveId));
LoadInitialDataForHistry();
LoadInitialData();
}
}


======ASPX Code============
<ItemTemplate >
<asp:LinkButton ID="lnkCancel" runat="server" OnClick="lnkCancel_Click" CommandArgument='<%# Eval("LeaveId")%>'> Cancel </asp:LinkButton >
</ItemTemplate >