Programmer DétailsView manuellement

Bonjour,

ci-dessous le code que j'ai pu mettre en place que ce soit partie Code Bihind et code Asp.Net:

Code:

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
 
    protected void BtnRecherche_Click(object sender, EventArgs e)
    {
        SqlConnection connection = new SqlConnection("Data Source=Server;Initial Catalog=TWEM;Persist Security Info=True;User ID=user;Password=passw");
        try
        {
            connection.Open();
        }
        catch (Exception ex)
        {
            resultatlbl.Text = ex.Message;
        }
        try
        {
            string sSql;
            sSql = "SELECT * From TBLTEST Where Nom Like '" + TxtBoxRecherche1.Text + "%' AND Prenom Like '" + TxtBoxRecherche2.Text + "%'";
 
            SqlCommand cmd = new SqlCommand(sSql, connection);
            SqlDataReader reader = cmd.ExecuteReader();
            Gvtest.DataSource = reader;
            Gvtest.DataBind();
            reader.Close();
 
        }
        catch (Exception ex)
        {
            resultatlbl.Text = ex.Message;
        }
        finally
        {
            connection.Close();
        }    
    }

Code:

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
 
<body>
    <form id="form1" runat="server">
    <div>
        <table width="100%">
            <tr>
                <td style="text-align: left; height: 33px;" colspan="2">
                    <span style="font-size: 16pt">
                    Rechercher un Enregistrement ...</span></td>
            </tr>            
            <tr>
                <td style="width: 195px">
                    Par Raison Sociale :</td>
                <td>
                    <asp:TextBox ID="TxtBoxRecherche1" runat="server" Width="195px"></asp:TextBox>
                    et /
                    ou</td>
            </tr>
            <tr>
                <td style="width: 195px">
                    Par N° Client :</td>
                <td>
                    <asp:TextBox ID="TxtBoxRecherche2" runat="server" Width="195px"></asp:TextBox></td>
            </tr>
            <tr>
                <td align="right" style="width: 195px">
                    <asp:Button ID="BtnRecherche" runat="server" Text="Rechercher ..." OnClick="BtnRecherche_Click" /></td>
                <td>
                    <asp:Button ID="BtnEffacer" runat="server" Text="Effacer" Width="105px" /></td>
            </tr>
            <tr>
                <td style="width: 195px; height: 21px;">
                </td>
                <td style="width: 268px; height: 21px;">
                </td>
            </tr>
            <tr>
                <td colspan="2" style="height: 185px">
                    <asp:Panel ID="Panel1" runat="server" Height="170px" ScrollBars="Auto" Width="470px">
                        <asp:GridView ID="Gvtest" runat="server" CellPadding="4" ForeColor="#333333"
                            Width="576px" AutoGenerateColumns="False" Font-Bold="True" Font-Names="Arabic Transparent" HorizontalAlign="Left" DataKeyNames="ID" EmptyDataText = "Aucun résultat Trouvé" >
                            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                            <RowStyle BackColor="#E3EAEB" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" />
                            <EditRowStyle BackColor="#7C6F57" />
                            <SelectedRowStyle BackColor="Gold" Font-Bold="True" ForeColor="#333333" Font-Italic="False" Font-Underline="False" />
                            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" Font-Size="16pt" />
                            <AlternatingRowStyle BackColor="White" />
                            <Columns>
                                <asp:CommandField ShowSelectButton="True" />
                                <asp:BoundField DataField="Nom" HeaderText="Le Nom" />
                                <asp:BoundField DataField="Prenom" HeaderText="Le Prenom" />
                                <asp:BoundField DataField="Etat" HeaderText="l'Etat" />
                                <asp:BoundField DataField="Actif" HeaderText="Activation" />
                                <asp:BoundField DataField="ID" HeaderText="ID" Visible="False" />
                            </Columns>
                        </asp:GridView>
                    </asp:Panel>
                </td>
            </tr>
          </table>
 
    </div>
        <br />
        &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
        &nbsp;
        <asp:SqlDataSource ID="DSource" runat="server" ConnectionString="<%$ ConnectionStrings:TwemConnectionString %>"
            DeleteCommand="DELETE FROM [TBLTEST] WHERE [ID] = @ID" 
            InsertCommand="INSERT INTO [TBLTEST] ([NOM], [Prenom], [Etat], [ACTIF] VALUES (@NOM, @Prenom, @Etat, @ACTIF, @Utilisateur)"
            SelectCommand="SELECT * FROM [TBLTEST] WHERE ([ID] = @ID)" 
            UpdateCommand="UPDATE [TBLTEST] SET [NOM] = @NOM, [Prenom] = @Prenom, [Etat] = @Etat, [ACTIF] = @ACTIF WHERE [ID] = @ID">
            <DeleteParameters>
                <asp:Parameter Name="ID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="NOM" Type="String" />
                <asp:Parameter Name="Prenom" Type="String" />
                <asp:Parameter Name="Etat" Type="String" />
                <asp:Parameter Name="ACTIF" Type="Boolean" />
                <asp:Parameter Name="ID" Type="Int32" />
            </UpdateParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="Gvtest" Name="ID" PropertyName="SelectedValue" Type="Int32" />
            </SelectParameters>
            <InsertParameters>
                <asp:Parameter Name="NOM" Type="String" />
                <asp:Parameter Name="Prenom" Type="String" />
                <asp:Parameter Name="Etat" Type="String" />
                <asp:Parameter Name="ACTIF" Type="Boolean" />
            </InsertParameters>
        </asp:SqlDataSource>
    </form>
</body>

si possible de m'aider sur ma question ci-dessous.

merci à vous les gars.