Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Index.aspx.cs" Inherits="WebApplication1.Index" %>
- <!DOCTYPE html>
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head runat="server">
- <title></title>
- </head>
- <body>
- <form id="form1" runat="server">
- <div>
- <asp:Label ID="Poruka" runat="server"></asp:Label>
- <script runat="server">
- protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
- {
- // Poruka ako je brisanje uspešno.
- if(e.Exception == null)
- {
- Poruka.Text = "Obrisan zapis.";
- }
- else
- {
- Poruka.Text = "Greska prilikom brisanja.";
- e.ExceptionHandled = true;
- }
- }
- protected void SqlDataSource1_Deleted(object sender, SqlDataSourceStatusEventArgs e)
- {
- // Poruka ako je brisanje uspešno.
- if(e.Exception == null)
- {
- Poruka.Text = "Obrisan zapis.";
- }
- else
- {
- Poruka.Text = "Greska prilikom brisanja.";
- e.ExceptionHandled = true;
- }
- }
- </script>
- <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RegistracijaAutomobilaConnectionString %>" SelectCommand="SELECT * FROM [Vozilo]"
- UpdateCommand="UPDATE [Vozilo]
- SET [Vozac]= @Vozac,
- [MarkaVozila]= @MarkaVozila,
- [VrstaVozila]= @VrstaVozila,
- [Godiste]= @Godiste,
- [SnagaMotora]= @SnagaMotora,
- [ZapreminaMotora]= @ZapreminaMotora,
- [VoziloRegistrovano]= @VoziloRegistrovano
- WHERE [Vozilo_ID]= @Vozilo_ID"
- DeleteCommand="DELETE FROM [Vozilo]
- Where[Vozilo_ID]=@Vozilo_ID"
- InsertCommand ="INSERT INTO [Vozilo]
- ([Vozilo_ID], [Vozac], [MarkaVozila], [VrstaVozila], [Godiste], [SnagaMotora], [ZapreminaMotora], [VoziloRegistrovano])
- VALUES (@Vozilo_ID, @Vozac, @MarkaVozila, @VrstaVozila, @Godiste, @SnagaMotora, @ZapreminaMotora, @VoziloRegistrovano)">
- <UpdateParameters>
- <asp:Parameter Name="Vozac" Type="Int32"> </asp:Parameter>
- <asp:Parameter Name="MarkaVozila" Type="Int32"> </asp:Parameter>
- <asp:Parameter Name="VrstaVozila" Type="Int32"></asp:Parameter>
- <asp:Parameter Name="Godiste" Type="Int32"></asp:Parameter>
- <asp:Parameter Name="SnagaMotora" Type="Int32"></asp:Parameter>
- <asp:Parameter Name="ZapreminaMotora" Type="Int32"></asp:Parameter>
- <asp:Parameter Name="VoziloRegistrovano" Type="Boolean"></asp:Parameter>
- </UpdateParameters>
- <InsertParameters>
- <asp:Parameter Name="Vozilo_ID" Type="Int32"> </asp:Parameter>
- <asp:Parameter Name="Vozac" Type="Int32"> </asp:Parameter>
- <asp:Parameter Name="MarkaVozila" Type="Int32"> </asp:Parameter>
- <asp:Parameter Name="VrstaVozila" Type="Int32"></asp:Parameter>
- <asp:Parameter Name="Godiste" Type="Int32"></asp:Parameter>
- <asp:Parameter Name="SnagaMotora" Type="Int32"></asp:Parameter>
- <asp:Parameter Name="ZapreminaMotora" Type="Int32"></asp:Parameter>
- <asp:Parameter Name="VoziloRegistrovano" Type="Boolean"></asp:Parameter>
- </InsertParameters>
- <DeleteParameters>
- <asp:Parameter Name="Vozilo_ID" Type="Int32"> </asp:Parameter>
- </DeleteParameters>
- </asp:SqlDataSource>
- <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:RegistracijaAutomobilaConnectionString %>" SelectCommand="SELECT * FROM [MarkaVozila]"
- UpdateCommand="UPDATE [MarkaVozila]
- SET [MarkaVozilaNaziv]= @MarkaVozilaNaziv
- WHERE [MarkaVozila_ID]= @MarkaVozila_ID"
- DeleteCommand="DELETE FROM [MarkaVozila]
- WHERE [MarkaVozila_ID]= @MarkaVozila_ID">
- <UpdateParameters>
- <asp:Parameter Name="MarkaVozilaNaziv" Type="String"> </asp:Parameter>
- </UpdateParameters>
- <DeleteParameters>
- <asp:Parameter Name="MarkaVozila_ID" Type="Int32"> </asp:Parameter>
- </DeleteParameters>
- </asp:SqlDataSource>
- <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:RegistracijaAutomobilaConnectionString %>" SelectCommand="SELECT * FROM [Vozac]"
- UpdateCommand="UPDATE [Vozac]
- SET [Ime]= @Ime,
- [Prezime]= @Prezime,
- [LicnaKarta]= @LicnaKarta,
- [SaobracajnaDozvola]= @SaobracajnaDozvola
- WHERE [Vozac_ID]= @Vozac_ID"
- DeleteCommand="DELETE FROM [Vozac]
- Where[Vozac_ID]=@Vozac_ID">
- <UpdateParameters>
- <asp:Parameter Name="Ime" Type="String"> </asp:Parameter>
- <asp:Parameter Name="Prezime" Type="String"> </asp:Parameter>
- <asp:Parameter Name="LicnaKarta" Type="Boolean"></asp:Parameter>
- <asp:Parameter Name="SaobracajnaDozvola" Type="Boolean"></asp:Parameter>
- </UpdateParameters>
- <DeleteParameters>
- <asp:Parameter Name="Vozac_ID" Type="Int32"> </asp:Parameter>
- </DeleteParameters></asp:SqlDataSource>
- <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:RegistracijaAutomobilaConnectionString %>" SelectCommand="SELECT * FROM [VrstaVozila]"
- UpdateCommand="UPDATE [VrstaVozila]
- SET [NazivVozila]= @NazivVozila
- WHERE [VrstaVozila_ID]= @VrstaVozila_ID"
- DeleteCommand="DELETE FROM [VrstaVozila]
- WHERE [VrstaVozila_ID]= @VrstaVozila_ID">
- <UpdateParameters>
- <asp:Parameter Name="NazivVozila" Type="String"> </asp:Parameter>
- </UpdateParameters>
- <DeleteParameters>
- <asp:Parameter Name="VrstaVozila_ID" Type="Int32"> </asp:Parameter>
- </DeleteParameters></asp:SqlDataSource>
- <a href="Uputstvo.aspx" class="someclass" contenteditable="false"> Uputstvo.aspx</a>
- <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False" CellPadding="4" DataKeyNames="Vozilo_ID" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" Height="50px" Width="1200px"
- AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" AutoGenerateColumns="False">
- <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
- <CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
- <EditRowStyle BackColor="#999999" HorizontalAlign="Center" />
- <FieldHeaderStyle BackColor="#E9ECF1" Font-Bold="True" />
- <Fields>
- <asp:BoundField DataField="Vozilo_ID" HeaderText="Vozilo_ID" ReadOnly="True" SortExpression="Vozilo_ID" />
- <asp:BoundField DataField="Vozac" HeaderText="Vozac" SortExpression="Vozac" />
- <asp:BoundField DataField="MarkaVozila" HeaderText="MarkaVozila" SortExpression="MarkaVozila" />
- <asp:BoundField DataField="VrstaVozila" HeaderText="VrstaVozila" SortExpression="VrstaVozila" />
- <asp:BoundField DataField="Godiste" HeaderText="Godiste" SortExpression="Godiste" />
- <asp:BoundField DataField="SnagaMotora" HeaderText="SnagaMotora" SortExpression="SnagaMotora" />
- <asp:BoundField DataField="ZapreminaMotora" HeaderText="ZapreminaMotora" SortExpression="ZapreminaMotora" />
- <asp:CheckBoxField DataField="VoziloRegistrovano" HeaderText="VoziloRegistrovano" SortExpression="VoziloRegistrovano" />
- </Fields>
- <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
- <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
- <RowStyle BackColor="#F7F6F3" ForeColor="#333333" HorizontalAlign="Left" VerticalAlign="Top" />
- </asp:DetailsView>
- <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="Vozac_ID" DataSourceID="SqlDataSource3" ForeColor="#333333" GridLines="None" Width="1200px"
- AutoGenerateDeleteButton="True" AutoGenerateEditButton="True">
- <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
- <Columns>
- <asp:BoundField DataField="Vozac_ID" HeaderText="Vozac_ID" ReadOnly="True" SortExpression="Vozac_ID" />
- <asp:BoundField DataField="Ime" HeaderText="Ime" SortExpression="Ime" />
- <asp:BoundField DataField="Prezime" HeaderText="Prezime" SortExpression="Prezime" />
- <asp:CheckBoxField DataField="LicnaKarta" HeaderText="LicnaKarta" SortExpression="LicnaKarta" />
- <asp:CheckBoxField DataField="SaobracajnaDozvola" HeaderText="SaobracajnaDozvola" SortExpression="SaobracajnaDozvola" />
- </Columns>
- <EditRowStyle BackColor="#999999" />
- <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
- <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
- <RowStyle BackColor="#F7F6F3" ForeColor="#333333" HorizontalAlign="Center" />
- <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
- <SortedAscendingCellStyle BackColor="#E9E7E2" />
- <SortedAscendingHeaderStyle BackColor="#506C8C" />
- <SortedDescendingCellStyle BackColor="#FFFDF8" />
- <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
- </asp:GridView>
- <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="MarkaVozila_ID" DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None" Width="1200px"
- AutoGenerateDeleteButton="True" AutoGenerateEditButton="True">
- <AlternatingRowStyle BackColor="White" ForeColor="#284775" HorizontalAlign="Center" VerticalAlign="Middle" />
- <Columns>
- <asp:BoundField DataField="MarkaVozila_ID" HeaderText="MarkaVozila_ID" ReadOnly="True" SortExpression="MarkaVozila_ID" />
- <asp:BoundField DataField="MarkaVozilaNaziv" HeaderText="MarkaVozilaNaziv" SortExpression="MarkaVozilaNaziv" />
- </Columns>
- <EditRowStyle BackColor="#999999" HorizontalAlign="Center" VerticalAlign="Middle" />
- <EmptyDataRowStyle HorizontalAlign="Center" VerticalAlign="Middle" />
- <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
- <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
- <RowStyle BackColor="#F7F6F3" ForeColor="#333333" HorizontalAlign="Center" />
- <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
- <SortedAscendingCellStyle BackColor="#E9E7E2" />
- <SortedAscendingHeaderStyle BackColor="#506C8C" />
- <SortedDescendingCellStyle BackColor="#FFFDF8" />
- <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
- </asp:GridView>
- <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="VrstaVozila_ID" DataSourceID="SqlDataSource4" ForeColor="#333333" GridLines="None" Width="1200px"
- AutoGenerateDeleteButton="True" AutoGenerateEditButton="True">
- <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
- <Columns>
- <asp:BoundField DataField="VrstaVozila_ID" HeaderText="VrstaVozila_ID" ReadOnly="True" SortExpression="VrstaVozila_ID" />
- <asp:BoundField DataField="NazivVozila" HeaderText="NazivVozila" SortExpression="NazivVozila" />
- </Columns>
- <EditRowStyle BackColor="#999999" />
- <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
- <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
- <RowStyle BackColor="#F7F6F3" ForeColor="#333333" HorizontalAlign="Center" VerticalAlign="Middle" />
- <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
- <SortedAscendingCellStyle BackColor="#E9E7E2" />
- <SortedAscendingHeaderStyle BackColor="#506C8C" />
- <SortedDescendingCellStyle BackColor="#FFFDF8" />
- <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
- </asp:GridView>
- <asp:DetailsView ID="DetailsView2" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" Height="50px" OnPageIndexChanging="DetailsView2_PageIndexChanging" Width="600px"
- AutoGenerateInsertButton="True" AutoGenerateRows="False" DataKeyNames="Vozilo_ID" DataSourceID="SqlDataSource1">
- <AlternatingRowStyle BackColor="White" />
- <CommandRowStyle BackColor="#C5BBAF" Font-Bold="True" />
- <EditRowStyle BackColor="#7C6F57" />
- <FieldHeaderStyle BackColor="#D0D0D0" Font-Bold="True" />
- <Fields>
- <asp:BoundField DataField="Vozilo_ID" HeaderText="Vozilo_ID" ReadOnly="True" SortExpression="Vozilo_ID" />
- <asp:BoundField DataField="Vozac" HeaderText="Vozac" SortExpression="Vozac" />
- <asp:BoundField DataField="MarkaVozila" HeaderText="MarkaVozila" SortExpression="MarkaVozila" />
- <asp:BoundField DataField="VrstaVozila" HeaderText="VrstaVozila" SortExpression="VrstaVozila" />
- <asp:BoundField DataField="Godiste" HeaderText="Godiste" SortExpression="Godiste" />
- <asp:BoundField DataField="SnagaMotora" HeaderText="SnagaMotora" SortExpression="SnagaMotora" />
- <asp:BoundField DataField="ZapreminaMotora" HeaderText="ZapreminaMotora" SortExpression="ZapreminaMotora" />
- <asp:CheckBoxField DataField="VoziloRegistrovano" HeaderText="VoziloRegistrovano" SortExpression="VoziloRegistrovano" />
- </Fields>
- <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
- <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
- <RowStyle BackColor="#E3EAEB" />
- </asp:DetailsView>
- <br />
- </div>
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement