R
rob merritt
Hi
I am trying to update via an datagrid only nothing seems to happen
how would I diplay what the update query looks like msgbox
reponse.write? where do I put em?
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<script runat="server">
void DetailsView1_ItemUpdated(Object sender,
DetailsViewUpdatedEventArgs e)
{
GridView1.DataBind();
}
void DetailsView1_ItemInserted(Object sender,
DetailsViewInsertedEventArgs e)
{
GridView1.DataBind();
}
void DetailsView1_ItemDeleted(Object sender,
DetailsViewDeletedEventArgs e)
{
GridView1.DataBind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Editing Access Database</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:AccessDataSource ID="AccessDataSource1" Runat="server"
DataFile="data\pubs.mdb"
SelectCommand="select * from [authors],[books] where au_id
= author_key" >
</asp:AccessDataSource>
<asp:GridView ID="GridView1" Runat="server" AllowPaging="True"
AllowSorting="True" DataSourceID="AccessDataSource1"
DataKeyNames="au_id" AutoGenerateSelectButton="True">
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource2" Runat="server"
DataFile="data\pubs.mdb"
SelectCommand="select * from [authors],[books] where au_id
= author_key"
DeleteCommand="DELETE FROM [authors] WHERE [au_id] = ?"
UpdateCommand="UPDATE [books] SET [book_title] = ? WHERE
[author_key] = ?"
InsertCommand="INSERT INTO [authors] ([au_id], [au_lname],
[au_fname], [phone], [address], [city], [state], [zip], [contract],
[author_key], [book_title]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
FilterExpression="au_id='@au_id'">
<FilterParameters>
<asp:ControlParameter Name="au_id"
ControlID="GridView1"
PropertyName="SelectedValue"></asp:ControlParameter>
</FilterParameters>
</asp:AccessDataSource>
<asp
etailsView ID="DetailsView1" Runat="server"
AutoGenerateDeleteButton="True"
AutoGenerateEditButton="True"
DataSourceID="AccessDataSource2" DataKeyNames="au_id"
AutoGenerateInsertButton="True"
onitemupdated="DetailsView1_ItemUpdated"
oniteminserted="DetailsView1_ItemInserted"
onitemdeleted="DetailsView1_ItemDeleted">
</aspetailsView>
</div>
</form>
</body>
</html>
I am trying to update via an datagrid only nothing seems to happen
how would I diplay what the update query looks like msgbox
reponse.write? where do I put em?
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<script runat="server">
void DetailsView1_ItemUpdated(Object sender,
DetailsViewUpdatedEventArgs e)
{
GridView1.DataBind();
}
void DetailsView1_ItemInserted(Object sender,
DetailsViewInsertedEventArgs e)
{
GridView1.DataBind();
}
void DetailsView1_ItemDeleted(Object sender,
DetailsViewDeletedEventArgs e)
{
GridView1.DataBind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Editing Access Database</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:AccessDataSource ID="AccessDataSource1" Runat="server"
DataFile="data\pubs.mdb"
SelectCommand="select * from [authors],[books] where au_id
= author_key" >
</asp:AccessDataSource>
<asp:GridView ID="GridView1" Runat="server" AllowPaging="True"
AllowSorting="True" DataSourceID="AccessDataSource1"
DataKeyNames="au_id" AutoGenerateSelectButton="True">
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource2" Runat="server"
DataFile="data\pubs.mdb"
SelectCommand="select * from [authors],[books] where au_id
= author_key"
DeleteCommand="DELETE FROM [authors] WHERE [au_id] = ?"
UpdateCommand="UPDATE [books] SET [book_title] = ? WHERE
[author_key] = ?"
InsertCommand="INSERT INTO [authors] ([au_id], [au_lname],
[au_fname], [phone], [address], [city], [state], [zip], [contract],
[author_key], [book_title]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
FilterExpression="au_id='@au_id'">
<FilterParameters>
<asp:ControlParameter Name="au_id"
ControlID="GridView1"
PropertyName="SelectedValue"></asp:ControlParameter>
</FilterParameters>
</asp:AccessDataSource>
<asp
etailsView ID="DetailsView1" Runat="server"AutoGenerateDeleteButton="True"
AutoGenerateEditButton="True"
DataSourceID="AccessDataSource2" DataKeyNames="au_id"
AutoGenerateInsertButton="True"
onitemupdated="DetailsView1_ItemUpdated"
oniteminserted="DetailsView1_ItemInserted"
onitemdeleted="DetailsView1_ItemDeleted">
</asp
etailsView></div>
</form>
</body>
</html>