1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:basedossierConnectionString %>"
InsertCommand="INSERT INTO dossier(num_dossier, num_envoi_commune, num_arrivee_agence, date_arrivee_agence, observation, petitionaire, date_envoi_commun, idautre_avis, date_envoi_agance, num_envoi_agence, id_commune, code_projet, reference_fonciere, id_Archetecte, id_topographe) VALUES (@num_dossier, @num_envoi_commune, @num_arrivee_agence, @date_arrivee_agence, @observation, @petitionaire, @date_envoi_commun, @idautre_avis, @date_envoi_agance, @num_envoi_agence, @id_commune, @code_projet, @reference_fonciere, @id_Archetecte, @id_topographe)"
SelectCommand="SELECT * FROM [dossier]"
ProviderName="<%$ ConnectionStrings:basedossierConnectionString.ProviderName %>">
<InsertParameters>
<asp:Parameter Name="num_dossier" />
<asp:Parameter Name="num_envoi_commune" />
<asp:Parameter Name="num_arrivee_agence" />
<asp:Parameter Name="date_arrivee_agence" />
<asp:Parameter Name="observation" />
<asp:Parameter Name="petitionaire" />
<asp:Parameter Name="date_envoi_commun" />
<asp:Parameter Name="idautre_avis" />
<asp:Parameter Name="date_envoi_agance" />
<asp:Parameter Name="num_envoi_agence" />
<asp:Parameter Name="id_commune" />
<asp:Parameter Name="code_projet" />
<asp:Parameter Name="reference_fonciere" />
<asp:Parameter Name="id_Archetecte" />
<asp:Parameter Name="id_topographe" />
</InsertParameters>
</asp:SqlDataSource>
<asp:TextBox ID="date" runat="server" AutoCompleteType="HomeState"></asp:TextBox>
<asp:FormView ID="FormView1" runat="server" DataKeyNames="num_dossier"
DataSourceID="SqlDataSource1" DefaultMode="Insert"
style="margin-right: 0px; position: relative; top: -28px; left: 218px; height: 345px; margin-left: 28px;"
Width="573px" CellPadding="4" ForeColor="#333333">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<InsertItemTemplate>
<table>
<tr><td>
Province:
</td><td>
<asp:DropDownList ID="ProvinceDownList" runat="server"
DataSourceID="ProvinceSqlDataSource" DataTextField="nom_province"
DataValueField="id_province" AutoPostBack="True"
onselectedindexchanged="ProvinceDownList_SelectedIndexChanged" >
</asp:DropDownList>
<asp:SqlDataSource ID="ProvinceSqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:basedossierConnectionString %>"
SelectCommand="SELECT * FROM [province] WHERE ([id_region] = @id_region)">
<SelectParameters>
<asp:ControlParameter ControlID="RegionList" Name="id_region"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</td></tr>
<tr><td>
Region:
</td><td>
<asp:DropDownList ID="RegionList" runat="server" AutoPostBack="True"
DataSourceID="RegionSqlDataSource" DataTextField="nom_region"
DataValueField="id_region" >
</asp:DropDownList>
<asp:SqlDataSource ID="RegionSqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:basedossierConnectionString %>"
SelectCommand="SELECT * FROM [region]"></asp:SqlDataSource>
</td></tr>
<tr><td>
Commune:
</td><td>
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="CommuneSqlDataSource"
DataTextField="nom_commune" DataValueField="id_commune">
</asp:DropDownList>
<asp:SqlDataSource ID="CommuneSqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:basedossierConnectionString %>"
SelectCommand="SELECT * FROM [commune] WHERE ([id_province] = @id_province)">
<SelectParameters>
<asp:ControlParameter ControlID="ProvinceDownList" Name="id_province"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</td></tr></table>
</InsertItemTemplate>
</asp:FormView>
</asp:Content> |
Partager