Source code below. I am using an sqldatasorce to populate a datagrid.
I am using datakeyIds.
I am interested in two keys which I have added to the datakeyids,
however if either of the keys is not databound, set to visible=false
or readonly=true, they are unavailable as parameters in my update
statement.
Any ideas how/why this happens and how to get arround it..?
Thanks
Source...
Wrox Home
View Cart | My Account
Support | Contact Us
Search P2P for Advanced
Search
Members:
Participate in discussions or edit your profile.
Login:
Password:
Remember Me
Forgot Your Password?
New Users: Register Now
Forum Tools
View All Forums
View Active Topics
Archives
FAQ
Terms of Use
Get More Wrox For Less!
New Titles for ASP.NET
Professional Community Server
Professional Community Server
Professional ASP.NET 2.0 Databases
Professional ASP.NET 2.0 Databases
Wrox Programmers Reference Series - Learn tips and tricks from the
experts!
p2p.wrox.com Forums
P2P Forum ASP and ASP.NET ASP.NET 2.0 Beginner Missing
parameters in Datagrid .net 2
p2p Community Forums
Need to download code? View our list of code downloads.
New Topic Reply to Topic Printer Friendly
Author Previous Topic Topic Next Topic
kangarolf
Starting Member
1 Posts
Posted - 05/16/2007 : 07:24:56 AM Show Profile Reply with Quote
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 OldValuesParameterFormatString and
ConflictDetection in the sqlSatasource. Any ideas.? Source below.
Thanks
<%@ Page Language="VB" ContentType="text/html"
ResponseEncoding="iso-8859-1" Debug="true" %>
<!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">
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1" />
<title>Untitled 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" AutoGenerateColumns="false"
runat="server" DataKeyIds="OrderID,AmazonID" DataSourceId="srcOrders"
CssClass="grid" autogenerateeditbutton="true" GridLines="Horizontal">
<Columns>
<asp:Boundfield DataField = "OrderID" HeaderText="OrderID"
readonly="true"/>
<asp:TemplateField HeaderText="IT Buy Address">
<ItemTemplate>
<%# Eval("add1") & "<br/>" & Eval("add2") & "<br/>" & Eval("add3")
& "<br/>" & Eval("city") & "<br/><strong>" & Eval("postcode") & "</
strong>" %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Amazon Address">
<ItemTemplate>
<%# Eval("AOshipadd1") & "<br/>" & Eval("AOshipadd2") & "<br/>" &
Eval("AOshipadd3") & "<br/>" & Eval("AOshipcity") & "<br/><strong>" &
Eval("AOshippostcode") & "</strong>" %>
</ItemTemplate>
<edititemtemplate>
<asp:TextBox
id="AOshipadd1"
text='<%# Bind("AOshipadd1")%>'
runat="server" />
<asp:TextBox
id="AOshipadd2"
text='<%# Bind("AOshipadd2")%>'
runat="server" />
<asp:TextBox
id="AOshipadd3"
text='<%# Bind("AOshipadd3")%>'
runat="server" />
<asp:TextBox
id="AOshipcity"
text='<%# Bind("AOshipcity")%>'
runat="server" />
<asp:TextBox
id="AOshippostcode"
text='<%# Bind("AOshippostcode")%>'
runat="server" />
</edititemtemplate>
</asp:TemplateField>
<asp:Boundfield DataField = "ParcelNum" HeaderText="City Link ID" /
>
</Columns>
</asp:GridView>
<asp:SqlDataSource
id="srcOrders"
ConnectionString="MYConnString"
SelectCommand="Select * from Orders"
UpdateCommand="UPDATE ORders SET ParcelNum = @Parcelnum Where (OrderID
= @OrderID); UPDATE OTHER_ORDER_REPORT Set [ship-address-1] =
@AOshipadd1 Where [order-id] = @AmazonID"
Runat="server" />
</div>
</form>
</body>
</html>
