Go Back   Access World Forums > Apps and Windows > Web Design and Development > ASP and ASP.NET

 
Reply
 
Thread Tools Rating: Thread Rating: 4 votes, 5.00 average. Display Modes
Old 10-21-2011, 02:27 AM   #1
bunny
Newly Registered User
 
Join Date: Oct 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
bunny is on a distinguished road
AccessDataSource does not update

Hi there, Im using the following AccessDataSource (Connected to a datagrid) to try UPDATE bokks details on a database I'm working on, but it does not update or even give me any errors

Is there anything obvious I'm doing wrong with the AccessDataSource?
here is the code
<form id="form1" runat="server">

<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/database/books.mdb" SelectCommand="SELECT * FROM [books]"
UpdateCommand="UPDATE books SET bookName =@bookName, boyear =@boyear, puplisher_id =@puplisher_id where book_id=@book_id"></asp:AccessDataSource>

<center>
<asp:GridView ID="bok" runat="server" AutoGenerateColumns="False"
DataKeyNames="book_id" DataSourceID="AccessDataSource1">
<Columns>
<asp:BoundField DataField="book_id" HeaderText="book_id" ReadOnly="True"
SortExpression="book_id"/>
<asp:BoundField DataField="bookName" HeaderText="bookName"
SortExpression="bookName"/>
<asp:BoundField DataField="boyear" HeaderText="boyear"
SortExpression="boyear"/>
<asp:BoundField DataField="puplisher_id" HeaderText="puplisher_id"
SortExpression="puplisher_id"/>
<asp:BoundField DataField="ispublish" HeaderText="ispublish"
SortExpression="ispublish"/>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"/>
</Columns>
</asp:GridView>


</center>
</form>


Last edited by bunny; 10-21-2011 at 02:39 AM.
bunny is offline   Reply With Quote
Old 10-26-2011, 07:18 AM   #2
bunny
Newly Registered User
 
Join Date: Oct 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
bunny is on a distinguished road
Re: AccessDataSource does not update

no body here
bunny is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Query - uses selected record to make calculation and uses this to update all! DSLNVL Queries 3 08-01-2011 05:50 PM
Update Query - Update Duplicate value from Single Matching value from another table xxx Queries 4 06-14-2011 11:28 PM
UPDATE problems with AccessDataSource aikighost ASP and ASP.NET 2 08-16-2009 08:10 PM
Update multiple records from continous form - UPDATE Query Lyconal Queries 2 06-08-2009 02:00 AM
UPDATE query (not update if certain critea exist in the destination table) homer2002 Queries 6 02-15-2003 02:15 PM




All times are GMT -8. The time now is 10:15 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World