Ø 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 ...
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...
WEB APPLICATION DEVELOPMENT(. NETframework) 1. Frame work is a collection of tool and libraries #Dot net framework environment 1. Solution Explore window – all types of resources, file creation , folder inside solution explore windows. 2. Server explore window- Only used databases. 3. Toolbox windows – All types of tool are provides in it (textbox, radiobutton etc). 4. Property window - representing all property(height, width , color). # APPLICATION DEVELOPMENT LANGUAGE(C#) 1.C# is pure object oriented 2.C # supported web application development environment . 3. Extenxion is .c# # How to created C # Application rules STEPS 1 file -> new -> project ->C# -> console App(.netFramework)-> selected browse-> selected your folder -> okay. Syntax:- using Syste...
Comments
Post a Comment