[thelist] ASP.NET DataGrid Edit/Update problem

Tab Alleman talleman at Lumpsum.com
Wed Feb 1 08:59:24 CST 2006


Have you verified connectivity/permission from the web host to the database by other scripts?

For instance, if you write an ASP.NET script with a simple ad-hoc INSERT statement in it, and execute the script from the web host, does the row get inserted in the database as expected?


> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Rikter Web Design
> Sent: Tuesday, January 31, 2006 8:14 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] ASP.NET DataGrid Edit/Update problem
> 
> 
> Hi Asif,
> 
> Thanks for responding. Permissions are ok.  Even copied web files to a
> different web host and still same problem.  Even tried with 
> SQL Server vs.
> Access.  Same problem.
> 
> Code was generated by VS2005.  Works perfectly on localhost.
> 
> I checked again and don't see anything wrong with the 
> postback, as it's
> functioning properly everywhere except on all the various web 
> hosts.  One of
> the web hosts I tried, hostmysite.com, told me the code was 
> incorrect---but
> of course not how it was incorrect.  But since it works perfectly on
> localhost, and generated with VS2005, I can't figure out what 
> the problem
> can be.
> 
> Google is useless because I've not found anyone on internet 
> with this same
> problem.  It's the damnest thing.  I just don't get it.  
> 
> Chris
> 
> 
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Asif Suria
> Sent: Tuesday, January 31, 2006 2:59 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] ASP.NET DataGrid Edit/Update problem
> 
> Check out the second argument for the update link. I think 
> the ID is not
> getting passed to the page during postback.
> 
> Another thing to check into is the permissions on the 
> database/table to make
> sure that web users can write or update to it.
> 
> Asif
> 
> ---------------------------------------------------------------
> If the doors of perception were cleansed everything would 
> appear to man as
> it is, infinite. - William Blake.
> 
> Yes, I am blogging @
> http://www.sinletter.com/ablog.aspx
> 
> 
> --- Rikter Web Design <support at rikter.com> wrote:
> 
> > Hi all,
> > 
> > Tearing hair out over this one.  Inserted an ASP.NET
> > Gridview on page with
> > edit ability to update an Access database.  When I
> > go to make edit, no error
> > message occurs, just doesn't update records at all.
> > 
> > Works perfectly on localhost.  Problem is only when
> > on web hosts, but tried
> > two different hosts and problem is the same with
> > both.  Permissions on hosts
> > were checked.
> > 
> > Live page here:
> > http://www.dickanddeedee.com/pwdtest.aspx
> > 
> > Try changing any of the passwords and you'll see
> > what I mean.
> > 
> > Chris
> > 
> > 
> > Code:
> > 
> > <%@ Page Language="VB" %>
> > 
> > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
> > "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
> > 
> > <script runat="server">
> > 
> >     Protected Sub AccessDataSource1_Selecting(ByVal
> > sender As Object, ByVal
> > e As
> >
> System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs)
> > 
> >     End Sub
> > </script>
> > 
> > <html xmlns="http://www.w3.org/1999/xhtml" >
> > <head runat="server">
> >     <title>Untitled Page</title>
> > </head>
> > <body>
> >     <form id="form1" runat="server">
> >     <div>
> >         <asp:AccessDataSource ID="AccessDataSource1"
> > runat="server"
> > DataFile="~/fpdb/listdata.mdb"
> >             DeleteCommand="DELETE FROM [AdminAccess]
> > WHERE [ID] = ?"
> > InsertCommand="INSERT INTO [AdminAccess] ([ID],
> > [Password], [Active]) VALUES
> > (?, ?, ?)"
> >             SelectCommand="SELECT [ID], [Password],
> > [Active] FROM
> > [AdminAccess] WHERE ([AccessLevel] = ?)"
> >             UpdateCommand="UPDATE [AdminAccess] SET
> > [Password] = ?, [Active]
> > = ? WHERE [ID] = ?"
> > OnSelecting="AccessDataSource1_Selecting">
> >             <DeleteParameters>
> >                 <asp:Parameter Name="original_ID"
> > Type="Int32" />
> >             </DeleteParameters>
> >             <UpdateParameters>
> >                 <asp:Parameter Name="Password"
> > Type="String" />
> >                 <asp:Parameter Name="Active"
> > Type="Boolean" />
> >                 <asp:Parameter Name="original_ID"
> > Type="Int32" />
> >             </UpdateParameters>
> >             <SelectParameters>
> >                 <asp:Parameter DefaultValue="2"
> > Name="AccessLevel"
> > Type="Int32" />
> >             </SelectParameters>
> >             <InsertParameters>
> >                 <asp:Parameter Name="ID"
> > Type="Int32" />
> >                 <asp:Parameter Name="Password"
> > Type="String" />
> >                 <asp:Parameter Name="Active"
> > Type="Boolean" />
> >             </InsertParameters>
> >         </asp:AccessDataSource>
> >     
> >     </div>
> >         <asp:GridView ID="GridView1" runat="server"
> > AllowSorting="True"
> > AutoGenerateColumns="False"
> >             DataKeyNames="ID"
> > DataSourceID="AccessDataSource1">
> >             <Columns>
> >                 <asp:CommandField
> > ShowEditButton="True" />
> >                 <asp:BoundField DataField="ID"
> > HeaderText="ID"
> > InsertVisible="False" ReadOnly="True"
> >                     SortExpression="ID" />
> >                 <asp:BoundField DataField="Password"
> > HeaderText="Password"
> > SortExpression="Password" />
> >                 <asp:CheckBoxField
> > DataField="Active" HeaderText="Active"
> > SortExpression="Active" />
> >             </Columns>
> >         </asp:GridView>
> >     </form>
> > </body>
> > </html>
> > 
> > -- 
> > 
> 
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 



More information about the thelist mailing list