formview update problem

S

sdash

I'm working on a simple formview screen that should update a SQL Server 2000
record. I'm sure there must be something simple wrong, but when I press
update, the screen refreshes and the changes are not committed to the table.
Can anyone give me some suggestions here?

Thanks in advance (code below)

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="EditItem.aspx.cs"
Inherits="EditItem" %>

<%@ Register Src="UserControls/LoginInfo.ascx" TagName="LoginInfo"
TagPrefix="uc2" %>

<%@ Register Src="UserControls/HeaderControl.ascx" TagName="HeaderControl"
TagPrefix="uc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>"Edit Item" </title>

</head>

<body>

<form id="form1" runat="server" method="post">

<table style="width: 100%; height: 80%">

<tr>

<td style="height: 481px; width:30%" valign="top">

<uc1:HeaderControl ID="HeaderControl1" runat="server" />

<uc2:logininfo id="LoginInfo1" runat="server"></uc2:logininfo>


</td>

<td style="width: 70%; height: 481px;">

<asp:FormView ID="FormView1" runat="server" DataKeyNames="id"
DataSourceID="SqlDataSource1"
OnPageIndexChanging="FormView1_PageIndexChanging" DefaultMode="Edit"
DataMember="DefaultView" Height="472px">

<EditItemTemplate>

first:

<asp:TextBox ID="firstTextBox" runat="server" Text='<%# Bind("first") %>'>

</asp:TextBox><br />

spouse:

<asp:TextBox ID="spouseTextBox" runat="server" Text='<%# Bind("spouse") %>'>

</asp:TextBox><br />

last:

<asp:TextBox ID="lastTextBox" runat="server" Text='<%# Bind("last") %>'
AutoPostBack="True"></asp:TextBox><br />

address1:

<asp:TextBox ID="address1TextBox" runat="server" Text='<%# Bind("address1")
%>'>

</asp:TextBox><br />

address2:

<asp:TextBox ID="address2TextBox" runat="server" Text='<%# Bind("address2")
%>'>

</asp:TextBox><br />

city:

<asp:TextBox ID="cityTextBox" runat="server" Text='<%# Bind("city") %>'>

</asp:TextBox><br />

state:

<asp:TextBox ID="stateTextBox" runat="server" Text='<%# Bind("state") %>'>

</asp:TextBox><br />

zip:

<asp:TextBox ID="zipTextBox" runat="server" Text='<%# Bind("zip") %>'>

</asp:TextBox><br />

Phone:

<asp:TextBox ID="PhoneTextBox" runat="server" Text='<%# Bind("Phone") %>'>

</asp:TextBox><br />

email:

<asp:TextBox ID="emailTextBox" runat="server" Text='<%# Bind("email") %>'>

</asp:TextBox><br />

id:

<asp:Label ID="idLabel1" runat="server" Text='<%# Eval("id")
%>'></asp:Label><br />

singer:


resp_code:

<asp:TextBox ID="resp_codeTextBox" runat="server" Text='<%#
Bind("resp_code") %>'>

</asp:TextBox><br />

source:

<asp:TextBox ID="sourceTextBox" runat="server" Text='<%# Bind("source") %>'>

</asp:TextBox><br />

added:

<asp:TextBox ID="addedTextBox" runat="server" Text='<%# Bind("added") %>'>

</asp:TextBox><br />

lastedited:

<asp:TextBox ID="lasteditedTextBox" runat="server" Text='<%#
Bind("lastedited") %>'>

</asp:TextBox><br />

address2use:

<asp:TextBox ID="address2useTextBox" runat="server" Text='<%#
Bind("address2use") %>'>

</asp:TextBox><br />

<br />

<asp:LinkButton ID="UpdateButton" runat="server" CommandName="Update"

Text="Update"> </asp:LinkButton>

<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel"

Text="Cancel">

</asp:LinkButton>

</EditItemTemplate>

<InsertItemTemplate>

first:

<asp:TextBox ID="firstTextBox" runat="server" Text='<%# Bind("first") %>'>

</asp:TextBox><br />

spouse:

<asp:TextBox ID="spouseTextBox" runat="server" Text='<%# Bind("spouse") %>'>

</asp:TextBox><br />

last:

<asp:TextBox ID="lastTextBox" runat="server" Text='<%# Bind("last") %>'>

</asp:TextBox><br />

address1:

<asp:TextBox ID="address1TextBox" runat="server" Text='<%# Bind("address1")
%>'>

</asp:TextBox><br />

address2:

<asp:TextBox ID="address2TextBox" runat="server" Text='<%# Bind("address2")
%>'>

</asp:TextBox><br />

city:

<asp:TextBox ID="cityTextBox" runat="server" Text='<%# Bind("city") %>'>

</asp:TextBox><br />

state:

<asp:TextBox ID="stateTextBox" runat="server" Text='<%# Bind("state") %>'>

</asp:TextBox><br />

zip:

<asp:TextBox ID="zipTextBox" runat="server" Text='<%# Bind("zip") %>'>

</asp:TextBox><br />

