Translate

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;
        } ////