10-may - 2003 (missing)

 Missing 

Comments

Post a Comment

Popular posts from this blog

Store procedure Data Base handling (procedure_insert).

Image
  Ø  Store procedure Data Base handling  (procedure_insert). 1.  Include procdure library (system.data). 2.  Pass procedure name to sqlcommand parameters. Syntax :- com= new sqlcommand(“procedure name”,connection object) 3.  Set the command type (store procedure) Syntax :-com.CommandType=commandtype.storeprocedure     STORE PROCEDURE CREATE   PROCEDURE  PROCON   ( @ROLL1 AS    INT   ,  @NAME1 AS   VARCHAR ( 50 ))   AS     BEGIN   INSERT   INTO  DEMO   ( ROLL ,   NAME   )   VALUES ( @ROLL1 ,  @NAME1 )     END   ;             using  System; using  System.Collections.Generic; using  System.Linq; using  System.Web; using  System.Web.UI; using  System.Web.UI.WebControls; using  System.Data; using  System.Data.SqlClient;     public   partial   class   ...
Read more

Database joining

Image
  l  Database joining :- 1.  Joining is a special type of operation perform between 2 tables. 2.  With the help of joining we get the result between multiple data. l  Joining property:- 1.  Common field (column) 2.  Using table object Syntax :-  table name.column name 3.  To activate joining operaton we need  ON  KEYWORD. ü  TYPES OF JOINING:- 1.  INNER JOIN  :- Inner join returns all records from multiple data where the join condition is equal. Ex:- CREATE   TABLE  invent   (  id INT   ,   name   VARCHAR ( 20 )); INSERT   INTO  invent values ( 101 , 'rahul' ),( 103 , 'thosar' ),( 102 , 'asus' );   CREATE   TABLE  product   ( id INT   ,  cost int );   INSERT   INTO  product VALUES ( 201 , '1000' ),( 202 , '2000' ),( 203 , '30000' );   SELECT  invent . id ,  invent . name ,  product . cost FROM  invent INN...
Read more

New html

 padding: 10px;             margin-top: 15px;             background: #28a745;             border: none;             color: white;             font-size: 16px;             border-radius: 4px;             cursor: pointer;         }         .btn:hover {             background: #218838;         }         .message {             margin-top: 10px;             text-align: center;             font-weight: bold;         }     </style> </head> <body>     <form id="form1" runat="server">         <div clas...
Read more