Ciao a tutti, spero in un vostro aiuto.
Perchè questa pagina net pur non restituendo errore, non aggiorna e cancella i record?
Il db è mysql.
Cosa sbaglio?
Grazie
codice:<%@ Page Language="C#" AutoEventWireup="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.Odbc" %> <%@ Import Namespace="System.Configuration" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <title>Report</title> <style type="text/css" media="all"> @import "forms.css"; </style> <script runat="server"> public void Page_Load(Object sender, EventArgs e) { OdbcConnection myConnectionString = new OdbcConnection( ConfigurationManager.ConnectionStrings["ConnMySQL"].ConnectionString); myConnectionString.Open(); myConnectionString.Dispose(); myConnectionString.Close(); } </script> </head> <body> <form id="form1" runat="server"> <div> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnMySQL %>" ProviderName="<%$ ConnectionStrings:ConnMySQL.ProviderName %>" SelectCommand="SELECT * FROM tbl_copy ORDER BY myDate DESC" DeleteCommand="DELETE FROM tbl_copy WHERE ID=?" UpdateCommand="UPDATE tbl_copy SET myArea=? WHERE ID=?" DataSourceMode="DataSet" OldValuesParameterFormatString="{0}"> <UpdateParameters> <asp:Parameter Name="ID" Type="Int32" Direction="Input" /> <asp:Parameter Name="myArea" Type="String" Direction="Input" /> <asp:Parameter Name="myUnity" Type="String" Direction="Input" /> </UpdateParameters> <DeleteParameters> <asp:Parameter Name="ID" Type="Int32" Direction="Input" /> </DeleteParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnMySQL %>" ProviderName="<%$ ConnectionStrings:ConnMySQL.ProviderName %>" SelectCommand="SELECT myArea FROM tbl_copy GROUP BY myArea ORDER BY myArea ASC"> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnMySQL %>" ProviderName="<%$ ConnectionStrings:ConnMySQL.ProviderName %>" SelectCommand="SELECT myUnity FROM tbl_copy GROUP BY myUnity ORDER BY myUnity ASC"> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:ConnMySQL %>" ProviderName="<%$ ConnectionStrings:ConnMySQL.ProviderName %>" SelectCommand="SELECT tips FROM tbl_tips ORDER BY tips ASC"> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:ConnMySQL %>" ProviderName="<%$ ConnectionStrings:ConnMySQL.ProviderName %>" SelectCommand="SELECT pers FROM tbl_pers ORDER BY pers ASC"> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource6" runat="server" ConnectionString="<%$ ConnectionStrings:ConnMySQL %>" ProviderName="<%$ ConnectionStrings:ConnMySQL.ProviderName %>" SelectCommand="SELECT Prov FROM tbl_Prov ORDER BY Prov ASC"> </asp:SqlDataSource> <asp:GridView id="EditGrid" DataSourceID="SqlDataSource1" Runat="Server" AutoGenerateColumns="False" DataKeyNames="ID" AutoGenerateEditButton="False" AllowPaging="True" AllowSorting="True" PageSize="10" CellPadding="3" CssClass="first" HeaderStyle-Font-Size="10pt" HeaderStyle-BackColor="#707070" HeaderStyle-ForeColor="#FFFFFF" RowStyle-Font-Size="10pt" RowStyle-VerticalAlign="Top" EditRowStyle-BackColor="Yellow"> <SelectedRowStyle CssClass="first" ForeColor="Red" BackColor="Yellow" Font-Bold="true" /> <Columns> <asp:TemplateField HeaderText=""> <ItemTemplate> <asp:ImageButton ID="ImageButton1" CommandName="Edit" Runat="Server" ImageUrl="modify_icon.gif" OnClientClick="return confirm('Confirm?.');" /> </ItemTemplate> <EditItemTemplate> <asp:ImageButton ID="ImageButton2" CommandName="Update" Runat="Server" ImageUrl="update_icon.gif" OnClientClick="return confirm('Confirm?.');" /> <asp:ImageButton ID="ImageButton3" CommandName="Cancel" Runat="Server" ImageUrl="cancel_icon.gif" OnClientClick="return confirm('Confirm?.');" /> </EditItemTemplate> </asp:TemplateField> <asp:BoundField ReadOnly="True" HeaderText="ID" DataField="ID" SortExpression="ID"/> <asp:TemplateField HeaderText="myDates"> <ItemTemplate> <asp:Label ID="Label1" Text='<%# Eval("myDates") %>' Runat="Server"/> </ItemTemplate> <EditItemTemplate> <asp:TextBox id="EditmyDates" Runat="Server" DataSourceID="SqlDataSource1" DataTextField="myDates" DataValueField="myDates" Font-Size="8pt"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="myArea"> <ItemTemplate> <asp:Label ID="Label2" Text='<%# Eval("myArea") %>' Runat="Server"/> </ItemTemplate> <EditItemTemplate> <asp:DropDownList id="EditmyArea" Runat="Server" DataSourceID="SqlDataSource2" DataTextField="myArea" DataValueField="myArea" SelectedValue='<%# Bind("myArea") %>' Font-Size="8pt"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Unità"> <ItemTemplate> <asp:Label ID="Label3" Text='<%# Eval("myUnity") %>' Runat="Server"/> </ItemTemplate> <EditItemTemplate> <asp:DropDownList id="EditmyUnity" Runat="Server" DataSourceID="SqlDataSource3" DataTextField="myUnity" DataValueField="myUnity" SelectedValue='<%# Bind("myUnity") %>' Font-Size="8pt"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="tips"> <ItemTemplate> <asp:Label ID="Label4" Text='<%# Eval("tips") %>' Runat="Server"/> </ItemTemplate> <EditItemTemplate> <asp:DropDownList id="Edittips" Runat="Server" DataSourceID="SqlDataSource4" DataTextField="tips" DataValueField="tips" SelectedValue='<%# Bind("tips") %>' Font-Size="8pt"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Description"> <ItemTemplate> <asp:Panel ID="Panel1" Width="150px" Height="30px" Runat="Server" ScrollBars="Vertical"> <asp:Label ID="Label5" Text='<%# Eval("Description") %>' Runat="Server"/> </asp:Panel> </ItemTemplate> <EditItemTemplate> <asp:TextBox id="EditDescription" Runat="Server" Text='<%# Bind("Description") %>' TextMode="MultiLine" Rows="3" Width="150px" Font-Name="Arial" Font-Size="8pt"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Pers"> <ItemTemplate> <asp:Label ID="Label6" Text='<%# Eval("pers") %>' Runat="Server"/> </ItemTemplate> <EditItemTemplate> <asp:DropDownList id="EditPers" Runat="Server" DataSourceID="SqlDataSource5" DataTextField="pers" DataValueField="pers" SelectedValue='<%# Bind("pers") %>' Font-Size="8pt"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="din"> <ItemTemplate> <asp:Panel ID="Panel2" Width="150px" Height="30px" Runat="Server" ScrollBars="Vertical"> <asp:Label ID="Label7" Text='<%# Eval("din") %>' Runat="Server"/> </asp:Panel> </ItemTemplate> <EditItemTemplate> <asp:TextBox id="EditDin" Runat="Server" Text='<%# Bind("din") %>' TextMode="MultiLine" Rows="3" Width="150px" Font-Name="Arial" Font-Size="8pt"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="notes"> <ItemTemplate> <asp:Panel ID="Panel3" Width="150px" Height="30px" Runat="Server" ScrollBars="Vertical"> <asp:Label ID="Label8" Text='<%# Eval("notes") %>' Runat="Server"/> </asp:Panel> </ItemTemplate> <EditItemTemplate> <asp:TextBox id="EditNotes" Runat="Server" Text='<%# Bind("notes") %>' TextMode="MultiLine" Rows="3" Width="150px" Font-Name="Arial" Font-Size="8pt"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Provv"> <ItemTemplate> <asp:Label ID="Label9" Text='<%# Eval("Provv") %>' Runat="Server"/> </ItemTemplate> <EditItemTemplate> <asp:DropDownList id="EditProvv" Runat="Server" DataSourceID="SqlDataSource6" DataTextField="Provv" DataValueField="Provv" SelectedValue='<%# Bind("Provv") %>' Font-Size="8pt"/> </EditItemTemplate> </asp:TemplateField> </Columns> <PagerSettings Position="TopAndBottom" FirstPageText="First page" LastPageText=""Last page"" Mode="NextPreviousFirstLast" /> <PagerSettings /> </asp:GridView> </div> </form> </body> </html>
Rispondi quotando