Salve gente , ho un gridview che mi deve permettere di visualizzare e modificare
i record in una tabella . . .
Il problema è che non mi aggiorna nessun record quando premo sull'aggiorna di una riga . . .
Il codice è il seguente :
Magari manca un aggancio o qualcosa , cmq non riesco a capirecodice:<%@ Page Language="C#" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server" /> <div> <asp:GridView ID="GridView1" AllowSorting="True" AllowPaging="True" Runat="server" DataSourceID="MySqlBambaland" AutoGenerateEditButton="True" DataKeyNames="id_dog" AutoGenerateColumns="False"> <Columns> <asp:BoundField HeaderText="ID" DataField="id_dog" SortExpression="id_dog" ReadOnly="True"/> <asp:BoundField HeaderText="Sesso" DataField="sex" SortExpression="sex" /> <asp:BoundField HeaderText="Nome" DataField="name" SortExpression="name" /> <asp:BoundField HeaderText="Nome completo" DataField="full_name" SortExpression="full_name" /> <asp:BoundField HeaderText="Data Nasciata" DataField="born_date" SortExpression="born_date" /> <asp:BoundField HeaderText="Commento" DataField="comment" SortExpression="comment" /> <asp:BoundField HeaderText="Peso" DataField="weight" SortExpression="weight" /> <asp:BoundField HeaderText="Altezza" DataField="height" SortExpression="height" /> <asp:BoundField HeaderText="Genitori" DataField="parents" SortExpression="parents" /> <asp:BoundField HeaderText="Linea Sangue" DataField="blood_line" SortExpression="blood_line" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="MySqlBambaland" runat="server" ConnectionString="<%$ ConnectionStrings:bambalandConnectionString %>" ProviderName="<%$ ConnectionStrings:bambalandConnectionString.ProviderName %>" SelectCommand="SELECT DISTINCT id_dog, sex, name, full_name, born_date, comment, weight, height, parents, blood_line FROM tbl_dog" UpdateCommand="UPDATE tbl_dog SET sex=@sex, name=name, full_name=@full_name, born_date=@born_date, comment=@comment, weight=@weight, height=@height, parents=@parents, blood_line=@blood_line WHERE (id_dog = @id_dog)"> </asp:SqlDataSource> </div> </form> </body> </html>
Mi pare vi sia tutto
Rispondi quotando