Translate

Wednesday 31 December 2014

Disable Right Click of Page in c#

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Sample to Disable Right Click of Page</title>
<script language="JavaScript" type="text/javascript">
    //Message to display whenever right click on website
    var message = "Sorry, Right Click have been disabled.";
    function click(e) {
        if (document.all) {
            if (event.button == 2 || event.button == 3) {
                alert(message);
                return false;
            }
        }
        else {
            if (e.button == 2 || e.button == 3) {
                e.preventDefault();
                e.stopPropagation();
                alert(message);
                return false;
            }
        }
    }
    if (document.all) {
        document.onmousedown = click;
    }
    else {
        document.onclick = click;
    }
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
</form>
</body>
</html>
from Suresh
-----

Monday 29 December 2014

Sunday 21 December 2014

sql server restore database query

RESTORE DATABASE PabitraDemoDb

FROM DISK='d:\PabitraDemoDb.bak'

code sample for windows form

Code sample for windows form
From Microsoft...
Click here for see More sample Code
http://msdn.microsoft.com/en-us/library/aa287561%28v=vs.71%29.aspx

Monday 15 December 2014

inserted trigger in sql server


CREATE TABLE [dbo].[tblTRIGGERMAST1](
[ID] [varchar](10) NOT NULL PRIMARY KEY,
[NAME] [varchar](20) NULL,
[PHONE] [int] NULL
)

CREATE TABLE [dbo].[tblTRIGGER2](
[ID] [int] IDENTITY(1001,1) PRIMARY KEY NOT NULL,
[IDMAST] [varchar](10) NULL,
[PHONE] [int] NULL,
[DATE] [datetime] NULL
)
CREATE  TRIGGER Triger_On_tblTRIGGERMAST1
ON  tblTRIGGERMAST1
AFTER INSERT
AS
BEGIN

SET NOCOUNT ON;
declare @ID int
declare @Phone int
declare @Result varchar(100)
select @ID=ID from inserted
select @Phone =PHONE from inserted
INSERT INTO tblTRIGGER2(IDMAST,PHONE)VALUES(@ID,@Phone)
set @Result=convert(varchar,'The Inserted Values Are Inserted in Table tblTRIGGER2:ID IS:  ')
+convert(varchar,@ID)+convert(varchar,' pHONE nO  Is: ')+convert(varchar,@Phone)
Print @Result

END
insert into tblTRIGGERMAST1(ID,NAME,PHONE)values(1004,'PABITRA BEHERA',828989)

-------------
---THE RESULT WILL BE
The Inserted Values Are Insert1004 pHONE nO  Is: 828989

(1 row(s) affected)

Friday 12 December 2014

Create a Full Database Backup In SQL Server

Create a Full Database Backup  In SQL Server



BACKUP DATABASE DataBaseName TO DISK = 'D:\BackupName.bak'
Example
DataBase name:DbPabitra
BACKUP DATABASE DbPabitra TO DISK = 'D:\DataBaseBacup.bak'
For More Informatation
http://pabitramicrosoftresearch.blogspot.in/

Thursday 27 November 2014

DDL TRIGGER FOR ALL DATABASE CREATE,ALTER,DELETE TABLE IN SQLSERVER

---For All Server(DataBase)
ALTER trigger NoTable
on all server
for CREATE_TABLE,ALTER_TABLE,DROP_TABLE
AS BEGIN
PRINT 'NO NEW TABLE PLEASE'
ROLLBACK
END

disable or enable trigger in sql server 2008

enable     trigger NoTable on database
disable     trigger NoTable on database

DDL trigger for no new table in sql server

create database demo
create trigger NoTable
on database
for CREATE_TABLE
AS BEGIN
PRINT 'NO NEW TABLE PLEASE'
ROLLBACK
END
------------------------------------

------------
After executing trigger NoTable
then run 
CREATE TABLE EMPPP(ID INT, NAME VARCHAR(50))
---------
the result will be
------------
NO NEW TABLE PLEASE
Msg 3609, Level 16, State 2, Line 1
The transaction ended in the trigger. The batch has been aborted.

Monday 24 November 2014

how to change server side div background images

how to change server side div background images
any one can help me....
my code is ..
 <div id="divID" runat="server" > </div>

 divID.Style["background-image"] = Page.ResolveUrl("~/body/backShadow.png");

Friday 21 November 2014

Panel BackImageUrl not Working

Please Any one Can Help Me
:

 Panel1.BackImageUrl = "s.png";
        Panel1.BackImageUrl = "http://localhost:49620/WebSite4/s.png";

Thursday 13 November 2014

Switch Case In ASp.net With Examples By Pabitra

 Switch Case In ASp.net For Clear Method
 ------------------------------------------------------------------
 private void DesableEnableClear(string Status)
    {
  TextBox[] arr = { txtHeltID, txtHelthType };
   switch (Status)
   {
    case "D":
           foreach (TextBox txt in arr)
           {
            txt.Enabled = false;
           }
           txtHeltID.Text = "";
           break;        
    case "E":
            foreach (TextBox txt in arr)
            {
                txt.Enabled = true;
            }
            txtHeltID.Text = LoadMaxID();
            break;
    case "C":
           foreach (TextBox txt in arr)
            { txt.Text = ""; }
            btnSave.Enabled = true;
            txtHeltID.Text = LoadMaxID();
            break;
    case "GL":
            btnSave.Enabled = true;          
            btnDelete.Enabled = false;
            btnUpdate.Enabled = false;
            panelg.Visible = true;
            break;
    case "GR":
            btnSave.Enabled = false;
            btnDelete.Enabled = true;
            btnUpdate.Enabled = true;
            panelg.Visible = false;
            break;
       case "U":
           btnSave.Enabled = true;         
            btnDelete.Enabled = false;
            btnUpdate.Enabled = false;
            panelg.Visible = false;
            break;
      case "SD":
            lblSearch.Visible = false;
            txtSearch.Visible = false;
            break;
      case "SE":
            lblSearch.Visible = true;
             txtSearch.Visible = true;
            break;
      default :
           // Response.Write("Hello");
            break;
        } ////