Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old January 31st, 2006, 11:22 PM
Registered User
 
Join Date: Jan 2006
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Gridview not updating database on Web Host

Hi all,

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, it just doesn't update records in the .mdb file at all. Even tried with SQL Server vs. Access. Same problem.


However, it updates perfectly on localhost. Problem is only on web hosts. Tried different hosts and problem is the same with all of them. Directory and database file permissions on hosts were checked and are not the problem. Code was generated by VS2005.

Live page here: http://www.dickanddeedee.com/pwdtest.aspx

Try changing any of the passwords and you'll see what I mean.

Anyone have any ideas as to what is going on? It seems like a javascript problem from asp.net 2.0? Code from page is below.

Thanks in advance,

Christopher

<%@ Page Language="VB" CodeFile="pwdtest.aspx.vb" Inherits="pwdtest" %>
<% @Import Namespace="System.Data.OleDb" %>

<!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 name="form1" id="form1" runat="server">
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:apdtConnectionString %>"
            DeleteCommand="DELETE FROM [AdminAccess] WHERE [ID] = @original_ID" InsertCommand="INSERT INTO [AdminAccess] ([Password], [Active]) VALUES (@Password, @Active)"
            SelectCommand="SELECT [ID], [Password], [Active] FROM [AdminAccess]" UpdateCommand="UPDATE [AdminAccess] SET [Password] = @Password, [Active] = @Active WHERE [ID] = @original_ID">
            <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>
            <InsertParameters>
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="Active" Type="Boolean" />
            </InsertParameters>
        </asp:SqlDataSource>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
            DataSourceID="SqlDataSource1">
            <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>
Reply With Quote
  #2 (permalink)  
Old February 1st, 2006, 04:21 PM
Friend of Wrox
 
Join Date: Apr 2005
Location: Fort Walton Beach, FL, USA.
Posts: 190
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Christopher:
I don't know if you have the book Beginning ASP.Net 2.0. If you do, consult
page 225 Chapter 7, 2nd paragraph. It talks about AutoPostBack.
I just happened to read this 5 minutes after having read your topic.

If you do not have the book, I quote from the paragraph above:

"One additional property is of importance for all of the selection lists. AUTOPOSTBACK will automatically post back to the server when the list selection changes. This is critical if there is code in the post back event that you want to execute to reflect the user's selection, such as re-rendering a GridView to show a limited set of records based on the user's selection from a list box."

Hope this help.

VictorVictor

Reply With Quote
  #3 (permalink)  
Old February 1st, 2006, 04:51 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Are you running a beta version of the .NET framework on your localhost?

If so, check your parameters that start with original_. In the beta timeframe, this was added for concurrency support, but was changed in the final version.

Try removing all the original_ prefixes and see if that helps.


Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #4 (permalink)  
Old February 2nd, 2006, 10:54 PM
Registered User
 
Join Date: Jan 2006
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

VictorVictor and Imar,

Thanks for responding so quickly. Imar, I examined the code and you're right, it added an original_. I removed that and it works perfectly.

Will also check out Beginning ASP.Net 2.0. Thanks again to you both for such great feedback and exactly the answer I needed.

Sincerely,

Christopher
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
JSP Web host ironchef Pro JSP 1 December 3rd, 2007 11:47 PM
Updating a gridview control w/access database p3aul ASP.NET 1.0 and 1.1 Professional 0 October 2nd, 2007 06:14 PM
problems with asp database and web host drb2k2 ASP.NET 2.0 Basics 1 May 30th, 2006 03:27 AM
How do I host a web application ? nidhinasthra Classic ASP Basics 1 July 6th, 2005 10:57 AM
Need an Amazing ASP Web Host! Aaron Edwards Classic ASP Basics 1 August 2nd, 2004 01:47 PM



All times are GMT -4. The time now is 02:30 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.