Databases
StackOverflow2013
Postsdbo
POUpdate Command in Gridview stopped working (used to work before and delete, select works fine)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUpdate Command in Gridview stopped working (used to work before and delete, select works fine)
    primarykey
    data
    text
    <p>I have a gridview that uses accessdatasource which has select, insert, delete and update. It used to work before perfectly but all of a sudden the update stopped working while the rest are still working as they supposed to be. I haven't changed anything in the gridview or datasource, but I added new fields to the table but are not displayed in gridview. I tested by deleting the new fields from the table which did not work either. Refreshed the datasoure and gridview as well. Here is the code </p> <pre><code>asp:GridView ID="GridView1" runat="server" AllowSorting="True" ShowFooter="True" EmptyDataText="There are no records for the selection" AutoGenerateColumns="False" CellPadding="4" OnRowCommand="Insert_Click" OnRowUpdating="beforeUpdate" DataKeyNames="Lab Name,Target,Device Name" ForeColor="#333333" HorizontalAlign="Center" EmptyDataRowStyle-HorizontalAlign="Center" EmptyDataRowStyle-VerticalAlign="Middle" Width="1333px" DataSourceID="AccessDataSource8"&gt; &lt;RowStyle BackColor="#F7F6F3" ForeColor="#333333" /&gt; &lt;EmptyDataRowStyle Wrap="False" /&gt; &lt;Columns&gt; &lt;asp:TemplateField ShowHeader="False"&gt; &lt;EditItemTemplate&gt; &lt;asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update" Text="Update"&gt;&lt;/asp:LinkButton&gt; &amp;nbsp;&lt;asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"&gt;&lt;/asp:LinkButton&gt; &lt;/EditItemTemplate&gt; &lt;ItemTemplate&gt; &lt;asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"&gt;&lt;/asp:LinkButton&gt; &amp;nbsp;&lt;asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" OnClientClick="return confirm('Are you sure?');" &gt;&lt;/asp:LinkButton&gt; &lt;/ItemTemplate&gt; &lt;FooterTemplate&gt; &lt;asp:LinkButton ID="LinkButton" runat="server" CommandName="Insert" Text="Insert" ValidationGroup="validate" &gt;&lt;/asp:LinkButton&gt; &lt;/FooterTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField HeaderText="Lab Name" SortExpression="Lab Name"&gt; &lt;ItemTemplate&gt; &lt;asp:Label ID="Label1" runat="server" Text='&lt;%# Bind("[Lab Name]") %&gt;'&gt;&lt;/asp:Label&gt; &lt;/ItemTemplate&gt; &lt;EditItemTemplate&gt; &lt;asp:Label ID="Label1" runat="server" Text='&lt;%# Eval("[Lab Name]") %&gt;'&gt;&lt;/asp:Label&gt; &lt;/EditItemTemplate&gt; &lt;FooterTemplate&gt; &lt;asp:TextBox ID="txtLabname" runat="server" &gt;&lt;/asp:TextBox&gt; &lt;asp:RequiredFieldValidator ID="LabName" runat="server" ControlToValidate="txtLabname" Text="*" ValidationGroup="validate"/&gt; &lt;/FooterTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField HeaderText="Target" SortExpression="Target"&gt; &lt;ItemTemplate&gt; &lt;asp:Label ID="Label2" runat="server" Text='&lt;%# Bind("Target") %&gt;'&gt;&lt;/asp:Label&gt; &lt;/ItemTemplate&gt; &lt;EditItemTemplate&gt; &lt;asp:Label ID="Label2" runat="server" Text='&lt;%# Eval("Target") %&gt;'&gt;&lt;/asp:Label&gt; &lt;/EditItemTemplate&gt; &lt;FooterTemplate&gt; &lt;asp:TextBox ID="txtTarget" runat="server" &gt;&lt;/asp:TextBox&gt; &lt;asp:RequiredFieldValidator ID="Target" runat="server" ControlToValidate="txtTarget" Text="*" ValidationGroup="validate"/&gt; &lt;/FooterTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField HeaderText="Device Name" SortExpression="Device Name"&gt; &lt;ItemTemplate&gt; &lt;asp:Label ID="Label3" runat="server" Text='&lt;%# Bind("[Device Name]") %&gt;'&gt;&lt;/asp:Label&gt; &lt;/ItemTemplate&gt; &lt;EditItemTemplate&gt; &lt;asp:Label ID="Label3" runat="server" Text='&lt;%# Eval("[Device Name]") %&gt;'&gt;&lt;/asp:Label&gt; &lt;/EditItemTemplate&gt; &lt;FooterTemplate&gt; &lt;asp:TextBox ID="txtDevicename" runat="server" &gt;&lt;/asp:TextBox&gt; &lt;asp:RequiredFieldValidator ID="Devicename" runat="server" ControlToValidate="txtDevicename" Text="*" ValidationGroup="validate"/&gt; &lt;/FooterTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField HeaderText="IO Type Requirement" SortExpression="IO Type Requirement"&gt; &lt;ItemTemplate&gt; &lt;asp:Label ID="Label4" runat="server" Text='&lt;%# Bind("[IO Type Requirement]") %&gt;'&gt;&lt;/asp:Label&gt; &lt;/ItemTemplate&gt; &lt;EditItemTemplate&gt; &lt;asp:TextBox ID="TextBox1" runat="server" Text='&lt;%# Bind("[IO Type Requirement]") %&gt;'&gt;&lt;/asp:TextBox&gt; &lt;/EditItemTemplate&gt; &lt;FooterTemplate&gt; &lt;asp:TextBox ID="txtIotyperequirement" runat="server" &gt;&lt;/asp:TextBox&gt; &lt;asp:RequiredFieldValidator ID="Iotyperequirement" runat="server" ControlToValidate="txtIotyperequirement" Text="*" ValidationGroup="validate"/&gt; &lt;/FooterTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField HeaderText="Part Number" SortExpression="Part Number"&gt; &lt;ItemTemplate&gt; &lt;asp:Label ID="Label5" runat="server" Text='&lt;%# Bind("[Part Number]") %&gt;'&gt;&lt;/asp:Label&gt; &lt;/ItemTemplate&gt; &lt;EditItemTemplate&gt; &lt;asp:TextBox ID="TextBox2" runat="server" Text='&lt;%# Bind("[Part Number]") %&gt;'&gt;&lt;/asp:TextBox&gt; &lt;/EditItemTemplate&gt; &lt;FooterTemplate&gt; &lt;asp:TextBox ID="txtPartnumber" runat="server" &gt;&lt;/asp:TextBox&gt; &lt;asp:RequiredFieldValidator ID="Partnumber" runat="server" ControlToValidate="txtPartnumber" Text="*" ValidationGroup="validate"/&gt; &lt;/FooterTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField HeaderText="Sub Part" SortExpression="Sub Part"&gt; &lt;ItemTemplate&gt; &lt;asp:Label ID="Label6" runat="server" Text='&lt;%# Bind("[Sub Part]") %&gt;'&gt;&lt;/asp:Label&gt; &lt;/ItemTemplate&gt; &lt;EditItemTemplate&gt; &lt;asp:TextBox ID="TextBox3" runat="server" Text='&lt;%# Bind("[Sub Part]") %&gt;'&gt;&lt;/asp:TextBox&gt; &lt;/EditItemTemplate&gt; &lt;FooterTemplate&gt; &lt;asp:TextBox ID="txtSubpart" runat="server" &gt;&lt;/asp:TextBox&gt; &lt;asp:RequiredFieldValidator ID="Subpart" runat="server" ControlToValidate="txtSubpart" Text="*" ValidationGroup="validate"/&gt; &lt;/FooterTemplate&gt; &lt;/asp:TemplateField&gt; &lt;asp:TemplateField HeaderText="Subpart Description" SortExpression="Subpart Description"&gt; &lt;ItemTemplate&gt; &lt;asp:Label ID="Label7" runat="server" Text='&lt;%# Bind("[Subpart Description]") %&gt;'&gt;&lt;/asp:Label&gt; &lt;/ItemTemplate&gt; &lt;EditItemTemplate&gt; &lt;asp:TextBox ID="TextBox4" runat="server" Text='&lt;%# Bind("[Subpart Description]") %&gt;'&gt;&lt;/asp:TextBox&gt; &lt;/EditItemTemplate&gt; &lt;FooterTemplate&gt; &lt;asp:TextBox ID="txtSubpartdesc" runat="server" &gt;&lt;/asp:TextBox&gt; &lt;asp:RequiredFieldValidator ID="Subpartdesc" runat="server" ControlToValidate="txtSubpartdesc" Text="*" ValidationGroup="validate"/&gt; &lt;/FooterTemplate&gt; &lt;/asp:TemplateField&gt; &lt;/Columns&gt; &lt;FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /&gt; &lt;PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /&gt; &lt;SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /&gt; &lt;HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /&gt; &lt;EditRowStyle BackColor="#999999" VerticalAlign="Middle" Wrap="False" /&gt; &lt;AlternatingRowStyle BackColor="White" ForeColor="#284775" VerticalAlign="Middle" Wrap="False" /&gt; &lt;/asp:GridView&gt; &lt;asp:AccessDataSource ID="AccessDataSource8" runat="server" CancelSelectOnNullParameter="False" DataFile="~/App_Data/Test.mdb" SelectCommand="SELECT Lab1.[Lab Name], Lab1.[Target], Lab1.[Device Name], Lab1.[IO Type Requirement], Lab1.[Part Number], Lab1.[Sub Part], Lab1.[Subpart Description] FROM Lab1 WHERE (((Lab1.[Lab Name])= [WhichLab] OR [WhichLab] = '0') AND ((Lab1.[Target])= [WhichTarget] OR [WhichTarget] = '0') AND ((Lab1.[Device Name])= [WhichDevice] OR [WhichDevice] = '0') AND ((Lab1.[IO Type Requirement])= [Whichiotyperequirement] OR [Whichiotyperequirement] = '0') AND ((Lab1.[Part Number])= [WhichPartNumber] OR [WhichPartNumber] = '0') AND ((Lab1.[Sub Part])= [WhichSubPart] OR [WhichSubPart] = '0') AND ((Lab1.[Subpart Description])= [WhichSubPartDesc] OR [WhichSubPartDesc] = '0') )" UpdateCommand= " UPDATE [Lab1] SET [IO Type Requirement]= ?, [Part Number]= ?, [Sub Part]= ?, [Subpart Description]= ? WHERE ([Lab Name]= ?) AND ([Target]= ?) AND ([Device Name] = ?)" InsertCommand= "INSERT INTO LAB1 ([Lab Name],[Target],[Device Name],[IO Type Requirement],[Part Number],[Sub Part],[Subpart Description]) VALUES ([WhichLab],[WhichTarget],[WhichDevice],[Whichiotyperequirement],[WhichPartNumber],[WhichSubPart],[WhichSubPartDesc]) " DeleteCommand= " Delete from LAB1 WHERE LAB1.[Lab Name]= [WhichLab] AND Lab1.[Target]=[WhichTarget] AND Lab1.[Device Name]=[WhichDevice]"&gt; &lt;SelectParameters&gt; &lt;asp:ControlParameter ControlID="DropDownList1" Name="Lab Name" ConvertEmptyStringToNull="true" PropertyName="SelectedValue" /&gt; &lt;asp:ControlParameter ControlID="DropDownList2" Name="Target" ConvertEmptyStringToNull="true" PropertyName="SelectedValue" /&gt; &lt;asp:ControlParameter ControlID="DropDownList3" Name="Device Name" ConvertEmptyStringToNull="true" PropertyName="SelectedValue" /&gt; &lt;asp:ControlParameter ControlID="DropDownList4" Name="IO Type Requirement" ConvertEmptyStringToNull="true" PropertyName="SelectedValue" /&gt; &lt;asp:ControlParameter ControlID="DropDownList5" Name="Part Number" ConvertEmptyStringToNull="true" PropertyName="SelectedValue" /&gt; &lt;asp:ControlParameter ControlID="DropDownList6" Name="Sub Part" ConvertEmptyStringToNull="true" PropertyName="SelectedValue" /&gt; &lt;asp:ControlParameter ControlID="DropDownList7" Name="Subpart Description" ConvertEmptyStringToNull="true" PropertyName="SelectedValue" /&gt; &lt;/SelectParameters&gt; &lt;UpdateParameters&gt; &lt;asp:Parameter Name="IO Type Requirement" Type="String"/&gt; &lt;asp:Parameter Name="Part Number" Type="String"/&gt; &lt;asp:Parameter Name="Sub Part" Type="String" /&gt; &lt;asp:Parameter Name="Subpart Description" Type="String"/&gt; &lt;asp:Parameter Name="Lab Name" Type="String"/&gt; &lt;asp:Parameter Name="Target" Type="String"/&gt; &lt;asp:Parameter Name="Device Name" Type="String"/&gt; &lt;/UpdateParameters&gt; &lt;InsertParameters&gt; &lt;asp:Parameter Name="Lab Name" Type="String" /&gt; &lt;asp:Parameter Name="Target" Type="String" /&gt; &lt;asp:Parameter Name="Device Name" Type="String" /&gt; &lt;asp:Parameter Name="IO Type Requirement" Type="String" /&gt; &lt;asp:Parameter Name="Part Number" Type="String" /&gt; &lt;asp:Parameter Name="Sub Part" Type="String" /&gt; &lt;asp:Parameter Name="Subpart Description" Type="String" /&gt; &lt;/InsertParameters&gt; &lt;DeleteParameters&gt; &lt;asp:Parameter Name="Lab Name" Type="String" /&gt; &lt;asp:Parameter Name="Target" Type="String" /&gt; &lt;asp:Parameter Name="Device Name" Type="String" /&gt; &lt;/DeleteParameters&gt; &lt;/asp:AccessDataSource&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USscc
    1. USscc
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COCausesValidation="True" might cause?
      singulars
      1. POUpdate Command in Gridview stopped working (used to work before and delete, select works fine)
      1. USMert
    2. COI have changed it to false and tested as well but did not work.
      singulars
      1. POUpdate Command in Gridview stopped working (used to work before and delete, select works fine)
      1. USscc
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload