4eme jours du Préparation TDI2 (sa commence)

merci M.hicham

Salam drari insha2alah nkhadmo les trucs kamlin
ana ran7awl m3a had exercice
+
bnisba n trigger li kano talbin drari dyal modification dyal format du telephone ana ra di ktbo daba !
create trigger tr1 on table
for insert,update
declare @c int ,@t varchar(25)
select @c=code,@t=tel from inserted
declare @tl varchar(25)
set @tl=''
declare @i int
set @i=1
while (@i<length(@t))
begin
@tl=substring (@t,@i,2) +'.'
set @i=@i+2
end
update table
set tel=@tl
where code=@c
end

ok Mr.Adil merci pr votre participation

Alkhout bnisba n dropdownlist machi f7al combobox f ado.net
kayn difference
f ex1 dirt :
hadxi f load :

DropDownList1.Items.Clear()
con.Open()
cmd.Connection = con
cmd.CommandText = "select * from classe"
dr = cmd.ExecuteReader
Do While dr.Read
DropDownList1.Items.Add(dr(1))
arr.Add(dr(0))
Loop
con.Close()
wf linkbutton :


ListBox1.Items.Clear()
con.Open()
cmd2.Connection = con
cmd2.CommandText = "select eleve.id,eleve.nom,eleve.prenom from eleve where and eleve.idclasse ='" & arr(DropDownList1.index) & "'"
dr2 = cmd2.ExecuteReader
Do While dr2.Read
ListBox1.Items.Add(dr2(0) & "-" & dr2(1) & "-" & dr2(2))
Loop
con.Close()


mais evenement dyal dropdownlist.index makaynachi machi f7al combobox
kayn chi solution akhor mn 8ir arraylist ?