Phone:

<asp:TextBox ID="PhoneTextBox" runat="server" Text='<%# Bind("Phone") %>'>

</asp:TextBox><br />

email:

<asp:TextBox ID="emailTextBox" runat="server" Text='<%# Bind("email") %>'>

</asp:TextBox><br />

singer:

<asp:CheckBox ID="singerCheckBox" runat="server" Checked='<%# Bind("singer")
%>' /><br />

resp_code:

<asp:TextBox ID="resp_codeTextBox" runat="server" Text='<%#
Bind("resp_code") %>'>

</asp:TextBox><br />

source:

<asp:TextBox ID="sourceTextBox" runat="server" Text='<%# Bind("source") %>'>

</asp:TextBox><br />

added:

<asp:TextBox ID="addedTextBox" runat="server" Text='<%# Bind("added") %>'>

</asp:TextBox><br />

lastedited:

<asp:TextBox ID="lasteditedTextBox" runat="server" Text='<%#
Bind("lastedited") %>'>

</asp:TextBox><br />

address2use:

<asp:TextBox ID="address2useTextBox" runat="server" Text='<%#
Bind("address2use") %>'>

</asp:TextBox><br />

<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"
CommandName="Insert"

Text="Insert">

</asp:LinkButton>

<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel"

Text="Cancel">

</asp:LinkButton>

</InsertItemTemplate>

<ItemTemplate>

Last:

<asp:Label ID="lastLabel" runat="server" Text='<%# Bind("last")
%>'></asp:Label>&nbsp;

First:

<asp:Label ID="firstLabel" runat="server" Text='<%# Bind("first")
%>'></asp:Label><br />

<br />

spouse:

<asp:Label ID="spouseLabel" runat="server" Text='<%# Bind("spouse")
%>'></asp:Label><br />

&nbsp;<br />

address1:

<asp:Label ID="address1Label" runat="server" Text='<%# Bind("address1")
%>'></asp:Label><br />

address2:

<asp:Label ID="address2Label" runat="server" Text='<%# Bind("address2")
%>'></asp:Label><br />

city:

<asp:Label ID="cityLabel" runat="server" Text='<%# Bind("city") %>'
Width="130px"></asp:Label>&nbsp;

state:

<asp:Label ID="stateLabel" runat="server" Text='<%# Bind("state")
%>'></asp:Label>

<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource1"

DataTextField="state" DataValueField="state" SelectedValue='<%#
Bind("state") %>'>

</asp:DropDownList><br />

<br />

zip:

<asp:Label ID="zipLabel" runat="server" Text='<%# Bind("zip")
%>'></asp:Label><br />

<br />

Phone:

<asp:Label ID="PhoneLabel" runat="server" Text='<%# Bind("Phone")
%>'></asp:Label><br />

<br />

email:

<asp:Label ID="emailLabel" runat="server" Text='<%# Bind("email")
%>'></asp:Label><br />

<br />

id:

<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id")
%>'></asp:Label><br />

<br />

singer:

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("singer")
%>'></asp:TextBox><br />

<br />

resp_code:

<asp:Label ID="resp_codeLabel" runat="server" Text='<%# Bind("resp_code")
%>'></asp:Label><br />

<br />

source:

<asp:Label ID="sourceLabel" runat="server" Text='<%# Bind("source")
%>'></asp:Label><br />

<br />

added:

<asp:Label ID="addedLabel" runat="server" Text='<%# Bind("added")
%>'></asp:Label><br />

<br />

lastedited:

<asp:Label ID="lasteditedLabel" runat="server" Text='<%# Bind("lastedited")
%>'></asp:Label><br />

<br />

address2use:

<asp:Label ID="address2useLabel" runat="server" Text='<%#
Bind("address2use") %>'></asp:Label><br />

<asp:Button ID="Button1" runat="server" CommandArgument="update"
Text="Update" />

<br />

<br />

</ItemTemplate>

<EditRowStyle HorizontalAlign="Left" />

</asp:FormView>

&nbsp;

</td>

</tr>


</table>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$
ConnectionStrings:KantoreiConnectionString %>"

SelectCommand="SELECT * FROM [dbperson] WHERE ([id] = @id2)"

DeleteCommand="DELETE FROM [dbperson] WHERE [id] = @original_id AND [first]
= @original_first AND [spouse] = @original_spouse AND [last] =
@original_last AND [address1] = @original_address1 AND [address2] =
@original_address2 AND [city] = @original_city AND [state] = @original_state
AND [zip] = @original_zip AND [Phone] = @original_Phone AND (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formview not updating data correctly 0
FormView not updating 1
DetailsView Update command working, but it wipes out my record with null values 0
How do I insert a record using Wizard? 0
DetailsView not updating 2
ItemInserted Event Help 0
Declaring controls in FormView 1
Insert Command Help 0

Members online

Total: 41 (members: 2, guests: 39)
Robots: 422

Forum statistics

Threads
473,770
Messages
2,569,583
Members
45,075
Latest member
MakersCBDBloodSupport

Latest Threads

Top