uso de parámetros desde visual basic

7/25/2019 Uso de Parmetros Desde Visual Basic

1/3

VISUAL BASIC.NET CON PARAMETROS EN SQL SERVER 2008

Uso de parmetros desde Vs!a" #as$.%et

NOTA&

'. Co"o$a !% S(")ataAdapter'* !% s("$o%%e$to%' + e" )ataSet''.2. E%"a,ar "os $o%tro"es a" )ataSet''

Imports S+stem.)ata.S("C"e%tP!#"$ C"ass -orm'

Prate S!# -orm'/LoadB+Va" se%der As S+stem.O#1e$t* B+Va" e As S+stem.Ee%tArs3 4a%d"esM+Base.Load )ataSet''.C"ear3 S(")ataAdapter'.-"")ataSet''3

E%d S!#

Prate S!# $mdI%sertar/C"$5B+Va" se%der As S+stem.O#1e$t* B+Va" e As S+stem.Ee%tArs3 4a%d"es$mdI%sertar.C"$5 )m se%te%$a As Str% S("Co%%e$to%'.Ope%3 se%te%$a 6 7I%sert %to C"e%te a"!es I)C"e%te* Nom#re* Ape""do*)re$$o%*Te"e9o%o*Ema"37 )m $oma%do As Ne: S("Comma%dse%te%$a* S("Co%%e$to%'3 $oma%do.Parameters.Add;t


2/3


Prate S!# $mdA$t!a",ar/C"$5B+Va" se%der As S+stem.O#1e$t* B+Va" e As S+stem.Ee%tArs34a%d"es $mdA$t!a",ar.C"$5 )m se%te%$a As Str% S("Co%%e$to%'.Ope%3 se%te%$a 6 7Update C"e%te set I)C"e%te6 I)C"e%te* Nom#re6Nom#re*

Ape""do6Ape""do*)re$$o%6 )re$$o%*Te"e9o%o6Te"e9o%o* Ema"6 Ema" :


3/3


BOTONES )E NAVE?ACI@N

Prate S!# $mdU"tmo/C"$5B+Va" se%der As S+stem.O#1e$t* B+Va" e As S+stem.Ee%tArs3 4a%d"es$mdU"tmo.C"$5Me.B%d%Co%te=t)ataSet''* 7C"e%te73.Posto% 6 Me.B%d%Co%te=t)ataSet''* 7C"e%te73.Co!%t '

E%d S!#

Prate S!# $mdA%teror/C"$5B+Va" se%der As S+stem.O#1e$t* B+Va" e As S+stem.Ee%tArs3 4a%d"es$mdA%teror.C"$5 Me.B%d%Co%te=t)ataSet''* 7C"e%te73.Posto% 6 '

E%d S!#

Prate S!# $mdPrmero/C"$5B+Va" se%der As S+stem.O#1e$t* B+Va" e As S+stem.Ee%tArs3 4a%d"es$mdPrmero.C"$5 Me.B%d%Co%te=t)ataSet''* 7C"e%te73.Posto% 6 0

E%d S!#

Prate S!# $mdS!e%te/C"$5B+Va" se%der As S+stem.O#1e$t* B+Va" e As S+stem.Ee%tArs3 4a%d"es$mdS!e%te.C"$5 Me.B%d%Co%te=t)ataSet''* 7C"e%te73.Posto% 6 '

E%d S!#

PRO-ESOR& >OSE RAUL CASTILLO R. P%a

uso de parámetros desde visual basic

Documents