Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UpdateCommand="UPDATE dbo.abit$ SET
- state = @state,
- vstup1 = (SELECT cod FROM exams$ WHERE name=@exname1),
- vstup2 = @exname2,
- vstup3 = @exname3,
- vstup4 = @exname4,
- vstup5 = @exname5,
- vstup6 = @exname6,
- vstup7 = @exname7,
- pol = @pol,
- att_or_dip = @att_or_dip,
- school = @school,
- note1 = @note1,
- note2 = @note2,
- note3 = @note3,
- note4 = @note4,
- note5 = @note5,
- note6 = @note6,
- note7 = @note7,
- birthday=@birthday,
- year_end = @year_end,
- [sattestat] = @sattestat,
- [nattestat] = @nattestat,
- [spusport] = @spusport,
- [npusport] = @npusport,
- [sv_o_puspo] = @sv_o_puspo,
- adres = @adres
- WHERE (number = @number) AND (FLOOR(DATEDIFF(day, birthday, GETDATE()) / 365.25) < 100) AND (NOT(FLOOR(DATEDIFF(day, birthday, GETDATE()) / 365.25)<15))"
- >
- <UpdateParameters>
- <asp:QueryStringParameter Name="number" QueryStringField="number" Type="Double" />
- <asp:formparameter name="state" formfield="DropDownList2" />
- <asp:formparameter name="exname1" formfield="DropDownList4"/>
- <asp:formparameter name="exname2" formfield="DropDownList5" />
- <asp:formparameter name="exname3" formfield="DropDownList6" />
- <asp:formparameter name="exname4" formfield="DropDownList7" />
- <asp:formparameter name="exname5" formfield="DropDownList8" />
- <asp:formparameter name="exname6" formfield="DropDownList9" />
- <asp:formparameter name="exname7" formfield="DropDownList10" />
- <asp:formparameter name="pol" formfield="DropDownList1" />
- <asp:formparameter name="att_or_dip" formfield="DropDownList3" />
- </UpdateParameters>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement