Hi all,
I have a problem in that in my datagrid any datakeys which are not
visible and editable in the datagrid (if the column visibility is set
to false or readonly is set to true) do not seem to be passed back to
the script and are unavailable as parameters for my updatecommand.
I have tried with and without OldValuesParame terFormatString and
ConflictDetecti on in the sqlSatasource. Any ideas.? Source below.
Thanks
<%@ Page Language="VB" ContentType="te xt/html"
ResponseEncodin g="iso-8859-1" Debug="true" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://
www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1" />
<title>Untitl ed Document</title>
<style type="text/css">
..grid {width:550px; border:1px solid;}
..grid td {vertical-align: top; }
..grid th {background-color:#0099FF; color:#FFFFFF;}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="grdOrders" AutoGenerateCol umns="false"
runat="server" DataKeyIds="Ord erID,AmazonID" DataSourceId="s rcOrders"
CssClass="grid" autogenerateedi tbutton="true" GridLines="Hori zontal">
<Columns>
<asp:Boundfie ld DataField = "OrderID" HeaderText="Ord erID"
readonly="true"/>
<asp:TemplateFi eld HeaderText="IT Buy Address">
<ItemTemplate >
<%# Eval("add1") & "<br/>" & Eval("add2") & "<br/>" & Eval("add3")
& "<br/>" & Eval("city") & "<br/><strong>" & Eval("postcode" ) & "</
strong>" %>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:TemplateFi eld HeaderText="Ama zon Address">
<ItemTemplate >
<%# Eval("AOshipadd 1") & "<br/>" & Eval("AOshipadd 2") & "<br/>" &
Eval("AOshipadd 3") & "<br/>" & Eval("AOshipcit y") & "<br/><strong>" &
Eval("AOshippos tcode") & "</strong>" %>
</ItemTemplate>
<edititemtempla te>
<asp:TextBox
id="AOshipadd1 "
text='<%# Bind("AOshipadd 1")%>'
runat="server" />
<asp:TextBox
id="AOshipadd2 "
text='<%# Bind("AOshipadd 2")%>'
runat="server" />
<asp:TextBox
id="AOshipadd3 "
text='<%# Bind("AOshipadd 3")%>'
runat="server" />
<asp:TextBox
id="AOshipcity "
text='<%# Bind("AOshipcit y")%>'
runat="server" />
<asp:TextBox
id="AOshippostc ode"
text='<%# Bind("AOshippos tcode")%>'
runat="server" />
</edititemtemplat e>
</asp:TemplateFie ld>
<asp:Boundfie ld DataField = "ParcelNum" HeaderText="Cit y Link
ID" /
</Columns>
</asp:GridView>
<asp:SqlDataSou rce
id="srcOrders"
ConnectionStrin g="MYConnString "
SelectCommand=" Select * from Orders"
UpdateCommand=" UPDATE ORders SET ParcelNum = @Parcelnum Where (OrderID
= @OrderID); UPDATE OTHER_ORDER_REP ORT Set [ship-address-1] =
@AOshipadd1 Where [order-id] = @AmazonID"
Runat="server" />
</div>
</form>
</body>
</html>
