ALTER PROCEDURE [dbo].[uspUpdateEmployee]
@UserName varchar(50),
@JoinDate datetime,
@PermantApprovedDate datetime,
@IsActive bit,
@EmployeeStatus int
AS
DECLARE @IsPermentEmployeeVal BIT
IF(@EmployeeStatus = 1)
BEGIN
SET @IsPermentEmployeeVal=1
END
ELSE
BEGIN
SET @IsPermentEmployeeVal = 0
END
UPDATE tblEmployees
SET
[LastModifiedDate] = Getdate(),
[PermantApprovedDate] = @PermantApprovedDate,
[JoinedDate] = @JoinDate,
[IsActive]=@IsActive,
[EmployeeStatus] =@EmployeeStatus,
IsPermentEmployee=@IsPermentEmployeeVal
WHERE UserName=@UserName
Tuesday, April 28, 2009
Friday, April 24, 2009
Changing the text in a Div using java script
java script code
================
document.getElementById("divMenuText").innerText="Title for top level menu";
html code
=========
< td width="130" > <div id="divMenuText" > Menu Text:</div > </td >
================
document.getElementById("divMenuText").innerText="Title for top level menu";
html code
=========
< td width="130" > <div id="divMenuText" > Menu Text:</div > </td >
Close the browser window Using C# code
StringBuilder postBackScript = new StringBuilder();
postBackScript.Append("< script language=JavaScript >");
postBackScript.Append("self.close(); ");
postBackScript.Append("</script >");
if (!Page.ClientScript.IsClientScriptBlockRegistered("parentCallBack"))
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "parentCallBack", postBackScript.ToString());
postBackScript.Append("< script language=JavaScript >");
postBackScript.Append("self.close(); ");
postBackScript.Append("</script >");
if (!Page.ClientScript.IsClientScriptBlockRegistered("parentCallBack"))
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "parentCallBack", postBackScript.ToString());
return false in javascript message box
this.btnLogOut.Attributes.Add("OnClick", "window.close(); return false;");
Set Culture setting from web config and get required Date time format
< globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="en-AU" uiCulture="en-AU"/>
Subscribe to:
Posts (Atom)