Ø 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 ...
DAY - 28-06-2003 l 3-tier architecture (TIER) 1. 3tier architecture provides three specific layer A. BussinessObject layer B. BussinessLogic layer C. DataAcess layer A. BussinessObject layer :- It only created data member as per database column. B. BussinessLogic Layer :- This layer only communicated with aspx page. C. DataAcess layer :- In this layer we work on database . l How to create 3 tier architecture? Step 1 :- create layer GO TO SOLUTION EXPLOSER -> RIGHT CLICK ON SOLUTION-------->CLICK ON NEW PROJECT ->SELECT CLASS LIBRARY (.NET FRAMEWORK)C# -> NAME OF LIBRARY. Step 2 :- create a class in each layer 1. BussinessLogic - classname=userBL. 2. BussinessObject - classname=userBO. 3. DataAccess-classname=userDA How to create a class :- Rightclick on the layer -> add class Step 3 - change all class to public which we made. All class is used for ...
Comments
Post a Comment